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_REGION_LOCATIONS

Line 418: FROM MSC_ST_REGION_LOCATIONS msrl

414: msrl.LAST_UPDATE_DATE,
415: msrl.LAST_UPDATE_LOGIN,
416: msrl.SR_INSTANCE_ID,
417: msrl.REFRESH_NUMBER
418: FROM MSC_ST_REGION_LOCATIONS msrl
419: WHERE msrl.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
420:
421: CURSOR c10 IS
422: SELECT DISTINCT

Line 1491: Also, the data pulled into the msc_st_region_locations will depend on

1487: -- 4. MSC_REGION_SITES
1488:
1489: Changed row by row processing to do bulk update/insert
1490:
1491: Also, the data pulled into the msc_st_region_locations will depend on
1492: the value of the profile, MSC_COLLECTION_WINDOW_FOR_TP_CHANGES.
1493: We will delete/truncate this ods tables only if the profile is null or 0
1494:
1495: */

Line 1696: UPDATE MSC_ST_REGION_LOCATIONS

1692:
1693: /* ------------- MSC_REGION_LOCATIONS ------------- */
1694: BEGIN -- load for MSC_REGION_LOCATIONS
1695: /* Updating Who cols of Staging Tables */
1696: UPDATE MSC_ST_REGION_LOCATIONS
1697: SET
1698: REFRESH_NUMBER = MSC_CL_COLLECTION.v_last_collection_id,
1699: LAST_UPDATE_DATE = MSC_CL_COLLECTION.v_current_date,
1700: LAST_UPDATED_BY = MSC_CL_COLLECTION.v_current_user,