APPS.OPI_COLLECTION_HOOK_P dependencies on OPI_EDW_IDS_NET_CHG

Line 20: execute immediate 'truncate table ' || g_opi_schema || '.OPI_EDW_IDS_NET_CHG';

16: RAISE_APPLICATION_ERROR (-20000, 'Unable to get session information.');
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:

Line 51: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Populate Non key attributes into OPI_EDW_IDS_NET_CHG Table');

47: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_IDS_OPICOLLB_LOG');
48:
49: /* Move Non Attribute Columns into Tep Table 1 */
50:
51: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Populate Non key attributes into OPI_EDW_IDS_NET_CHG Table');
52: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
53:
54:
55: INSERT INTO OPI_EDW_IDS_NET_CHG(

Line 55: INSERT INTO OPI_EDW_IDS_NET_CHG(

51: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Populate Non key attributes into OPI_EDW_IDS_NET_CHG Table');
52: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
53:
54:
55: INSERT INTO OPI_EDW_IDS_NET_CHG(
56: BASE_UOM_FK_KEY,
57: BASE_CURRENCY_FK_KEY,
58: INSTANCE_FK_KEY,
59: INV_ORG_FK_KEY,

Line 93: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Populated Non key attributes into OPI_EDW_IDS_NET_CHG Table'||SQL%ROWCOUNT);

89: LOT_FK_KEY,
90: PRD_DATE_FK_KEY,
91: COST_GROUP;
92:
93: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Populated Non key attributes into OPI_EDW_IDS_NET_CHG Table'||SQL%ROWCOUNT);
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:

Line 96: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_IDS_NET_CHG');

92:
93: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Populated Non key attributes into OPI_EDW_IDS_NET_CHG Table'||SQL%ROWCOUNT);
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 ');

Line 301: FROM OPI_EDW_INV_PERD_STAT_F IPS, OPI_EDW_IDS_NET_CHG WK2

297: , IPS.WIP_COMP_VAL_G
298: , IPS.WIP_ISSUE_QTY
299: , IPS.WIP_ISSUE_VAL_B
300: , IPS.WIP_ISSUE_VAL_G
301: FROM OPI_EDW_INV_PERD_STAT_F IPS, OPI_EDW_IDS_NET_CHG WK2
302: WHERE
303: IPS.BASE_UOM_FK_KEY = WK2.BASE_UOM_FK_KEY AND
304: IPS.BASE_CURRENCY_FK_KEY=WK2.BASE_CURRENCY_FK_KEY AND
305: IPS.INSTANCE_FK_KEY=WK2.INSTANCE_FK_KEY AND

Line 540: execute immediate 'truncate table ' || g_opi_schema || '.OPI_EDW_IDS_NET_CHG';

536:
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: