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

Line 131: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_DEL_LEGS';

127: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_WTS_LOG';
128: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_FIH_LOG';
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';

Line 396: INSERT /+ APPEND PARALLEL(tmp) / INTO isc_dbi_tmp_del_legs tmp (

392:
393: BIS_COLLECTION_UTILITIES.put_line('Identifying delivery legs');
394: FII_UTIL.Start_Timer;
395:
396: INSERT /*+ APPEND PARALLEL(tmp) */ INTO isc_dbi_tmp_del_legs tmp (
397: DELIVERY_LEG_ID,
398: CARRIER_ID,
399: SHIPMENT_DIRECTION,
400: MODE_OF_TRANSPORT,

Line 520: isc_dbi_tmp_del_legs idl,

516: fih.currency_code TRX_CURRENCY_CODE,
517: gsb.currency_code WH_CURRENCY_CODE
518: FROM fte_invoice_headers fih,
519: wsh_document_instances wdi,
520: isc_dbi_tmp_del_legs idl,
521: ar_system_parameters_all aspa,
522: gl_sets_of_books gsb
523: WHERE fih.mode_of_transport = 'LTL'
524: AND fih.bill_status in ('APPROVED', 'IN_PROGRESS', 'PAID', 'PARTIALLY PAID', 'PARTIAL_PAID')

Line 579: FROM isc_dbi_tmp_del_legs tmp1

575: INSERT INTO isc_dbi_fte_uom_rates (MEASURE_CODE, FROM_UOM_CODE, TO_UOM_CODE, INVENTORY_ITEM_ID, CONVERSION_RATE)
576: SELECT 'WT', from_uom, g_reporting_weight_uom, NULL inventory_item_id,
577: decode(from_uom, g_reporting_weight_uom, 1, opi_dbi_rep_uom_pkg.uom_convert(NULL, NULL, 1, from_uom, g_reporting_weight_uom))
578: FROM (SELECT /*+ PARALLEL(tmp1) */ DISTINCT weight_uom_code FROM_UOM
579: FROM isc_dbi_tmp_del_legs tmp1
580: WHERE weight_uom_code is not null);
581: END IF;
582:
583: IF g_reporting_volume_uom IS NOT NULL THEN

Line 588: FROM isc_dbi_tmp_del_legs tmp2

584: INSERT INTO isc_dbi_fte_uom_rates (MEASURE_CODE, FROM_UOM_CODE, TO_UOM_CODE, INVENTORY_ITEM_ID, CONVERSION_RATE)
585: SELECT 'VOL', from_uom, g_reporting_volume_uom, NULL inventory_item_id,
586: decode(from_uom, g_reporting_volume_uom, 1, opi_dbi_rep_uom_pkg.uom_convert(NULL, NULL, 1, from_uom, g_reporting_volume_uom))
587: FROM (SELECT /*+ PARALLEL(tmp2) */ DISTINCT volume_uom_code FROM_UOM
588: FROM isc_dbi_tmp_del_legs tmp2
589: WHERE volume_uom_code is not null);
590: END IF;
591:
592: IF g_reporting_distance_uom IS NOT NULL THEN

Line 605: -- FROM isc_dbi_tmp_del_legs tmp1

601: -- INSERT INTO isc_dbi_fte_uom_rates (FROM_UOM_CODE, TO_UOM_CODE, INVENTORY_ITEM_ID, CONVERSION_RATE)
602: -- SELECT from_uom, to_uom, NULL inventory_item_id,
603: -- decode(from_uom, to_uom, 1, opi_dbi_rep_uom_pkg.uom_convert(NULL, NULL, 1, from_uom, to_uom))
604: -- FROM (SELECT /*+ PARALLEL(tmp1) */ DISTINCT weight_uom_code FROM_UOM, 'WT' TO_UOM
605: -- FROM isc_dbi_tmp_del_legs tmp1
606: -- WHERE weight_uom_code is not null
607: -- UNION
608: -- SELECT /*+ PARALLEL(tmp2) */ DISTINCT volume_uom_code FROM_UOM, 'VOL' TO_UOM
609: -- FROM isc_dbi_tmp_del_legs tmp2

Line 609: -- FROM isc_dbi_tmp_del_legs tmp2

605: -- FROM isc_dbi_tmp_del_legs tmp1
606: -- WHERE weight_uom_code is not null
607: -- UNION
608: -- SELECT /*+ PARALLEL(tmp2) */ DISTINCT volume_uom_code FROM_UOM, 'VOL' TO_UOM
609: -- FROM isc_dbi_tmp_del_legs tmp2
610: -- WHERE volume_uom_code is not null
611: -- UNION
612: -- SELECT /*+ PARALLEL(tmp3) */ DISTINCT distance_uom_code, 'DIS' TO_UOM
613: -- FROM isc_dbi_tmp_trip_stops tmp3

Line 633: FROM isc_dbi_tmp_del_legs idl

629: decode(g_sec_global_currency, trx_currency_code, 1, wh_currency_code, 1,
630: fii_currency.get_global_rate_secondary(wh_currency_code, conversion_date)) WH_SEC_RATE
631: FROM (SELECT /*+ PARALLEL(idl) */
632: distinct trx_currency_code, wh_currency_code, conversion_date CONVERSION_DATE, conversion_type_code CONVERSION_TYPE_CODE
633: FROM isc_dbi_tmp_del_legs idl
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

Line 879: INSERT INTO isc_dbi_tmp_del_legs tmp (

875: FII_UTIL.Stop_Timer;
876: FII_UTIL.Print_Timer('Identified '|| sql%rowcount || ' trip stops in');
877: COMMIT;
878:
879: INSERT INTO isc_dbi_tmp_del_legs tmp (
880: DELIVERY_LEG_ID,
881: CARRIER_ID,
882: SHIPMENT_DIRECTION,
883: MODE_OF_TRANSPORT,

Line 967: FROM isc_dbi_tmp_del_legs

963: INSERT INTO isc_dbi_fte_uom_rates (MEASURE_CODE, FROM_UOM_CODE, TO_UOM_CODE, INVENTORY_ITEM_ID, CONVERSION_RATE)
964: SELECT 'WT', from_uom, g_reporting_weight_uom, NULL inventory_item_id,
965: decode(from_uom, g_reporting_weight_uom, 1, opi_dbi_rep_uom_pkg.uom_convert(NULL, NULL, 1, from_uom, g_reporting_weight_uom))
966: FROM (SELECT DISTINCT weight_uom_code FROM_UOM
967: FROM isc_dbi_tmp_del_legs
968: WHERE weight_uom_code is not null);
969: END IF;
970:
971: IF g_reporting_volume_uom IS NOT NULL THEN

Line 976: FROM isc_dbi_tmp_del_legs

972: INSERT INTO isc_dbi_fte_uom_rates (MEASURE_CODE, FROM_UOM_CODE, TO_UOM_CODE, INVENTORY_ITEM_ID, CONVERSION_RATE)
973: SELECT 'VOL', from_uom, g_reporting_volume_uom, NULL inventory_item_id,
974: decode(from_uom, g_reporting_volume_uom, 1, opi_dbi_rep_uom_pkg.uom_convert(NULL, NULL, 1, from_uom, g_reporting_volume_uom))
975: FROM (SELECT DISTINCT volume_uom_code FROM_UOM
976: FROM isc_dbi_tmp_del_legs
977: WHERE volume_uom_code is not null);
978: END IF;
979:
980: IF g_reporting_distance_uom IS NOT NULL THEN

Line 1005: FROM isc_dbi_tmp_del_legs idl

1001: fii_currency.get_global_rate_primary(wh_currency_code, conversion_date)) WH_PRIM_RATE,
1002: decode(g_sec_global_currency, trx_currency_code, 1, wh_currency_code, 1,
1003: fii_currency.get_global_rate_secondary(wh_currency_code, conversion_date)) WH_SEC_RATE
1004: FROM (SELECT distinct trx_currency_code, wh_currency_code, conversion_date CONVERSION_DATE, conversion_type_code CONVERSION_TYPE_CODE
1005: FROM isc_dbi_tmp_del_legs idl
1006: WHERE idl.freight_cost_trx is not null);
1007:
1008: FII_UTIL.Stop_Timer;
1009: FII_UTIL.Print_Timer('Retrieved '||sql%rowcount||' currency rates in');

Line 1014: UPDATE isc_dbi_tmp_del_legs SET batch_id = ceil(rownum/g_batch_size);

1010: COMMIT;
1011:
1012: FII_UTIL.Start_Timer;
1013:
1014: UPDATE isc_dbi_tmp_del_legs SET batch_id = ceil(rownum/g_batch_size);
1015: l_total := l_total + sql%rowcount;
1016:
1017: UPDATE isc_dbi_tmp_trip_stops SET batch_id = ceil(rownum/g_batch_size);
1018: l_total := l_total + sql%rowcount;

Line 1754: FROM isc_dbi_tmp_del_legs

1750: CURSOR Missing_Transaction_UOM IS
1751: SELECT name
1752: FROM wsh_new_deliveries
1753: WHERE delivery_id IN (SELECT distinct delivery_id
1754: FROM isc_dbi_tmp_del_legs
1755: WHERE (freight_weight_trx is not null and weight_uom_code is null)
1756: OR (freight_volume_trx is not null and volume_uom_code is null));
1757:
1758: l_record Missing_UOM_Conversion%ROWTYPE;

Line 2284: FROM isc_dbi_tmp_del_legs v,

2280: sysdate PROGRAM_UPDATE_DATE,
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(+)

Line 2369: from isc_dbi_tmp_del_legs tmp,

2365: sum(decode(tmp.parent_delivery_leg_id,null,freight_cost_trx,decode(tmp.delivery_type,'CONSOLIDATION',freight_cost_trx,0))
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(+)

Line 2653: from isc_dbi_tmp_del_legs tmp,

2649: tmp.volume_uom_code VOLUME_UOM_CODE,
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(+)

Line 2806: from isc_dbi_tmp_del_legs tmp,

2802: sum(decode(tmp.parent_delivery_leg_id,null,freight_cost_trx,decode(tmp.delivery_type,'CONSOLIDATION',freight_cost_trx,0))
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(+)

Line 3119: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_DEL_LEGS';

3115: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_WTS_LOG';
3116: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_FIH_LOG';
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';

Line 3244: TABNAME => 'ISC_DBI_TMP_DEL_LEGS');

3240:
3241: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3242: TABNAME => 'ISC_DBI_TMP_DEL_DETAILS');
3243: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
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');

Line 3547: TABNAME => 'ISC_DBI_TMP_DEL_LEGS');

3543: BIS_COLLECTION_UTILITIES.Put_Line('Analyzing temp tables');
3544: FII_UTIL.Start_Timer;
3545:
3546: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
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');