APPS.OPI_DBI_WMS_WAA_PKG dependencies on OPI_DBI_WMS_TASKS_F

Line 373: ||'.opi_dbi_wms_tasks_f PURGE MATERIALIZED VIEW LOG';

369: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema
370: ||'.opi_dbi_wms_op_f PURGE MATERIALIZED VIEW LOG';
371: l_stmt_num := 70;
372: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema
373: ||'.opi_dbi_wms_tasks_f PURGE MATERIALIZED VIEW LOG';
374: l_stmt_num := 80;
375: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema
376: ||'.opi_dbi_wms_ex_f PURGE MATERIALIZED VIEW LOG';
377: --

Line 937: INTO opi_dbi_wms_tasks_f taskf

933: --
934: --Load all Pick Tasks collected in Staging Table into Tasks Fact
935: --
936: INSERT /*+ append parallel(taskf) */
937: INTO opi_dbi_wms_tasks_f taskf
938: (taskf.organization_id
939: ,taskf.subinventory_code
940: ,taskf.inventory_item_id
941: ,taskf.completion_date

Line 1461: MERGE INTO opi_dbi_wms_tasks_f taskf

1457: l_stmt_num := 10;
1458: --
1459: --Load all Pick Tasks collected in Staging Table into Tasks Fact
1460: --
1461: MERGE INTO opi_dbi_wms_tasks_f taskf
1462: USING (
1463: SELECT tasks.organization_id organization_id
1464: ,tasks.subinventory_code subinventory_code
1465: ,tasks.inventory_item_id inventory_item_id

Line 1881: IF BIS_COLLECTION_UTILITIES.SETUP('OPI_DBI_WMS_TASKS_F') = FALSE THEN

1877: ('Initial Load starts at '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
1878: --
1879: l_stmt_num := 110;
1880: --
1881: IF BIS_COLLECTION_UTILITIES.SETUP('OPI_DBI_WMS_TASKS_F') = FALSE THEN
1882: --
1883: l_stmt_num := 120;
1884: RAISE_APPLICATION_ERROR(-20000, errbuf);
1885: END IF;

Line 2048: IF BIS_COLLECTION_UTILITIES.SETUP('OPI_DBI_WMS_TASKS_F') = FALSE THEN

2044: ('Incremental Load starts at '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
2045: --
2046: l_stmt_num := 110;
2047: --
2048: IF BIS_COLLECTION_UTILITIES.SETUP('OPI_DBI_WMS_TASKS_F') = FALSE THEN
2049: --
2050: l_stmt_num := 120;
2051: RAISE_APPLICATION_ERROR(-20000, errbuf);
2052: END IF;