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.OKI_DBI_LOAD_CLEB_PVT dependencies on OKI_DBI_CURR_CONV

Line 225: l_sql_string := 'TRUNCATE TABLE ' || l_oki_schema ||'.OKI_DBI_CURR_CONV';

221: l_sql_string := 'TRUNCATE TABLE ' || l_oki_schema || '.OKI_DBI_CHR_INC' ;
222: EXECUTE IMMEDIATE l_sql_string ;
223: rlog( 'Truncated Table OKI_DBI_CHR_INC',2);
224:
225: l_sql_string := 'TRUNCATE TABLE ' || l_oki_schema ||'.OKI_DBI_CURR_CONV';
226: EXECUTE IMMEDIATE l_sql_string;
227: rlog( 'Truncated table OKI_DBI_CURR_CONV' ,2);
228:
229: l_sql_string := 'TRUNCATE TABLE ' || l_oki_schema ||'.OKI_DBI_CLE_B_OLD';

Line 227: rlog( 'Truncated table OKI_DBI_CURR_CONV' ,2);

223: rlog( 'Truncated Table OKI_DBI_CHR_INC',2);
224:
225: l_sql_string := 'TRUNCATE TABLE ' || l_oki_schema ||'.OKI_DBI_CURR_CONV';
226: EXECUTE IMMEDIATE l_sql_string;
227: rlog( 'Truncated table OKI_DBI_CURR_CONV' ,2);
228:
229: l_sql_string := 'TRUNCATE TABLE ' || l_oki_schema ||'.OKI_DBI_CLE_B_OLD';
230: EXECUTE IMMEDIATE l_sql_string;
231: rlog( 'Truncated Table OKI_DBI_CLE_B_OLD' ,2);

Line 365: rlog( 'Populating Currencies Table OKI_DBI_CURR_CONV - ' || fnd_date.date_to_displayDT(sysdate),1);

361: ELSE
362: OKI_DBI_LOAD_CLEB_PVT.populate_inc_table_init;
363: END IF;
364:
365: rlog( 'Populating Currencies Table OKI_DBI_CURR_CONV - ' || fnd_date.date_to_displayDT(sysdate),1);
366: OKI_DBI_LOAD_CLEB_PVT.load_currencies;
367: rlog( 'Load of Currencies Table OKI_DBI_CURR_CONV completed - ' || fnd_date.date_to_displayDT(sysdate),1);
368:
369: rlog( 'Checking negative rates in Table OKI_DBI_CURR_CONV - ' ||

Line 367: rlog( 'Load of Currencies Table OKI_DBI_CURR_CONV completed - ' || fnd_date.date_to_displayDT(sysdate),1);

363: END IF;
364:
365: rlog( 'Populating Currencies Table OKI_DBI_CURR_CONV - ' || fnd_date.date_to_displayDT(sysdate),1);
366: OKI_DBI_LOAD_CLEB_PVT.load_currencies;
367: rlog( 'Load of Currencies Table OKI_DBI_CURR_CONV completed - ' || fnd_date.date_to_displayDT(sysdate),1);
368:
369: rlog( 'Checking negative rates in Table OKI_DBI_CURR_CONV - ' ||
370: fnd_date.date_to_displayDT(sysdate),1);
371: SELECT COUNT(1) INTO l_missing_flag

Line 369: rlog( 'Checking negative rates in Table OKI_DBI_CURR_CONV - ' ||

365: rlog( 'Populating Currencies Table OKI_DBI_CURR_CONV - ' || fnd_date.date_to_displayDT(sysdate),1);
366: OKI_DBI_LOAD_CLEB_PVT.load_currencies;
367: rlog( 'Load of Currencies Table OKI_DBI_CURR_CONV completed - ' || fnd_date.date_to_displayDT(sysdate),1);
368:
369: rlog( 'Checking negative rates in Table OKI_DBI_CURR_CONV - ' ||
370: fnd_date.date_to_displayDT(sysdate),1);
371: SELECT COUNT(1) INTO l_missing_flag
372: FROM oki_dbi_curr_conv
373: --WHERE upper(rate_type) <> 'USER'

Line 372: FROM oki_dbi_curr_conv

368:
369: rlog( 'Checking negative rates in Table OKI_DBI_CURR_CONV - ' ||
370: fnd_date.date_to_displayDT(sysdate),1);
371: SELECT COUNT(1) INTO l_missing_flag
372: FROM oki_dbi_curr_conv
373: --WHERE upper(rate_type) <> 'USER'
374: WHERE (rate_f <= 0 OR rate_g < 0 OR rate_sg < 0 OR rate_f is NULL);
375:
376:

Line 1142: l_sql_string := 'TRUNCATE TABLE ' || l_oki_schema || '.OKI_DBI_CURR_CONV';

1138: l_sql_string := 'TRUNCATE TABLE ' || l_oki_schema || '.OKI_DBI_CLE_B_OLD';
1139: EXECUTE IMMEDIATE l_sql_string;
1140: rlog( 'Truncated Table ' || l_oki_schema || '.OKI_DBI_CLE_B_OLD',1);
1141:
1142: l_sql_string := 'TRUNCATE TABLE ' || l_oki_schema || '.OKI_DBI_CURR_CONV';
1143: EXECUTE IMMEDIATE l_sql_string;
1144: rlog( 'Truncated Table ' || l_oki_schema || '.OKI_DBI_CURR_CONV',1);
1145: l_sql_string := 'TRUNCATE TABLE ' || l_oki_schema || '.OKI_DBI_REN_INC' ;
1146: EXECUTE IMMEDIATE l_sql_string ;

Line 1144: rlog( 'Truncated Table ' || l_oki_schema || '.OKI_DBI_CURR_CONV',1);

1140: rlog( 'Truncated Table ' || l_oki_schema || '.OKI_DBI_CLE_B_OLD',1);
1141:
1142: l_sql_string := 'TRUNCATE TABLE ' || l_oki_schema || '.OKI_DBI_CURR_CONV';
1143: EXECUTE IMMEDIATE l_sql_string;
1144: rlog( 'Truncated Table ' || l_oki_schema || '.OKI_DBI_CURR_CONV',1);
1145: l_sql_string := 'TRUNCATE TABLE ' || l_oki_schema || '.OKI_DBI_REN_INC' ;
1146: EXECUTE IMMEDIATE l_sql_string ;
1147: rlog('Truncated Table OKI_DBI_REN_INC ',1);
1148: l_sql_string := 'TRUNCATE TABLE ' || l_oki_schema || '.OKI_DBI_PREV_INC' ;

Line 1722: INSERT /+ append / INTO oki_dbi_curr_conv

1718: l_sql_string VARCHAR2(10000) ;
1719:
1720: BEGIN
1721:
1722: INSERT /*+ append */ INTO oki_dbi_curr_conv
1723: (chr_id,
1724: from_currency,
1725: to_currency,
1726: curr_conv_date,

Line 1767: rlog( 'Number of lines inserted into OKI_DBI_CURR_CONV : ' || to_char(l_count),2);

1763: , conversion_date ) inc;
1764: -- selecting all the distinct curr conv , "USER" will come as well but FII will return NULL, these rows will be handled when inserting into _old table
1765:
1766: l_count := SQL%ROWCOUNT ;
1767: rlog( 'Number of lines inserted into OKI_DBI_CURR_CONV : ' || to_char(l_count),2);
1768:
1769: COMMIT;
1770:
1771: GATHER_TABLE_STATS(tabname=>'OKI_DBI_CURR_CONV');

Line 1771: GATHER_TABLE_STATS(tabname=>'OKI_DBI_CURR_CONV');

1767: rlog( 'Number of lines inserted into OKI_DBI_CURR_CONV : ' || to_char(l_count),2);
1768:
1769: COMMIT;
1770:
1771: GATHER_TABLE_STATS(tabname=>'OKI_DBI_CURR_CONV');
1772:
1773:
1774:
1775:

Line 1780: rlog('Error during load_currencies: Insert into OKI_DBI_CURR_CONV Failed' , 0);

1776: EXCEPTION
1777: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1778: RAISE;
1779: WHEN OTHERS THEN
1780: rlog('Error during load_currencies: Insert into OKI_DBI_CURR_CONV Failed' , 0);
1781: rlog(sqlerrm ||' '||sqlcode, 0);
1782: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;
1783: fnd_message.set_name( application => 'FND'
1784: , name => 'CRM-DEBUG ERROR' ) ;

Line 1844: FROM oki_dbi_curr_conv

1840: -- Missing currency summary for converting from functional to
1841: -- global currency
1842: FOR r_cur IN (SELECT distinct to_currency func_currency,
1843: decode(rate_g, -3, g_euro_start_date , curr_conv_date) conversion_date
1844: FROM oki_dbi_curr_conv
1845: WHERE curr_conv_date IS NOT NULL
1846: --AND rate_type <> 'USER' --fix for 4102597
1847: AND rate_g < 0
1848: AND rate_g NOT IN (-2,-3,-5)

Line 1873: FROM oki_dbi_curr_conv

1869: -- Missing currency summary for converting from functional to
1870: -- secondary global currency
1871: FOR r_cur IN (SELECT DISTINCT to_currency func_currency
1872: ,decode(rate_sg, -3, g_euro_start_date, curr_conv_date) conversion_date
1873: FROM oki_dbi_curr_conv
1874: WHERE curr_conv_date IS NOT NULL
1875: --AND rate_type <> 'USER' --fix for 4102597
1876: AND rate_sg < 0
1877: AND rate_sg NOT IN (-2,-3,-5)

Line 1906: FROM oki_dbi_curr_conv

1902: FOR r_cur IN (SELECT DISTINCT rate_type AS TRX_RATE_TYPE
1903: , from_currency as TRX_CURRENCY
1904: , to_currency as FUNC_CURRENCY
1905: , decode(rate_f, -3, g_euro_start_date, curr_conv_date) AS CONVERSION_DATE
1906: FROM oki_dbi_curr_conv
1907: WHERE curr_conv_date IS NOT NULL
1908: --AND rate_type <> 'USER' --fix for 4102597
1909: AND ( rate_f <= 0 OR rate_f IS NULL)
1910: ORDER BY conversion_date ASC )

Line 1936: FROM oki_dbi_curr_conv inc

1932: , h.sts_code AS sts_code
1933: , h.id AS chr_id
1934: , inc.to_currency AS func_currency
1935: , decode(inc.rate_g, -3, g_euro_start_date, inc.curr_conv_date) conversion_date
1936: FROM oki_dbi_curr_conv inc
1937: , oki_dbi_chr_inc chr
1938: , okc_k_headers_all_b h
1939: WHERE 1 = 1
1940: --AND inc.rate_type <> 'USER'

Line 1981: FROM oki_dbi_curr_conv inc

1977: , h.sts_code AS sts_code
1978: , h.id AS chr_id
1979: , inc.to_currency AS func_currency
1980: , decode(inc.rate_sg,-3,g_euro_start_date,inc.curr_conv_date) AS CONVERSION_DATE
1981: FROM oki_dbi_curr_conv inc
1982: , oki_dbi_chr_inc chr
1983: , okc_k_headers_all_b h
1984: WHERE inc.rate_sg < 0
1985: AND inc.rate_sg NOT IN (-2,-3,-5)

Line 2028: FROM oki_dbi_curr_conv inc

2024: , inc.rate_type AS trx_rate_type
2025: , inc.from_currency AS trx_currency
2026: , inc.to_currency AS func_currency
2027: , decode(inc.rate_f,-3,g_euro_start_date,inc.curr_conv_date) AS conversion_date
2028: FROM oki_dbi_curr_conv inc
2029: , oki_dbi_chr_inc chr
2030: , okc_k_headers_all_b h
2031: WHERE 1 = 1
2032: --AND inc.rate_type <> 'USER'

Line 2073: FROM oki_dbi_curr_conv inc

2069: , h.id AS chr_id
2070: , inc.to_currency AS func_currency
2071: , inc.curr_conv_date AS conversion_date
2072: , inc.rate_sg func_sglobal_rate
2073: FROM oki_dbi_curr_conv inc
2074: , oki_dbi_chr_inc chr
2075: , okc_k_headers_all_b h
2076: WHERE inc.rate_sg < 0
2077: --AND inc.rate_type <> 'USER'

Line 2823: , oki_dbi_curr_conv cur

2819: , h.HDR_TERM_CANCEL_SOURCE HDR_TERM_CANCEL_SOURCE
2820: , NVL(sl.term_cancel_source, h.HDR_TERM_CANCEL_SOURCE) SL_TERM_CANCEL_SOURCE
2821: FROM
2822: oki_dbi_chr_inc h
2823: , oki_dbi_curr_conv cur
2824: , okc_k_lines_b sl
2825: , okc_k_lines_b l
2826: , ( select /*+ no_merge */ cii.instance_id
2827: , qpl.meaning agreement_type_code

Line 5213: , oki_dbi_curr_conv cur

5209: , h.HDR_TERM_CANCEL_SOURCE HDR_TERM_CANCEL_SOURCE /* ER 6684955 */
5210: , NVL(sl.term_cancel_source, h.HDR_TERM_CANCEL_SOURCE ) SL_TERM_CANCEL_SOURCE /* ER 6684955 */
5211: FROM
5212: oki_dbi_chr_inc h
5213: , oki_dbi_curr_conv cur
5214: , okc_k_lines_b sl
5215: , okc_k_items itm
5216: , okc_k_lines_b l
5217: , ( select /*+ no_merge */ oab.agreement_id