DBA Data[Home] [Help]

APPS.MRP_CL_REFRESH_SNAPSHOT dependencies on ALL_SNAPSHOT_LOGS

Line 934: FROM ALL_SNAPSHOT_LOGS

930: begin
931:
932: SELECT LOG_TABLE
933: INTO lv_mlog_tab_name
934: FROM ALL_SNAPSHOT_LOGS
935: WHERE MASTER = upper(pTABLE_NAME)
936: AND LOG_OWNER = upper(lv_base_schema)
937: AND ROWNUM = 1;
938:

Line 1101: ' SELECT LOG_TABLE FROM ALL_SNAPSHOT_LOGS '

1097: lv_master_tbl := p_table;
1098: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'lv_master_tbl - ' || p_base_schema || '.' || lv_master_tbl);
1099:
1100: EXECUTE IMMEDIATE
1101: ' SELECT LOG_TABLE FROM ALL_SNAPSHOT_LOGS '
1102: || ' WHERE MASTER = :lv_master_tbl AND '
1103: || ' LOG_OWNER = :p_schema AND '
1104: || ' ROWNUM = 1'
1105: INTO lv_mlog_tab_name