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_SCRAP_INIT_PKG dependencies on OPI_DBI_WIP_SCRAP_STG

Line 145: OPI_DBI_WIP_SCRAP_STG and the fact table OPI_DBI_WIP_SCRAP_F.

141: we do not have any OPM data, but the availability of the wrapper
142: makes that extension easier, if needed.
143:
144: To begin with, this routine truncates the staging table,
145: OPI_DBI_WIP_SCRAP_STG and the fact table OPI_DBI_WIP_SCRAP_F.
146:
147: Both OPI collection first runs to the staging table level. If an error
148: occurs, routine ends with error.
149:

Line 229: 'OPI_DBI_WIP_SCRAP_STG');

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

Line 296: 'OPI_DBI_WIP_SCRAP_STG');

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

Line 471: INSERT /+ append parallel(opi_dbi_wip_scrap_stg) /

467: -- Closed discrete Jobs
468: -- Flow Schedules.
469:
470: l_stmt_id := 20;
471: INSERT /*+ append parallel(opi_dbi_wip_scrap_stg) */
472: INTO opi_dbi_wip_scrap_stg (
473: organization_id,
474: inventory_item_id,
475: transaction_date,

Line 472: INTO opi_dbi_wip_scrap_stg (

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

Line 707: FROM opi_dbi_wip_scrap_stg stg,

703: sysdate,
704: s_user_id,
705: s_user_id,
706: s_login_id
707: FROM opi_dbi_wip_scrap_stg stg,
708: opi_dbi_wip_scrap_conv_rates conv
709: WHERE stg.organization_id = conv.organization_id
710: AND stg.transaction_date = conv.transaction_date
711: GROUP BY stg.organization_id,

Line 763: OPI_DBI_WIP_SCRAP_STG using the fii_currency.get_global_rate_primary

759: The conversion rate work table was truncated during
760: the initialization phase.
761:
762: Get the currency conversion rates based on the data in
763: OPI_DBI_WIP_SCRAP_STG using the fii_currency.get_global_rate_primary
764: API for the primary global currency and
765: fii_currency.get_global_rate_secondary for the secondary global currency.
766: The primary currency API:
767: 1. finds the conversion rate if one exists.

Line 866: (SELECT /+ index_ffs(opi_dbi_wip_scrap_stg) /

862: conv.transaction_date) transaction_date,
863: conv.base_currency_code func_currency_code
864: FROM opi_dbi_wip_scrap_conv_rates conv,
865: mtl_parameters mp,
866: (SELECT /*+ index_ffs(opi_dbi_wip_scrap_stg) */
867: DISTINCT organization_id, transaction_date
868: FROM opi_dbi_wip_scrap_stg) to_conv
869: WHERE nvl (conv.conversion_rate, -999) < 0 -- null is not fine
870: AND mp.organization_id = to_conv.organization_id

Line 868: FROM opi_dbi_wip_scrap_stg) to_conv

864: FROM opi_dbi_wip_scrap_conv_rates conv,
865: mtl_parameters mp,
866: (SELECT /*+ index_ffs(opi_dbi_wip_scrap_stg) */
867: DISTINCT organization_id, transaction_date
868: FROM opi_dbi_wip_scrap_stg) to_conv
869: WHERE nvl (conv.conversion_rate, -999) < 0 -- null is not fine
870: AND mp.organization_id = to_conv.organization_id
871: AND conv.transaction_date (+) = to_conv.transaction_date
872: AND conv.organization_id (+) = to_conv.organization_id

Line 887: (SELECT /+ index_ffs(opi_dbi_wip_scrap_stg) /

883: conv.transaction_date) transaction_date_date,
884: conv.base_currency_code func_currency_code
885: FROM opi_dbi_wip_scrap_conv_rates conv,
886: mtl_parameters mp,
887: (SELECT /*+ index_ffs(opi_dbi_wip_scrap_stg) */
888: DISTINCT organization_id, transaction_date
889: FROM opi_dbi_wip_scrap_stg) to_conv
890: WHERE nvl (conv.sec_conversion_rate, 999) < 0 -- null is fine
891: AND mp.organization_id = to_conv.organization_id

Line 889: FROM opi_dbi_wip_scrap_stg) to_conv

885: FROM opi_dbi_wip_scrap_conv_rates conv,
886: mtl_parameters mp,
887: (SELECT /*+ index_ffs(opi_dbi_wip_scrap_stg) */
888: DISTINCT organization_id, transaction_date
889: FROM opi_dbi_wip_scrap_stg) to_conv
890: WHERE nvl (conv.sec_conversion_rate, 999) < 0 -- null is fine
891: AND mp.organization_id = to_conv.organization_id
892: AND conv.transaction_date (+) = to_conv.transaction_date
893: AND conv.organization_id (+) = to_conv.organization_id)

Line 995: (SELECT /+ index_ffs(opi_dbi_wip_scrap_stg) /

991: s_user_id,
992: s_user_id,
993: s_login_id
994: FROM
995: (SELECT /*+ index_ffs(opi_dbi_wip_scrap_stg) */
996: DISTINCT organization_id, transaction_date
997: FROM opi_dbi_wip_scrap_stg) to_conv,
998: (SELECT
999: DISTINCT hoi.organization_id, gsob.currency_code

Line 997: FROM opi_dbi_wip_scrap_stg) to_conv,

993: s_login_id
994: FROM
995: (SELECT /*+ index_ffs(opi_dbi_wip_scrap_stg) */
996: DISTINCT organization_id, transaction_date
997: FROM opi_dbi_wip_scrap_stg) to_conv,
998: (SELECT
999: DISTINCT hoi.organization_id, gsob.currency_code
1000: FROM hr_organization_information hoi,
1001: gl_sets_of_books gsob