APPS.OPI_DBI_MTL_VARIANCE_PKG dependencies on OPI_DBI_CUV_CONV_RATES

Line 112: FROM opi_dbi_cuv_conv_rates

108:
109: -- Cursor to see if any rates are missing. See below for details
110: CURSOR invalid_rates_exist_csr IS
111: SELECT 1
112: FROM opi_dbi_cuv_conv_rates
113: WHERE ( nvl (conversion_rate, -999) < 0
114: OR nvl (sec_conversion_rate, 999) < 0)
115: AND rownum < 2;
116:

Line 158: FROM opi_dbi_cuv_conv_rates conv,

154: decode (conv.conversion_rate,
155: C_EURO_MISSING_AT_START, g_euro_start_date,
156: conv.transaction_date) transaction_date,
157: conv.f_currency_code func_currency_code
158: FROM opi_dbi_cuv_conv_rates conv,
159: mtl_parameters mp,
160: (SELECT /*+ parallel_index(we) index_ffs(we) */
161: DISTINCT
162: organization_id,

Line 182: FROM opi_dbi_cuv_conv_rates conv,

178: decode (conv.sec_conversion_rate,
179: C_EURO_MISSING_AT_START, g_euro_start_date,
180: conv.transaction_date) transaction_date,
181: conv.f_currency_code func_currency_code
182: FROM opi_dbi_cuv_conv_rates conv,
183: mtl_parameters mp,
184: (SELECT /*+ parallel_index(we) index_ffs(we) */
185: DISTINCT
186: organization_id,

Line 284: INTO opi_dbi_cuv_conv_rates rates (

280:
281: -- By selecting distinct org and currency code from the gl_set_of_books
282: -- and hr_organization_information, take care of duplicate codes.
283: INSERT /*+ append parallel(rates) */
284: INTO opi_dbi_cuv_conv_rates rates (
285: organization_id,
286: f_currency_code,
287: transaction_date,
288: conversion_rate,

Line 351: UPDATE /*+ parallel (opi_dbi_cuv_conv_rates) */

347: -- if the primary and secondary currency codes are the same, then
348: -- update the secondary with the primary
349: IF (l_pri_sec_curr_same = 1) THEN
350:
351: UPDATE /*+ parallel (opi_dbi_cuv_conv_rates) */
352: opi_dbi_cuv_conv_rates
353: SET sec_conversion_rate = conversion_rate;
354:
355: -- safe to commit, as before

Line 352: opi_dbi_cuv_conv_rates

348: -- update the secondary with the primary
349: IF (l_pri_sec_curr_same = 1) THEN
350:
351: UPDATE /*+ parallel (opi_dbi_cuv_conv_rates) */
352: opi_dbi_cuv_conv_rates
353: SET sec_conversion_rate = conversion_rate;
354:
355: -- safe to commit, as before
356: commit;

Line 1543: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_CUV_CONV_RATES';

1539: /* Truncate Current Unrecognized Variances Fact Table */
1540: l_stmt_num := 10;
1541: IF fnd_installation.get_app_info( 'OPI', l_status, l_industry, l_opi_schema) THEN
1542: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_CURR_UNREC_VAR_F';
1543: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_CUV_CONV_RATES';
1544: END IF;
1545:
1546: l_stmt_num := 20;
1547: IF (Get_Conversion_Rate (errbuf, retcode) = -1) THEN

Line 1732: opi_dbi_cuv_conv_rates conv

1728: to_number(job_type)
1729: ) act_std,
1730: mtl_system_items_b msi,
1731: eni_oltp_item_star cat,
1732: opi_dbi_cuv_conv_rates conv
1733: WHERE
1734: act_std.organization_id = msi.organization_id
1735: AND act_std.inventory_item_id = msi.inventory_item_id
1736: AND act_std.organization_id = cat.organization_id

Line 1767: OPI_DBI_CUV_CONV_RATES rates,

1763: g_program_login_id PROGRAM_LOGIN_ID,
1764: g_program_application_id PROGRAM_APPLICATION_ID,
1765: g_request_id REQUEST_ID
1766: from
1767: OPI_DBI_CUV_CONV_RATES rates,
1768: (select /*+ full(gtv) use_hash(mtl_dtl) full(mtl_dtl) parallel(mtl_dtl) parallel(gtv) use_hash(jobs)*/
1769: jobs.organization_id,
1770: Jobs.assembly_item_id,
1771: jobs.job_id,