APPS.OPI_DBI_WIP_SCRAP_INIT_PKG dependencies on OPI_DBI_WIP_SCRAP_CONV_RATES

Line 708: opi_dbi_wip_scrap_conv_rates conv

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,
712: stg.inventory_item_id,

Line 820: FROM opi_dbi_wip_scrap_conv_rates

816:
817: -- Cursor to see if any rates are missing. See below for details
818: CURSOR invalid_rates_exist_csr IS
819: SELECT 1
820: FROM opi_dbi_wip_scrap_conv_rates
821: WHERE ( nvl (conversion_rate, -999) < 0
822: OR nvl (sec_conversion_rate, 999) < 0)
823: AND rownum < 2;
824:

Line 864: FROM opi_dbi_wip_scrap_conv_rates conv,

860: decode (conv.conversion_rate,
861: EURO_MISSING_AT_START, EURO_START_DATE,
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

Line 885: FROM opi_dbi_wip_scrap_conv_rates conv,

881: decode (conv.sec_conversion_rate,
882: EURO_MISSING_AT_START, EURO_START_DATE,
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

Line 914: 'OPI_DBI_WIP_SCRAP_CONV_RATES');

910:
911: -- Truncate the conversion rates work table
912: l_stmt_id := 10;
913: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || p_opi_schema || '.' ||
914: 'OPI_DBI_WIP_SCRAP_CONV_RATES');
915:
916:
917: -- It is assumed that the setup of the global currency data has been
918: -- validated at the start of the program by a call to the

Line 961: INTO opi_dbi_wip_scrap_conv_rates rates (

957: -- By selecting distinct org and currency code from the gl_set_of_books
958: -- and hr_organization_information, take care of duplicate codes.
959:
960: INSERT /*+ append */
961: INTO opi_dbi_wip_scrap_conv_rates rates (
962: organization_id,
963: base_currency_code,
964: transaction_date,
965: conversion_rate,

Line 1016: UPDATE /*+ parallel (opi_dbi_wip_scrap_conv_rates) */

1012: -- if the primary and secondary currency codes are the same, then
1013: -- update the secondary with the primary
1014: IF (l_pri_sec_curr_same = 1) THEN
1015:
1016: UPDATE /*+ parallel (opi_dbi_wip_scrap_conv_rates) */
1017: opi_dbi_wip_scrap_conv_rates
1018: SET sec_conversion_rate = conversion_rate;
1019:
1020: -- safe to commit, as before

Line 1017: opi_dbi_wip_scrap_conv_rates

1013: -- update the secondary with the primary
1014: IF (l_pri_sec_curr_same = 1) THEN
1015:
1016: UPDATE /*+ parallel (opi_dbi_wip_scrap_conv_rates) */
1017: opi_dbi_wip_scrap_conv_rates
1018: SET sec_conversion_rate = conversion_rate;
1019:
1020: -- safe to commit, as before
1021: commit;