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.OPI_COLLECTION_HOOK_P dependencies on OPI_EDW_IPS_NET_CHG

Line 21: execute immediate 'truncate table ' || g_opi_schema || '.OPI_EDW_IPS_NET_CHG';

17: END IF;
18:
19: execute immediate 'truncate table ' || g_opi_schema || '.OPI_EDW_IDS_OPICOLLB_LOG';
20: execute immediate 'truncate table ' || g_opi_schema || '.OPI_EDW_IDS_NET_CHG';
21: execute immediate 'truncate table ' || g_opi_schema || '.OPI_EDW_IPS_NET_CHG';
22:
23: COMMIT;
24:
25: -- Gather stats on the daily status fact to optimize joins to it.

Line 98: /* Move net change data from IPS and Temp OPI_EDW_IPS_NET_CHG */

94: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
95:
96: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_IDS_NET_CHG');
97:
98: /* Move net change data from IPS and Temp OPI_EDW_IPS_NET_CHG */
99:
100: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Move net change data from IPS and Temp OPI_EDW_IPS_NET_CHG ');
101: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
102:

Line 100: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Move net change data from IPS and Temp OPI_EDW_IPS_NET_CHG ');

96: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_IDS_NET_CHG');
97:
98: /* Move net change data from IPS and Temp OPI_EDW_IPS_NET_CHG */
99:
100: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Move net change data from IPS and Temp OPI_EDW_IPS_NET_CHG ');
101: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
102:
103: INSERT INTO OPI_EDW_IPS_NET_CHG
104: ( ROW_ID

Line 103: INSERT INTO OPI_EDW_IPS_NET_CHG

99:
100: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Move net change data from IPS and Temp OPI_EDW_IPS_NET_CHG ');
101: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
102:
103: INSERT INTO OPI_EDW_IPS_NET_CHG
104: ( ROW_ID
105: ,AVG_INT_QTY
106: ,AVG_INT_VAL_B
107: ,AVG_INT_VAL_G

Line 313: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Moved net change data from IPS and Temp OPI_EDW_IPS_NET_CHG ' ||SQL%ROWCOUNT);

309: IPS.LOT_FK_KEY=WK2.LOT_FK_KEY AND
310: IPS.PRD_DATE_FK_KEY=WK2.PRD_DATE_FK_KEY AND
311: NVL(IPS.COST_GROUP,'0') = NVL(WK2.COST_GROUP,'0');
312:
313: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Moved net change data from IPS and Temp OPI_EDW_IPS_NET_CHG ' ||SQL%ROWCOUNT);
314: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
315:
316: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_IPS_NET_CHG');
317:

Line 316: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_IPS_NET_CHG');

312:
313: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Moved net change data from IPS and Temp OPI_EDW_IPS_NET_CHG ' ||SQL%ROWCOUNT);
314: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
315:
316: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_IPS_NET_CHG');
317:
318: /* Delete IPS table for Changed rows */
319:
320: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Deleting Changed rows from IPS ');

Line 324: WHERE ROWID IN (SELECT ROW_ID FROM OPI_EDW_IPS_NET_CHG);

320: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Deleting Changed rows from IPS ');
321: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
322:
323: DELETE OPI_EDW_INV_PERD_STAT_F
324: WHERE ROWID IN (SELECT ROW_ID FROM OPI_EDW_IPS_NET_CHG);
325:
326: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Deleted Changed rows from IPS ' ||SQL%ROWCOUNT);
327: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
328:

Line 532: FROM OPI_EDW_IPS_NET_CHG;

528: ,WIP_COMP_VAL_G
529: ,WIP_ISSUE_QTY
530: ,WIP_ISSUE_VAL_B
531: ,WIP_ISSUE_VAL_G
532: FROM OPI_EDW_IPS_NET_CHG;
533:
534: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Moved Data from Work table to IPS' ||SQL%ROWCOUNT);
535: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
536:

Line 541: execute immediate 'truncate table ' || g_opi_schema || '.OPI_EDW_IPS_NET_CHG';

537: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_INV_PERD_STAT_F');
538:
539: execute immediate 'truncate table ' || g_opi_schema || '.OPI_EDW_IDS_OPICOLLB_LOG';
540: execute immediate 'truncate table ' || g_opi_schema || '.OPI_EDW_IDS_NET_CHG';
541: execute immediate 'truncate table ' || g_opi_schema || '.OPI_EDW_IPS_NET_CHG';
542:
543: COMMIT;
544:
545: END;