APPS.OPI_DBI_WMS_WAA_PKG dependencies on OPI_DBI_WMS_EX_F

Line 376: ||'.opi_dbi_wms_ex_f PURGE MATERIALIZED VIEW LOG';

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: --
378: bis_collection_utilities.put_line('Truncated the Fact Tables');
379: l_stmt_num := 90;
380: END IF;

Line 1125: INTO opi_dbi_wms_ex_f exf

1121: --
1122: --Load all Exceptions collected in Staging Table into Exceptions Fact
1123: --
1124: INSERT /*+ append (exf) */
1125: INTO opi_dbi_wms_ex_f exf
1126: (exf.organization_id
1127: ,exf.subinventory_code
1128: ,exf.inventory_item_id
1129: ,exf.operation_plan_id

Line 1700: MERGE INTO opi_dbi_wms_ex_f exf

1696: l_stmt_num := 10;
1697: --
1698: --Load all Exceptions collected in Staging Table into Exceptions Fact
1699: --
1700: MERGE INTO opi_dbi_wms_ex_f exf
1701: USING (
1702: SELECT exs.organization_id organization_id
1703: ,exs.subinventory_code subinventory_code
1704: ,exs.inventory_item_id inventory_item_id