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_DBI_WIP_COMP_INCR_PKG dependencies on OPI_DBI_WIP_COMP_STG

Line 296: 'OPI_DBI_WIP_COMP_STG');

292: -- again. So it is imperative the commit on the fact table and
293: -- truncate on staging table happen as one operation.
294: l_stmt_id := 100;
295: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || s_opi_schema || '.' ||
296: 'OPI_DBI_WIP_COMP_STG');
297:
298: l_stmt_id := 110;
299: BIS_COLLECTION_UTILITIES.PUT_LINE
300: ('WIP Completions Incremental load terminated successfully.');

Line 472: INTO opi_dbi_wip_comp_stg (

468: -- Flow Schedules.
469:
470: l_stmt_id := 20;
471: INSERT /*+ append */
472: INTO opi_dbi_wip_comp_stg (
473: organization_id,
474: inventory_item_id,
475: transaction_date,
476: completion_quantity,

Line 689: FROM opi_dbi_wip_comp_stg stg,

685: sysdate update_date,
686: s_user_id creator,
687: s_user_id updator,
688: s_login_id update_login
689: FROM opi_dbi_wip_comp_stg stg,
690: opi_dbi_wip_comp_conv_rates conv
691: WHERE stg.organization_id = conv.organization_id
692: AND stg.transaction_date = conv.transaction_date
693: GROUP BY stg.organization_id,