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.

[Home] [Help]

APPS.OPI_DBI_COGS_PKG dependencies on OPI_DBI_COGSF_CONV_RATES

Line 1334: FROM opi_dbi_cogsf_conv_rates

1330:
1331: -- Cursor to see if any rates are missing. See below for details
1332: CURSOR invalid_rates_exist_csr IS
1333: SELECT 1
1334: FROM opi_dbi_cogsf_conv_rates
1335: WHERE (nvl (conversion_rate, -999) < 0 OR
1336: nvl (sec_conversion_rate, 999) < 0)
1337: AND rownum < 2;
1338:

Line 1377: FROM opi_dbi_cogsf_conv_rates conv,

1373: decode (conv.conversion_rate,
1374: C_EURO_MISSING_AT_START, g_euro_start_date,
1375: conv.transaction_date) cogs_date,
1376: conv.f_currency_code func_currency_code
1377: FROM opi_dbi_cogsf_conv_rates conv,
1378: mtl_parameters mp,
1379: (SELECT /*+ parallel (opi_dbi_cogs_fstg) */
1380: DISTINCT organization_id, trunc (cogs_date) cogs_date
1381: FROM opi_dbi_cogs_fstg) to_conv

Line 1399: FROM opi_dbi_cogsf_conv_rates conv,

1395: decode (conv.sec_conversion_rate,
1396: C_EURO_MISSING_AT_START, g_euro_start_date,
1397: conv.transaction_date) cogs_date,
1398: conv.f_currency_code func_currency_code
1399: FROM opi_dbi_cogsf_conv_rates conv,
1400: mtl_parameters mp,
1401: (SELECT /*+ parallel (opi_dbi_cogs_fstg) */
1402: DISTINCT organization_id, trunc (cogs_date) cogs_date
1403: FROM opi_dbi_cogs_fstg) to_conv

Line 1464: INTO opi_dbi_cogsf_conv_rates rates (

1460: -- By selecting distinct org and currency code from the gl_set_of_books
1461: -- and hr_organization_information, take care of duplicate codes.
1462:
1463: INSERT /*+ append parallel(rates) */
1464: INTO opi_dbi_cogsf_conv_rates rates (
1465: organization_id,
1466: f_currency_code,
1467: transaction_date,
1468: conversion_rate,

Line 1510: UPDATE /+ parallel (opi_dbi_cogsf_conv_rates) /

1506: -- if the primary and secondary currency codes are the same, then
1507: -- update the secondary with the primary
1508: IF (l_pri_sec_curr_same = 1) THEN
1509: --{
1510: UPDATE /*+ parallel (opi_dbi_cogsf_conv_rates) */
1511: opi_dbi_cogsf_conv_rates
1512: SET sec_conversion_rate = conversion_rate;
1513:
1514: -- safe to commit, as before

Line 1511: opi_dbi_cogsf_conv_rates

1507: -- update the secondary with the primary
1508: IF (l_pri_sec_curr_same = 1) THEN
1509: --{
1510: UPDATE /*+ parallel (opi_dbi_cogsf_conv_rates) */
1511: opi_dbi_cogsf_conv_rates
1512: SET sec_conversion_rate = conversion_rate;
1513:
1514: -- safe to commit, as before
1515: commit;

Line 1593: FROM opi_dbi_cogsf_conv_rates

1589:
1590: -- Cursor to see if any rates are missing. See below for details
1591: CURSOR invalid_rates_exist_csr IS
1592: SELECT 1
1593: FROM opi_dbi_cogsf_conv_rates
1594: WHERE ( nvl (conversion_rate, -999) < 0
1595: OR nvl (sec_conversion_rate, 999) < 0)
1596: AND rownum < 2;
1597:

Line 1634: FROM opi_dbi_cogsf_conv_rates conv,

1630: decode (conv.conversion_rate,
1631: C_EURO_MISSING_AT_START, g_euro_start_date,
1632: conv.transaction_date) cogs_date,
1633: conv.f_currency_code func_currency_code
1634: FROM opi_dbi_cogsf_conv_rates conv,
1635: mtl_parameters mp,
1636: (SELECT /*+ parallel (opi_dbi_cogs_fstg) */
1637: DISTINCT organization_id, trunc (cogs_date) cogs_date
1638: FROM opi_dbi_cogs_fstg) to_conv

Line 1655: FROM opi_dbi_cogsf_conv_rates conv,

1651: decode (conv.sec_conversion_rate,
1652: C_EURO_MISSING_AT_START, g_euro_start_date,
1653: conv.transaction_date) cogs_date,
1654: conv.f_currency_code func_currency_code
1655: FROM opi_dbi_cogsf_conv_rates conv,
1656: mtl_parameters mp,
1657: (SELECT /*+ parallel (opi_dbi_cogs_fstg) */
1658: DISTINCT organization_id, trunc (cogs_date) cogs_date
1659: FROM opi_dbi_cogs_fstg) to_conv

Line 1720: INTO opi_dbi_cogsf_conv_rates rates (

1716: -- By selecting distinct org and currency code from the gl_set_of_books
1717: -- and hr_organization_information, take care of duplicate codes.
1718:
1719: INSERT /*+ append */
1720: INTO opi_dbi_cogsf_conv_rates rates (
1721: organization_id,
1722: f_currency_code,
1723: transaction_date,
1724: conversion_rate,

Line 1765: UPDATE /+ parallel (opi_dbi_cogsf_conv_rates) /

1761: -- if the primary and secondary currency codes are the same, then
1762: -- update the secondary with the primary
1763: IF (l_pri_sec_curr_same = 1) THEN
1764: --{
1765: UPDATE /*+ parallel (opi_dbi_cogsf_conv_rates) */
1766: opi_dbi_cogsf_conv_rates
1767: SET sec_conversion_rate = conversion_rate;
1768:
1769: -- safe to commit, as before

Line 1766: opi_dbi_cogsf_conv_rates

1762: -- update the secondary with the primary
1763: IF (l_pri_sec_curr_same = 1) THEN
1764: --{
1765: UPDATE /*+ parallel (opi_dbi_cogsf_conv_rates) */
1766: opi_dbi_cogsf_conv_rates
1767: SET sec_conversion_rate = conversion_rate;
1768:
1769: -- safe to commit, as before
1770: commit;

Line 1894: || '.opi_dbi_cogsf_conv_rates ';

1890:
1891: IF fnd_installation.get_app_info( 'OPI', l_status, l_industry, l_opi_schema) THEN
1892: --{
1893: execute immediate 'truncate table ' || l_opi_schema
1894: || '.opi_dbi_cogsf_conv_rates ';
1895:
1896: execute immediate 'truncate table ' || l_opi_schema
1897: || '.opi_dbi_cogs_run_log ';
1898:

Line 1985: gather_stats(p_table_name => 'OPI_DBI_COGSF_CONV_RATES');

1981:
1982: get_cogs_conversion_rate( errbuf => errbuf, retcode => retcode );
1983: commit;
1984:
1985: gather_stats(p_table_name => 'OPI_DBI_COGSF_CONV_RATES');
1986:
1987:
1988: IF retcode <> 0 THEN
1989: --{

Line 2053: opi_dbi_cogsf_conv_rates rate

2049: g_program_login_id,
2050: g_program_application_id,
2051: g_request_id
2052: FROM opi_dbi_cogs_fstg stg,
2053: opi_dbi_cogsf_conv_rates rate
2054: WHERE stg.organization_id = rate.organization_id
2055: AND trunc (stg.cogs_date) = rate.transaction_date
2056: GROUP BY
2057: stg.inventory_item_id,

Line 2095: || '.opi_dbi_cogsf_conv_rates ';

2091: -- Common clean up
2092: l_stmt_num := 120;
2093:
2094: execute immediate 'truncate table ' || l_opi_schema
2095: || '.opi_dbi_cogsf_conv_rates ';
2096:
2097: execute immediate 'truncate table ' || l_opi_schema
2098: || '.opi_dbi_cogs_fstg ';
2099:

Line 2196: || '.opi_dbi_cogsf_conv_rates ';

2192: l_stmt_num := 20;
2193: IF fnd_installation.get_app_info( 'OPI', l_status, l_industry, l_opi_schema) THEN
2194: --{
2195: execute immediate 'truncate table ' || l_opi_schema
2196: || '.opi_dbi_cogsf_conv_rates ';
2197:
2198: execute immediate 'truncate table ' || l_opi_schema
2199: || '.opi_dbi_cogs_fstg ';
2200: --}

Line 2273: gather_stats(p_table_name => 'OPI_DBI_COGSF_CONV_RATES');

2269: get_cogs_conversion_rate_incr( errbuf => errbuf, retcode => retcode );
2270:
2271: commit;
2272:
2273: gather_stats(p_table_name => 'OPI_DBI_COGSF_CONV_RATES');
2274:
2275: IF retcode <> 0 THEN
2276: --{
2277: l_error_flag := TRUE;

Line 2308: opi_dbi_cogsf_conv_rates rate

2304: stg.internal_flag,
2305: min(rate.conversion_rate) conversion_rate,
2306: min(rate.sec_conversion_rate) sec_conversion_rate
2307: FROM opi_dbi_cogs_fstg stg,
2308: opi_dbi_cogsf_conv_rates rate
2309: WHERE stg.organization_id = rate.organization_id
2310: AND trunc (stg.cogs_date) = rate.transaction_date
2311: GROUP BY
2312: stg.inventory_item_id,

Line 2414: || '.opi_dbi_cogsf_conv_rates ';

2410: -- common clean up
2411: l_stmt_num := 110;
2412:
2413: execute immediate 'truncate table ' || l_opi_schema
2414: || '.opi_dbi_cogsf_conv_rates ';
2415:
2416: execute immediate 'truncate table ' || l_opi_schema
2417: || '.opi_dbi_cogs_fstg ';
2418: