APPS.OPI_DBI_WIP_COMP_INIT_PKG dependencies on OPI_DBI_WIP_COMP_CONV_RATES

Line 740: opi_dbi_wip_comp_conv_rates conv

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

Line 858: FROM opi_dbi_wip_comp_conv_rates

854:
855: -- Cursor to see if any rates are missing. See below for details
856: CURSOR invalid_rates_exist_csr IS
857: SELECT 1
858: FROM opi_dbi_wip_comp_conv_rates
859: WHERE ( nvl (conversion_rate, -999) < 0
860: OR nvl (sec_conversion_rate, 999) < 0)
861: AND rownum < 2;
862:

Line 903: FROM opi_dbi_wip_comp_conv_rates conv,

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

Line 924: FROM opi_dbi_wip_comp_conv_rates conv,

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

Line 953: 'OPI_DBI_WIP_COMP_CONV_RATES');

949:
950: -- Truncate the conversion rates work table
951: l_stmt_id := 10;
952: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || p_opi_schema || '.' ||
953: 'OPI_DBI_WIP_COMP_CONV_RATES');
954:
955: -- It is assumed that the setup of the global currency data has been
956: -- validated at the start of the program by a call to the
957: -- check_global_setup procedure.

Line 999: INTO opi_dbi_wip_comp_conv_rates rates (

995: -- By selecting distinct org and currency code from the gl_set_of_books
996: -- and hr_organization_information, take care of duplicate codes.
997:
998: INSERT /*+ append */
999: INTO opi_dbi_wip_comp_conv_rates rates (
1000: organization_id,
1001: base_currency_code,
1002: transaction_date,
1003: conversion_rate,

Line 1054: UPDATE /*+ parallel (opi_dbi_wip_comp_conv_rates) */

1050: -- if the primary and secondary currency codes are the same, then
1051: -- update the secondary with the primary
1052: IF (l_pri_sec_curr_same = 1) THEN
1053:
1054: UPDATE /*+ parallel (opi_dbi_wip_comp_conv_rates) */
1055: opi_dbi_wip_comp_conv_rates
1056: SET sec_conversion_rate = conversion_rate;
1057:
1058: -- safe to commit, as before

Line 1055: opi_dbi_wip_comp_conv_rates

1051: -- update the secondary with the primary
1052: IF (l_pri_sec_curr_same = 1) THEN
1053:
1054: UPDATE /*+ parallel (opi_dbi_wip_comp_conv_rates) */
1055: opi_dbi_wip_comp_conv_rates
1056: SET sec_conversion_rate = conversion_rate;
1057:
1058: -- safe to commit, as before
1059: commit;