APPS.OPI_DBI_WIP_SCRAP_INCR_PKG dependencies on OPI_DBI_WIP_SCRAP_STG

Line 260: 'OPI_DBI_WIP_SCRAP_STG');

256: -- again. So it is imperative the commit on the fact table and
257: -- truncate on staging table happen as one operation.
258: l_stmt_id := 80;
259: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || s_opi_schema || '.' ||
260: 'OPI_DBI_WIP_SCRAP_STG');
261:
262: l_stmt_id := 90;
263: BIS_COLLECTION_UTILITIES.PUT_LINE
264: ('Scrap Incremental load terminated successfully.');

Line 439: INTO opi_dbi_wip_scrap_stg (

435: -- Flow Schedules.
436:
437: l_stmt_id := 20;
438: INSERT /*+ append */
439: INTO opi_dbi_wip_scrap_stg (
440: organization_id,
441: inventory_item_id,
442: transaction_date,
443: scrap_quantity,

Line 656: FROM opi_dbi_wip_scrap_stg stg,

652: sysdate update_date,
653: s_user_id creator,
654: s_user_id updator,
655: s_login_id update_login
656: FROM opi_dbi_wip_scrap_stg stg,
657: opi_dbi_wip_scrap_conv_rates conv
658: WHERE stg.organization_id = conv.organization_id
659: AND stg.transaction_date = conv.transaction_date
660: GROUP BY stg.organization_id,