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_RES_PKG dependencies on OPI_DBI_RES_CONV_RATES

Line 280: FROM opi_dbi_res_conv_rates

276:
277: -- Cursor to see if any rates are missing. See below for details
278: CURSOR invalid_rates_exist_csr IS
279: SELECT 1
280: FROM opi_dbi_res_conv_rates
281: WHERE (nvl (conversion_rate, -999) < 0
282: OR nvl (sec_conversion_rate, 999) < 0)
283: AND rownum < 2;
284:

Line 326: FROM opi_dbi_res_conv_rates conv,

322: decode (conv.conversion_rate,
323: C_EURO_MISSING_AT_START, G_EURO_START_DATE,
324: conv.transaction_date) transaction_date,
325: conv.f_currency_code func_currency_code
326: FROM opi_dbi_res_conv_rates conv,
327: mtl_parameters mp,
328: (
329: SELECT /*+ parallel (opi_dbi_res_actual_stg) */
330: DISTINCT

Line 357: FROM opi_dbi_res_conv_rates conv,

353: decode (conv.sec_conversion_rate,
354: C_EURO_MISSING_AT_START, G_EURO_START_DATE,
355: conv.transaction_date) transaction_date_date,
356: conv.f_currency_code func_currency_code
357: FROM opi_dbi_res_conv_rates conv,
358: mtl_parameters mp,
359: (
360: SELECT /*+ parallel (opi_dbi_res_actual_stg) */
361: DISTINCT

Line 430: INTO opi_dbi_res_conv_rates rates (

426:
427: -- By selecting distinct org and currency code from the gl_set_of_books
428: -- and hr_organization_information, take care of duplicate codes.
429: INSERT /*+ append parallel(rates) */
430: INTO opi_dbi_res_conv_rates rates (
431: organization_id,
432: f_currency_code,
433: transaction_date,
434: conversion_rate,

Line 486: UPDATE /+ parallel (opi_dbi_res_conv_rates) /

482: -- if the primary and secondary currency codes are the same, then
483: -- update the secondary with the primary
484: IF (l_pri_sec_curr_same = 1) THEN
485: --{
486: UPDATE /*+ parallel (opi_dbi_res_conv_rates) */
487: opi_dbi_res_conv_rates
488: SET sec_conversion_rate = conversion_rate;
489:
490: -- safe to commit, as before

Line 487: opi_dbi_res_conv_rates

483: -- update the secondary with the primary
484: IF (l_pri_sec_curr_same = 1) THEN
485: --{
486: UPDATE /*+ parallel (opi_dbi_res_conv_rates) */
487: opi_dbi_res_conv_rates
488: SET sec_conversion_rate = conversion_rate;
489:
490: -- safe to commit, as before
491: commit;

Line 2243: || '.opi_dbi_res_conv_rates ';

2239:
2240: IF fnd_installation.get_app_info( 'OPI', l_status, l_industry, l_opi_schema) THEN
2241: --{
2242: execute immediate 'truncate table ' || l_opi_schema
2243: || '.opi_dbi_res_conv_rates ';
2244:
2245: execute immediate 'truncate table ' || l_opi_schema
2246: || '.opi_dbi_res_avail_stg ';
2247:

Line 2402: --gather_stats(p_table_name => 'OPI_DBI_RES_CONV_RATES');

2398: get_res_conversion_rate(errbuf => errbuf, retcode => retcode );
2399:
2400: commit;
2401:
2402: --gather_stats(p_table_name => 'OPI_DBI_RES_CONV_RATES');
2403:
2404:
2405: IF l_error_flag <> TRUE THEN
2406: --{

Line 2470: opi_dbi_res_conv_rates rate

2466: g_program_application_id,
2467: g_request_id
2468: FROM
2469: opi_dbi_res_actual_stg stg,
2470: opi_dbi_res_conv_rates rate
2471: WHERE
2472: stg.organization_id = rate.organization_id
2473: AND stg.transaction_date = rate.transaction_date
2474: GROUP BY

Line 2588: opi_dbi_res_conv_rates rate

2584: sum ((stg.actual_val_b_draft + stg.actual_val_b)
2585: * rate.sec_conversion_rate) actual_val_sg,
2586: MAX (stg.source) source
2587: FROM opi_dbi_res_actual_stg stg,
2588: opi_dbi_res_conv_rates rate
2589: WHERE stg.organization_id = rate.organization_id
2590: AND stg.transaction_date = rate.transaction_date
2591: GROUP BY
2592: stg.resource_id,

Line 2619: opi_dbi_res_conv_rates rate

2615: NULL actual_val_g,
2616: NULL actual_val_sg,
2617: stg.source
2618: FROM opi_dbi_res_avail_stg stg,
2619: opi_dbi_res_conv_rates rate
2620: WHERE stg.organization_id = rate.organization_id
2621: AND stg.transaction_date = rate.transaction_date
2622: ) res
2623: GROUP BY

Line 2652: || '.opi_dbi_res_conv_rates ';

2648: --{
2649: COMMIT;
2650:
2651: execute immediate 'truncate table ' || l_opi_schema
2652: || '.opi_dbi_res_conv_rates ';
2653:
2654: execute immediate 'truncate table ' || l_opi_schema
2655: || '.opi_dbi_res_avail_stg ';
2656:

Line 2956: || '.opi_dbi_res_conv_rates ';

2952: IF fnd_installation.get_app_info( 'OPI', l_status, l_industry, l_opi_schema) THEN
2953: --{
2954:
2955: execute immediate 'truncate table ' || l_opi_schema
2956: || '.opi_dbi_res_conv_rates ';
2957: --}
2958: ELSE
2959: --{
2960: retcode := g_error;

Line 3143: --gather_stats(p_table_name => 'OPI_DBI_RES_CONV_RATES');

3139: get_res_conversion_rate(errbuf => errbuf, retcode => retcode );
3140:
3141: commit;
3142:
3143: --gather_stats(p_table_name => 'OPI_DBI_RES_CONV_RATES');
3144:
3145:
3146:
3147: -- Incrementally load data into Actual Fact

Line 3173: opi_dbi_res_conv_rates rate

3169: stg.job_type,
3170: stg.assembly_item_id,
3171: stg.source
3172: FROM opi_dbi_res_actual_stg stg,
3173: opi_dbi_res_conv_rates rate
3174: WHERE stg.organization_id = rate.organization_id
3175: AND stg.transaction_date = rate.transaction_date
3176: GROUP BY
3177: stg.resource_id,

Line 3326: opi_dbi_res_conv_rates rate

3322: min(rate.sec_conversion_rate) sec_conversion_rate,
3323: stg.source source
3324: FROM
3325: opi_dbi_res_actual_stg stg,
3326: opi_dbi_res_conv_rates rate
3327: WHERE
3328: stg.organization_id = rate.organization_id
3329: AND stg.transaction_date = rate.transaction_date
3330: GROUP BY

Line 3360: opi_dbi_res_conv_rates rate

3356: rate.sec_conversion_rate sec_conversion_rate,
3357: stg.source
3358: FROM
3359: opi_dbi_res_avail_stg stg,
3360: opi_dbi_res_conv_rates rate
3361: WHERE
3362: stg.organization_id = rate.organization_id
3363: AND stg.transaction_date = rate.transaction_date
3364: ) res

Line 3483: || '.opi_dbi_res_conv_rates ';

3479:
3480: -- common clean up
3481:
3482: execute immediate 'truncate table ' || l_opi_schema
3483: || '.opi_dbi_res_conv_rates ';
3484:
3485: execute immediate 'truncate table ' || l_opi_schema
3486: || '.opi_dbi_res_avail_stg ';
3487: