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_INV_CCA_PKG dependencies on OPI_DBI_INV_CCA_CONV

Line 686: 'opi_dbi_inv_cca_conv');

682:
683: l_stmt_id := 140;
684: -- Conversion rates table
685: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || s_opi_schema || '.' ||
686: 'opi_dbi_inv_cca_conv');
687:
688:
689: l_stmt_id := 150;
690: -- MV Log on the fact table, because the purge directive on the

Line 1765: FROM opi_dbi_inv_cca_conv

1761:
1762: -- Cursor to see if any rates are missing. See below for details
1763: CURSOR invalid_rates_exist_csr IS
1764: SELECT 1
1765: FROM opi_dbi_inv_cca_conv
1766: WHERE ( nvl (conversion_rate, -999) < 0
1767: OR nvl (sec_conversion_rate, 999) < 0)
1768: AND rownum < 2;
1769:

Line 1807: FROM opi_dbi_inv_cca_conv conv,

1803: decode (conv.conversion_rate,
1804: C_EURO_MISSING_AT_START, C_EURO_START_DATE,
1805: conv.approval_date) approval_date,
1806: conv.func_currency_code
1807: FROM opi_dbi_inv_cca_conv conv,
1808: mtl_parameters mp,
1809: (SELECT /*+ parallel (opi_dbi_inv_cca_stg) */
1810: DISTINCT organization_id, approval_date
1811: FROM opi_dbi_inv_cca_stg) to_conv

Line 1829: FROM opi_dbi_inv_cca_conv conv,

1825: decode (conv.sec_conversion_rate,
1826: C_EURO_MISSING_AT_START, C_EURO_START_DATE,
1827: conv.approval_date) approval_date,
1828: conv.func_currency_code
1829: FROM opi_dbi_inv_cca_conv conv,
1830: mtl_parameters mp,
1831: (SELECT /*+ parallel (opi_dbi_inv_cca_stg) */
1832: DISTINCT organization_id, approval_date
1833: FROM opi_dbi_inv_cca_stg) to_conv

Line 1892: INSERT /+ append parallel (opi_dbi_inv_cca_conv) /

1888:
1889: -- By selecting distinct org and currency code from the gl_set_of_books
1890: -- and hr_organization_information, take care of duplicate codes.
1891:
1892: INSERT /*+ append parallel (opi_dbi_inv_cca_conv) */
1893: INTO opi_dbi_inv_cca_conv (
1894: organization_id,
1895: func_currency_code,
1896: approval_date,

Line 1893: INTO opi_dbi_inv_cca_conv (

1889: -- By selecting distinct org and currency code from the gl_set_of_books
1890: -- and hr_organization_information, take care of duplicate codes.
1891:
1892: INSERT /*+ append parallel (opi_dbi_inv_cca_conv) */
1893: INTO opi_dbi_inv_cca_conv (
1894: organization_id,
1895: func_currency_code,
1896: approval_date,
1897: conversion_rate,

Line 1939: UPDATE /+ parallel (opi_dbi_inv_cca_conv) / opi_dbi_inv_cca_conv

1935: -- update the secondary with the primary
1936: IF (l_pri_sec_curr_same = 1) THEN
1937:
1938: l_stmt_id := 30;
1939: UPDATE /*+ parallel (opi_dbi_inv_cca_conv) */ opi_dbi_inv_cca_conv
1940: SET sec_conversion_rate = conversion_rate;
1941:
1942: -- safe to commit, as before
1943: l_stmt_id := 40;

Line 2193: opi_dbi_inv_cca_conv conv

2189: s_program_application_id,
2190: s_program_id,
2191: sysdate
2192: FROM opi_dbi_inv_cca_stg stg,
2193: opi_dbi_inv_cca_conv conv
2194: WHERE stg.organization_id = conv.organization_id
2195: AND stg.approval_date = conv.approval_date;
2196:
2197: -- Do not commit here. Let the wrapper handle that.

Line 2598: 'opi_dbi_inv_cca_conv');

2594:
2595: l_stmt_id := 120;
2596: -- Conversion rates table
2597: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || s_opi_schema || '.' ||
2598: 'opi_dbi_inv_cca_conv');
2599:
2600: -- Not using
2601: l_stmt_id := 130;
2602: -- Temp table for bounds computation

Line 3519: FROM opi_dbi_inv_cca_conv

3515:
3516: -- Cursor to see if any rates are missing. See below for details
3517: CURSOR invalid_rates_exist_csr IS
3518: SELECT 1
3519: FROM opi_dbi_inv_cca_conv
3520: WHERE ( nvl (conversion_rate, -999) < 0
3521: OR nvl (sec_conversion_rate, 999) < 0)
3522: AND rownum < 2;
3523:

Line 3559: FROM opi_dbi_inv_cca_conv conv,

3555: decode (conv.conversion_rate,
3556: C_EURO_MISSING_AT_START, C_EURO_START_DATE,
3557: conv.approval_date) approval_date,
3558: conv.func_currency_code
3559: FROM opi_dbi_inv_cca_conv conv,
3560: mtl_parameters mp,
3561: (SELECT
3562: DISTINCT organization_id, approval_date
3563: FROM opi_dbi_inv_cca_stg) to_conv

Line 3580: FROM opi_dbi_inv_cca_conv conv,

3576: decode (conv.sec_conversion_rate,
3577: C_EURO_MISSING_AT_START, C_EURO_START_DATE,
3578: conv.approval_date) approval_date,
3579: conv.func_currency_code
3580: FROM opi_dbi_inv_cca_conv conv,
3581: mtl_parameters mp,
3582: (SELECT
3583: DISTINCT organization_id, approval_date
3584: FROM opi_dbi_inv_cca_stg) to_conv

Line 3643: INTO opi_dbi_inv_cca_conv (

3639: -- By selecting distinct org and currency code from the gl_set_of_books
3640: -- and hr_organization_information, take care of duplicate codes.
3641:
3642: INSERT /*+ append */
3643: INTO opi_dbi_inv_cca_conv (
3644: organization_id,
3645: func_currency_code,
3646: approval_date,
3647: conversion_rate,

Line 3688: UPDATE /+ parallel (opi_dbi_inv_cca_conv) / opi_dbi_inv_cca_conv

3684: -- update the secondary with the primary
3685: IF (l_pri_sec_curr_same = 1) THEN
3686:
3687: l_stmt_id := 30;
3688: UPDATE /*+ parallel (opi_dbi_inv_cca_conv) */ opi_dbi_inv_cca_conv
3689: SET sec_conversion_rate = conversion_rate;
3690:
3691: -- safe to commit, as before
3692: l_stmt_id := 40;

Line 3924: opi_dbi_inv_cca_conv conv

3920: s_program_application_id program_application_id,
3921: s_program_id program_id,
3922: sysdate program_update_date
3923: FROM opi_dbi_inv_cca_stg stg,
3924: opi_dbi_inv_cca_conv conv
3925: WHERE stg.organization_id = conv.organization_id
3926: AND stg.approval_date = conv.approval_date) new
3927: ON (
3928: base.cycle_count_entry_id = new.cycle_count_entry_id