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

Line 140: OPI_DBI_WIP_COMP_STG and the fact table OPI_DBI_WIP_COMP_F.

136: Wrapper routine for OPI + OPM wip completion data extraction for
137: initial load.
138:
139: To begin with, this routine truncates the staging table,
140: OPI_DBI_WIP_COMP_STG and the fact table OPI_DBI_WIP_COMP_F.
141:
142: Both OPI and OPM ETLs can run independently upto the staging table level,
143: even if the other fails. That way, errors found in extracting OPI and OPM
144: data in the initial run can be reported simultaneously.

Line 230: 'OPI_DBI_WIP_COMP_STG');

226: 'OPI_DBI_WIP_COMP_F PURGE MATERIALIZED VIEW LOG');
227:
228: l_stmt_id := 30;
229: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || s_opi_schema || '.' ||
230: 'OPI_DBI_WIP_COMP_STG');
231:
232: -- get the DBI global start date
233: l_stmt_id := 40;
234: l_global_start_date := trunc (bis_common_parameters.get_global_start_date);

Line 331: 'OPI_DBI_WIP_COMP_STG');

327: -- imperative the commit on the fact table and truncate on staging table
328: -- happen as one operation.
329: l_stmt_id := 120;
330: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || s_opi_schema || '.' ||
331: 'OPI_DBI_WIP_COMP_STG');
332:
333: l_stmt_id := 130;
334: BIS_COLLECTION_UTILITIES.PUT_LINE
335: ('WIP Completions Initial load terminated successfully.');

Line 504: INSERT /+ append parallel(opi_dbi_wip_comp_stg) /

500: -- Closed discrete Jobs
501: -- Flow Schedules.
502:
503: l_stmt_id := 20;
504: INSERT /*+ append parallel(opi_dbi_wip_comp_stg) */
505: INTO opi_dbi_wip_comp_stg (
506: organization_id,
507: inventory_item_id,
508: transaction_date,

Line 505: INTO opi_dbi_wip_comp_stg (

501: -- Flow Schedules.
502:
503: l_stmt_id := 20;
504: INSERT /*+ append parallel(opi_dbi_wip_comp_stg) */
505: INTO opi_dbi_wip_comp_stg (
506: organization_id,
507: inventory_item_id,
508: transaction_date,
509: completion_quantity,

Line 739: FROM opi_dbi_wip_comp_stg stg,

735: sysdate,
736: s_user_id,
737: s_user_id,
738: s_login_id
739: FROM opi_dbi_wip_comp_stg stg,
740: opi_dbi_wip_comp_conv_rates conv
741: WHERE stg.organization_id = conv.organization_id
742: AND stg.transaction_date = conv.transaction_date
743: GROUP BY stg.organization_id,

Line 794: OPI_DBI_WIP_COMP_STG using the fii_currency.get_global_rate_primary

790: The conversion rate work table was truncated during
791: the initialization phase.
792:
793: Get the currency conversion rates based on the data in
794: OPI_DBI_WIP_COMP_STG using the fii_currency.get_global_rate_primary
795: API for the primary global currency and
796: fii_currency.get_global_rate_secondary for the secondary global currency.
797: The primary currency API:
798: 1. finds the conversion rate if one exists.

Line 905: (SELECT /+ index_ffs(opi_dbi_wip_comp_stg) /

901: conv.transaction_date) transaction_date,
902: conv.base_currency_code func_currency_code
903: FROM opi_dbi_wip_comp_conv_rates conv,
904: mtl_parameters mp,
905: (SELECT /*+ index_ffs(opi_dbi_wip_comp_stg) */
906: DISTINCT organization_id, transaction_date
907: FROM opi_dbi_wip_comp_stg) to_conv
908: WHERE nvl (conv.conversion_rate, -999) < 0 -- null is not fine
909: AND mp.organization_id = to_conv.organization_id

Line 907: FROM opi_dbi_wip_comp_stg) to_conv

903: FROM opi_dbi_wip_comp_conv_rates conv,
904: mtl_parameters mp,
905: (SELECT /*+ index_ffs(opi_dbi_wip_comp_stg) */
906: DISTINCT organization_id, transaction_date
907: FROM opi_dbi_wip_comp_stg) to_conv
908: WHERE nvl (conv.conversion_rate, -999) < 0 -- null is not fine
909: AND mp.organization_id = to_conv.organization_id
910: AND conv.transaction_date (+) = to_conv.transaction_date
911: AND conv.organization_id (+) = to_conv.organization_id

Line 926: (SELECT /+ index_ffs(opi_dbi_wip_comp_stg) /

922: conv.transaction_date) transaction_date_date,
923: conv.base_currency_code func_currency_code
924: FROM opi_dbi_wip_comp_conv_rates conv,
925: mtl_parameters mp,
926: (SELECT /*+ index_ffs(opi_dbi_wip_comp_stg) */
927: DISTINCT organization_id, transaction_date
928: FROM opi_dbi_wip_comp_stg) to_conv
929: WHERE nvl (conv.sec_conversion_rate, 999) < 0 -- null is fine
930: AND mp.organization_id = to_conv.organization_id

Line 928: FROM opi_dbi_wip_comp_stg) to_conv

924: FROM opi_dbi_wip_comp_conv_rates conv,
925: mtl_parameters mp,
926: (SELECT /*+ index_ffs(opi_dbi_wip_comp_stg) */
927: DISTINCT organization_id, transaction_date
928: FROM opi_dbi_wip_comp_stg) to_conv
929: WHERE nvl (conv.sec_conversion_rate, 999) < 0 -- null is fine
930: AND mp.organization_id = to_conv.organization_id
931: AND conv.transaction_date (+) = to_conv.transaction_date
932: AND conv.organization_id (+) = to_conv.organization_id)

Line 1033: (SELECT /+ index_ffs(opi_dbi_wip_comp_stg) /

1029: s_user_id,
1030: s_user_id,
1031: s_login_id
1032: FROM
1033: (SELECT /*+ index_ffs(opi_dbi_wip_comp_stg) */
1034: DISTINCT organization_id, transaction_date
1035: FROM opi_dbi_wip_comp_stg) to_conv,
1036: (SELECT
1037: DISTINCT hoi.organization_id, gsob.currency_code

Line 1035: FROM opi_dbi_wip_comp_stg) to_conv,

1031: s_login_id
1032: FROM
1033: (SELECT /*+ index_ffs(opi_dbi_wip_comp_stg) */
1034: DISTINCT organization_id, transaction_date
1035: FROM opi_dbi_wip_comp_stg) to_conv,
1036: (SELECT
1037: DISTINCT hoi.organization_id, gsob.currency_code
1038: FROM hr_organization_information hoi,
1039: gl_sets_of_books gsob