eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_CL_OTHER_ODS_LOAD dependencies on MSC_ST_ZONE_REGIONS

Line 400: FROM MSC_ST_ZONE_REGIONS mszr

396: mszr.LAST_UPDATE_DATE,
397: mszr.LAST_UPDATE_LOGIN,
398: mszr.SR_INSTANCE_ID,
399: mszr.REFRESH_NUMBER
400: FROM MSC_ST_ZONE_REGIONS mszr
401: WHERE mszr.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
402: /* Changed Refresh_id to Refresh_number */
403: CURSOR c9 IS
404: SELECT

Line 1603: UPDATE MSC_ST_ZONE_REGIONS

1599: /* ------------- MSC_ZONE_REGIONS ------------- */
1600:
1601: BEGIN -- load for MSC_ZONE_REGIONS
1602: /* Updating Who cols of Staging Tables */
1603: UPDATE MSC_ST_ZONE_REGIONS
1604: SET
1605: REFRESH_NUMBER = MSC_CL_COLLECTION.v_last_collection_id,
1606: LAST_UPDATE_DATE = MSC_CL_COLLECTION.v_current_date,
1607: LAST_UPDATED_BY = MSC_CL_COLLECTION.v_current_user,