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.MRP_CL_REFRESH_SNAPSHOT dependencies on ALL_SNAPSHOT_LOGS

Line 906: FROM ALL_SNAPSHOT_LOGS

902: begin
903:
904: SELECT LOG_TABLE
905: INTO lv_mlog_tab_name
906: FROM ALL_SNAPSHOT_LOGS
907: WHERE MASTER = upper(pTABLE_NAME)
908: AND LOG_OWNER = upper(lv_base_schema)
909: AND ROWNUM = 1;
910:

Line 1073: ' SELECT LOG_TABLE FROM ALL_SNAPSHOT_LOGS '

1069: lv_master_tbl := p_table;
1070: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'lv_master_tbl - ' || p_base_schema || '.' || lv_master_tbl);
1071:
1072: EXECUTE IMMEDIATE
1073: ' SELECT LOG_TABLE FROM ALL_SNAPSHOT_LOGS '
1074: || ' WHERE MASTER = :lv_master_tbl AND '
1075: || ' LOG_OWNER = :p_schema AND '
1076: || ' ROWNUM = 1'
1077: INTO lv_mlog_tab_name