In this topic you will learn how to Run the ZZCLEAN_REQ_ACTIVITY Query.

NOTE: This query must be run in the PS9FSRPT (Reports) database.

Click the HTML link related to the CLEANUP_REQ_ACTIVITY query.

Enter the desired information into the Business Unit field. Enter "LSUSH".

Enter the desired information into the From/To field. Enter "110115".

Enter the desired information into the Accounting Date To field. Enter "123115".

Click the View Results button.

NOTE: It may take several minutes for the results to display since the data is being pulled from many tables.

Enter the desired information into the Beg Accounting Date field. Enter "110115".

Enter the desired information into the End Accounting Date field. Enter "123115".

NOTE: Using the wildcard will allow you to retrieve results for all department that begin "10501"

Enter the desired information into the Business Unit field. Enter "LSUSH".

View the Report

This completes Running the ZZCLEANUP_REQ_ACTIVITY query.

Enter the desired information into the Business Unit field. Enter a valid value e.g. "LSUSH".

Enter the desired information into the From/To field. Enter a valid value e.g. "110115".

Enter the desired information into the Accounting Date To field. Enter a valid value e.g. "123115".

Enter the desired information into the Beg Accounting Date field. Enter a valid value e.g. "110115".

Enter the desired information into the End Accounting Date field. Enter a valid value e.g. "123115".

NOTE: Using the wildcard will allow you to retrieve results for all department that begin "10501"

Enter the desired information into the Business Unit field. Enter a valid value e.g. "LSUSH".