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_FTE_UOM_RATES

Line 135: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_FTE_UOM_RATES';

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');
139: BIS_COLLECTION_UTILITIES.Put_Line(' ');

Line 575: INSERT INTO isc_dbi_fte_uom_rates (MEASURE_CODE, FROM_UOM_CODE, TO_UOM_CODE, INVENTORY_ITEM_ID, CONVERSION_RATE)

571:
572: FII_UTIL.Start_Timer;
573:
574: IF g_reporting_weight_uom IS NOT NULL THEN
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

Line 584: INSERT INTO isc_dbi_fte_uom_rates (MEASURE_CODE, FROM_UOM_CODE, TO_UOM_CODE, INVENTORY_ITEM_ID, CONVERSION_RATE)

580: WHERE weight_uom_code is not null);
581: END IF;
582:
583: IF g_reporting_volume_uom IS NOT NULL THEN
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

Line 593: INSERT INTO isc_dbi_fte_uom_rates (MEASURE_CODE, FROM_UOM_CODE, TO_UOM_CODE, INVENTORY_ITEM_ID, CONVERSION_RATE)

589: WHERE volume_uom_code is not null);
590: END IF;
591:
592: IF g_reporting_distance_uom IS NOT NULL THEN
593: INSERT INTO isc_dbi_fte_uom_rates (MEASURE_CODE, FROM_UOM_CODE, TO_UOM_CODE, INVENTORY_ITEM_ID, CONVERSION_RATE)
594: SELECT 'DIS', from_uom, g_reporting_distance_uom, NULL inventory_item_id,
595: decode(from_uom,g_reporting_distance_uom,1,opi_dbi_rep_uom_pkg.uom_convert(NULL, NULL, 1, from_uom, g_reporting_distance_uom))
596: FROM (SELECT /*+ PARALLEL(tmp3) */ DISTINCT distance_uom_code FROM_UOM
597: FROM isc_dbi_tmp_trip_stops tmp3

Line 601: -- INSERT INTO isc_dbi_fte_uom_rates (FROM_UOM_CODE, TO_UOM_CODE, INVENTORY_ITEM_ID, CONVERSION_RATE)

597: FROM isc_dbi_tmp_trip_stops tmp3
598: where distance_uom_code is not null);
599: END IF;
600:
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

Line 963: INSERT INTO isc_dbi_fte_uom_rates (MEASURE_CODE, FROM_UOM_CODE, TO_UOM_CODE, INVENTORY_ITEM_ID, CONVERSION_RATE)

959:
960: FII_UTIL.Start_Timer;
961:
962: IF g_reporting_weight_uom IS NOT NULL THEN
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

Line 972: INSERT INTO isc_dbi_fte_uom_rates (MEASURE_CODE, FROM_UOM_CODE, TO_UOM_CODE, INVENTORY_ITEM_ID, CONVERSION_RATE)

968: WHERE weight_uom_code is not null);
969: END IF;
970:
971: IF g_reporting_volume_uom IS NOT NULL THEN
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

Line 981: INSERT INTO isc_dbi_fte_uom_rates (MEASURE_CODE, FROM_UOM_CODE, TO_UOM_CODE, INVENTORY_ITEM_ID, CONVERSION_RATE)

977: WHERE volume_uom_code is not null);
978: END IF;
979:
980: IF g_reporting_distance_uom IS NOT NULL THEN
981: INSERT INTO isc_dbi_fte_uom_rates (MEASURE_CODE, FROM_UOM_CODE, TO_UOM_CODE, INVENTORY_ITEM_ID, CONVERSION_RATE)
982: SELECT 'DIS', from_uom, g_reporting_distance_uom, NULL inventory_item_id,
983: decode(from_uom,g_reporting_distance_uom,1,opi_dbi_rep_uom_pkg.uom_convert(NULL, NULL, 1, from_uom, g_reporting_distance_uom))
984: FROM (SELECT DISTINCT distance_uom_code FROM_UOM
985: FROM isc_dbi_tmp_trip_stops

Line 1747: FROM isc_dbi_fte_uom_rates

1743: CURSOR Missing_UOM_Conversion IS
1744: SELECT distinct inventory_item_id,
1745: from_uom_code from_unit,
1746: to_uom_code to_unit
1747: FROM isc_dbi_fte_uom_rates
1748: WHERE conversion_rate between -99999 and -99995;
1749:
1750: CURSOR Missing_Transaction_UOM IS
1751: SELECT name

Line 2286: isc_dbi_fte_uom_rates w_rates,

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'
2290: AND v.volume_uom_code = v_rates.from_uom_code(+)

Line 2287: isc_dbi_fte_uom_rates v_rates

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'
2290: AND v.volume_uom_code = v_rates.from_uom_code(+)
2291: AND v_rates.measure_code(+) = 'VOL'

Line 2376: isc_dbi_fte_uom_rates d_rates

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(+)
2375: group by trip_id) itr,
2376: isc_dbi_fte_uom_rates d_rates
2377: WHERE v.trip_id = itr.trip_id
2378: AND v.distance_uom_code = d_rates.from_uom_code(+)
2379: AND d_rates.measure_code(+) = 'DIS';
2380:

Line 2655: isc_dbi_fte_uom_rates w_rates,

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'
2659: and tmp.volume_uom_code = v_rates.from_uom_code(+)

Line 2656: isc_dbi_fte_uom_rates v_rates

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'
2659: and tmp.volume_uom_code = v_rates.from_uom_code(+)
2660: and v_rates.measure_code(+) = 'VOL'

Line 2813: isc_dbi_fte_uom_rates d_rates

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(+)
2812: group by trip_id) itr,
2813: isc_dbi_fte_uom_rates d_rates
2814: where v.trip_id = itr.trip_id
2815: and v.distance_uom_code = d_rates.from_uom_code(+)
2816: and d_rates.measure_code(+) = 'DIS'
2817: and v.batch_id = v_batch_id) new, isc_dbi_trip_stops_f old

Line 3123: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_FTE_UOM_RATES';

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');
3127: BIS_COLLECTION_UTILITIES.Put_Line(' ');

Line 3252: TABNAME => 'ISC_DBI_FTE_UOM_RATES');

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;
3255: FII_UTIL.Print_Timer('Analyzed the temp tables in ');
3256:

Line 3553: TABNAME => 'ISC_DBI_FTE_UOM_RATES');

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;
3556: FII_UTIL.Print_Timer('Analyzed the temp tables in ');
3557: