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_TMP_FTE_INVOICES

Line 133: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_FTE_INVOICES';

129:
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;

Line 480: INSERT /+ APPEND PARALLEL(tmp) / INTO isc_dbi_tmp_fte_invoices tmp (

476: COMMIT;
477:
478: FII_UTIL.Start_Timer;
479:
480: INSERT /*+ APPEND PARALLEL(tmp) */ INTO isc_dbi_tmp_fte_invoices tmp (
481: INVOICE_HEADER_ID,
482: CARRIER_ID,
483: MODE_OF_TRANSPORT,
484: ORG_ID,

Line 638: FROM isc_dbi_tmp_fte_invoices ifi);

634: WHERE idl.freight_cost_trx is not null
635: UNION
636: SELECT /*+ PARALLEL(ifi) */
637: distinct trx_currency_code, wh_currency_code, conversion_date, conversion_type_code CONVERSION_TYPE_CODE
638: FROM isc_dbi_tmp_fte_invoices ifi);
639:
640: FII_UTIL.Stop_Timer;
641: FII_UTIL.Print_Timer('Retrieved '||sql%rowcount||' currency rates in');
642: COMMIT;

Line 1072: INSERT INTO isc_dbi_tmp_fte_invoices tmp (

1068: COMMIT;
1069:
1070: FII_UTIL.Start_Timer;
1071:
1072: INSERT INTO isc_dbi_tmp_fte_invoices tmp (
1073: INVOICE_HEADER_ID,
1074: CARRIER_ID,
1075: MODE_OF_TRANSPORT,
1076: ORG_ID,

Line 1179: FROM isc_dbi_tmp_fte_invoices);

1175: fii_currency.get_global_rate_primary(wh_currency_code, conversion_date)) WH_PRIM_RATE,
1176: decode(g_sec_global_currency, trx_currency_code, 1, wh_currency_code, 1,
1177: fii_currency.get_global_rate_secondary(wh_currency_code, conversion_date)) WH_SEC_RATE
1178: FROM (SELECT distinct trx_currency_code, wh_currency_code, conversion_date, conversion_type_code CONVERSION_TYPE_CODE
1179: FROM isc_dbi_tmp_fte_invoices);
1180:
1181: FII_UTIL.Stop_Timer;
1182: FII_UTIL.Print_Timer('Retrieved '||sql%rowcount||' currency rates in');
1183: COMMIT;

Line 1187: UPDATE isc_dbi_tmp_fte_invoices SET batch_id = ceil(rownum/g_batch_size);

1183: COMMIT;
1184:
1185: FII_UTIL.Start_Timer;
1186:
1187: UPDATE isc_dbi_tmp_fte_invoices SET batch_id = ceil(rownum/g_batch_size);
1188: l_total := l_total + sql%rowcount;
1189:
1190: COMMIT;
1191:

Line 2453: FROM isc_dbi_tmp_fte_invoices v,

2449: -1 PROGRAM_APPLICATION_ID,
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

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 3121: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_FTE_INVOICES';

3117:
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;

Line 3248: TABNAME => 'ISC_DBI_TMP_FTE_INVOICES');

3244: TABNAME => 'ISC_DBI_TMP_DEL_LEGS');
3245: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
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');

Line 3699: TABNAME => 'ISC_DBI_TMP_FTE_INVOICES');

3695: BIS_COLLECTION_UTILITIES.Put_Line('Analyzing temp tables');
3696: FII_UTIL.Start_Timer;
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;