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.ISC_DBI_WSH_FTE_OBJECTS_C dependencies on ISC_DBI_FTE_CURR_RATES

Line 134: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_FTE_CURR_RATES';

130: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_DEL_DETAILS';
131: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_DEL_LEGS';
132: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_TRIP_STOPS';
133: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_FTE_INVOICES';
134: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_FTE_CURR_RATES';
135: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_FTE_UOM_RATES';
136:
137: FII_UTIL.Stop_Timer;
138: FII_UTIL.Print_Timer('Truncated the temp tables in');

Line 622: INSERT /+ APPEND / INTO isc_dbi_fte_curr_rates

618: COMMIT;
619:
620: FII_UTIL.Start_Timer;
621:
622: INSERT /*+ APPEND */ INTO isc_dbi_fte_curr_rates
623: (TRX_CURRENCY_CODE, WH_CURRENCY_CODE, CONVERSION_DATE, CONVERSION_TYPE_CODE, TRX_WH_RATE, WH_PRIM_RATE, WH_SEC_RATE)
624: SELECT trx_currency_code, wh_currency_code, conversion_date, conversion_type_code,
625: decode(trx_currency_code, wh_currency_code, 1,
626: fii_currency.get_rate(trx_currency_code, wh_currency_code, conversion_date, conversion_type_code)) TRX_WH_RATE,

Line 995: INSERT INTO isc_dbi_fte_curr_rates

991: COMMIT;
992:
993: FII_UTIL.Start_Timer;
994:
995: INSERT INTO isc_dbi_fte_curr_rates
996: (TRX_CURRENCY_CODE, WH_CURRENCY_CODE, CONVERSION_DATE, CONVERSION_TYPE_CODE, TRX_WH_RATE, WH_PRIM_RATE, WH_SEC_RATE)
997: SELECT trx_currency_code, wh_currency_code, conversion_date, conversion_type_code,
998: decode(trx_currency_code, wh_currency_code, 1,
999: fii_currency.get_rate(trx_currency_code, wh_currency_code, conversion_date, conversion_type_code)) TRX_WH_RATE,

Line 1169: INSERT INTO isc_dbi_fte_curr_rates

1165: COMMIT;
1166:
1167: FII_UTIL.Start_Timer;
1168:
1169: INSERT INTO isc_dbi_fte_curr_rates
1170: (TRX_CURRENCY_CODE, WH_CURRENCY_CODE, CONVERSION_DATE, CONVERSION_TYPE_CODE, TRX_WH_RATE, WH_PRIM_RATE, WH_SEC_RATE)
1171: SELECT trx_currency_code, wh_currency_code, conversion_date, conversion_type_code,
1172: decode(trx_currency_code, wh_currency_code, 1,
1173: fii_currency.get_rate(trx_currency_code, wh_currency_code, conversion_date, conversion_type_code)) TRX_WH_RATE,

Line 1671: FROM isc_dbi_fte_curr_rates tmp

1667: trx_currency_code FROM_CURRENCY,
1668: wh_currency_code TO_CURRENCY,
1669: conversion_type_code RATE_TYPE,
1670: decode(trx_wh_rate, -1, 'RATE NOT AVAILABLE', -2, 'INVALID CURRENCY') STATUS
1671: FROM isc_dbi_fte_curr_rates tmp
1672: WHERE trx_wh_rate < 0
1673: AND upper(conversion_type_code) <> 'USER'
1674: UNION
1675: SELECT distinct decode(wh_prim_rate, -3, to_date('01/01/1999','MM/DD/RRRR'), conversion_date) CURR_CONV_DATE,

Line 1680: FROM isc_dbi_fte_curr_rates tmp

1676: wh_currency_code FROM_CURRENCY,
1677: g_global_currency TO_CURRENCY,
1678: g_global_rate_type RATE_TYPE,
1679: decode(wh_prim_rate, -1, 'RATE NOT AVAILABLE', -2, 'INVALID CURRENCY') STATUS
1680: FROM isc_dbi_fte_curr_rates tmp
1681: WHERE wh_prim_rate < 0
1682: UNION
1683: SELECT distinct decode(wh_sec_rate, -3, to_date('01/01/1999','MM/DD/RRRR'), conversion_date) CURR_CONV_DATE,
1684: wh_currency_code FROM_CURRENCY,

Line 1688: FROM isc_dbi_fte_curr_rates tmp

1684: wh_currency_code FROM_CURRENCY,
1685: g_sec_global_currency TO_CURRENCY,
1686: g_sec_global_rate_type RATE_TYPE,
1687: decode(wh_sec_rate, -1, 'RATE NOT AVAILABLE', -2, 'INVALID CURRENCY') STATUS
1688: FROM isc_dbi_fte_curr_rates tmp
1689: WHERE wh_sec_rate < 0
1690: AND g_sec_curr_def = 'Y';
1691:
1692: l_record Missing_Currency_Conversion%ROWTYPE;

Line 2285: isc_dbi_fte_curr_rates curr,

2281: -1 REQUEST_ID,
2282: v.delivery_type DELIVERY_TYPE,
2283: v.parent_delivery_leg_id PARENT_DELIVERY_LEG_ID
2284: FROM isc_dbi_tmp_del_legs v,
2285: isc_dbi_fte_curr_rates curr,
2286: isc_dbi_fte_uom_rates w_rates,
2287: isc_dbi_fte_uom_rates v_rates
2288: WHERE v.weight_uom_code = w_rates.from_uom_code(+)
2289: AND w_rates.measure_code(+) = 'WT'

Line 2370: isc_dbi_fte_curr_rates curr

2366: * decode(tmp.trx_currency_code,g_global_currency,1,curr.trx_wh_rate * curr.wh_prim_rate)) TRIP_FREIGHT_COST_G,
2367: sum(decode(tmp.parent_delivery_leg_id,null,freight_cost_trx,decode(tmp.delivery_type,'CONSOLIDATION',freight_cost_trx,0))
2368: * decode(tmp.trx_currency_code,g_sec_global_currency,1,curr.trx_wh_rate*curr.wh_sec_rate)) TRIP_FREIGHT_COST_G1
2369: from isc_dbi_tmp_del_legs tmp,
2370: isc_dbi_fte_curr_rates curr
2371: where tmp.trx_currency_code = curr.trx_currency_code(+)
2372: and tmp.wh_currency_code = curr.wh_currency_code(+)
2373: and tmp.conversion_date = curr.conversion_date(+)
2374: and tmp.conversion_type_code = curr.conversion_type_code(+)

Line 2454: isc_dbi_fte_curr_rates curr

2450: -1 PROGRAM_ID,
2451: sysdate PROGRAM_UPDATE_DATE,
2452: -1 REQUEST_ID
2453: FROM isc_dbi_tmp_fte_invoices v,
2454: isc_dbi_fte_curr_rates curr
2455: WHERE v.trx_currency_code = curr.trx_currency_code
2456: AND v.wh_currency_code = curr.wh_currency_code
2457: AND v.conversion_date = curr.conversion_date
2458: AND v.conversion_type_code = curr.conversion_type_code;

Line 2654: isc_dbi_fte_curr_rates curr,

2650: tmp.weight_uom_code WEIGHT_UOM_CODE,
2651: tmp.delivery_type DELIVERY_TYPE,
2652: tmp.parent_delivery_leg_id PARENT_DELIVERY_LEG_ID
2653: from isc_dbi_tmp_del_legs tmp,
2654: isc_dbi_fte_curr_rates curr,
2655: isc_dbi_fte_uom_rates w_rates,
2656: isc_dbi_fte_uom_rates v_rates
2657: where tmp.weight_uom_code = w_rates.from_uom_code(+)
2658: and w_rates.measure_code(+) = 'WT'

Line 2807: isc_dbi_fte_curr_rates curr

2803: * decode(tmp.trx_currency_code,g_global_currency,1,curr.trx_wh_rate * curr.wh_prim_rate)) TRIP_FREIGHT_COST_G,
2804: sum(decode(tmp.parent_delivery_leg_id,null,freight_cost_trx,decode(tmp.delivery_type,'CONSOLIDATION',freight_cost_trx,0))
2805: * decode(tmp.trx_currency_code,g_sec_global_currency,1,curr.trx_wh_rate*curr.wh_sec_rate)) TRIP_FREIGHT_COST_G1
2806: from isc_dbi_tmp_del_legs tmp,
2807: isc_dbi_fte_curr_rates curr
2808: where tmp.trx_currency_code = curr.trx_currency_code(+)
2809: and tmp.wh_currency_code = curr.wh_currency_code(+)
2810: and tmp.conversion_date = curr.conversion_date(+)
2811: and tmp.conversion_type_code = curr.conversion_type_code(+)

Line 2982: from isc_dbi_tmp_fte_invoices tmp, isc_dbi_fte_curr_rates curr

2978: tmp.bill_type BILL_TYPE,
2979: tmp.bol BOL,
2980: tmp.delivery_leg_id DELIVERY_LEG_ID,
2981: tmp.trip_id TRIP_ID
2982: from isc_dbi_tmp_fte_invoices tmp, isc_dbi_fte_curr_rates curr
2983: where tmp.trx_currency_code = curr.trx_currency_code
2984: and tmp.wh_currency_code = curr.wh_currency_code
2985: and tmp.conversion_date = curr.conversion_date
2986: and tmp.conversion_type_code = curr.conversion_type_code

Line 3122: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_FTE_CURR_RATES';

3118: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_DEL_DETAILS';
3119: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_DEL_LEGS';
3120: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_TRIP_STOPS';
3121: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_FTE_INVOICES';
3122: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_FTE_CURR_RATES';
3123: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_FTE_UOM_RATES';
3124:
3125: FII_UTIL.Stop_Timer;
3126: FII_UTIL.Print_Timer('Truncated the temp tables in');

Line 3250: TABNAME => 'ISC_DBI_FTE_CURR_RATES');

3246: TABNAME => 'ISC_DBI_TMP_TRIP_STOPS');
3247: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3248: TABNAME => 'ISC_DBI_TMP_FTE_INVOICES');
3249: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3250: TABNAME => 'ISC_DBI_FTE_CURR_RATES');
3251: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3252: TABNAME => 'ISC_DBI_FTE_UOM_RATES');
3253:
3254: FII_UTIL.Stop_Timer;

Line 3551: TABNAME => 'ISC_DBI_FTE_CURR_RATES');

3547: TABNAME => 'ISC_DBI_TMP_DEL_LEGS');
3548: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3549: TABNAME => 'ISC_DBI_TMP_TRIP_STOPS');
3550: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3551: TABNAME => 'ISC_DBI_FTE_CURR_RATES');
3552: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3553: TABNAME => 'ISC_DBI_FTE_UOM_RATES');
3554:
3555: FII_UTIL.Stop_Timer;

Line 3701: TABNAME => 'ISC_DBI_FTE_CURR_RATES');

3697:
3698: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3699: TABNAME => 'ISC_DBI_TMP_FTE_INVOICES');
3700: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3701: TABNAME => 'ISC_DBI_FTE_CURR_RATES');
3702:
3703: FII_UTIL.Stop_Timer;
3704: FII_UTIL.Print_Timer('Analyzed the temp tables in ');
3705: