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_TRIP_STOPS

Line 132: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_TRIP_STOPS';

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';
136:

Line 344: INSERT /+ APPEND PARALLEL(tmp) / INTO isc_dbi_tmp_trip_stops tmp (

340:
341: BIS_COLLECTION_UTILITIES.put_line('Identifying trip stops');
342: FII_UTIL.Start_Timer;
343:
344: INSERT /*+ APPEND PARALLEL(tmp) */ INTO isc_dbi_tmp_trip_stops tmp (
345: STOP_ID,
346: CARRIER_ID,
347: MODE_OF_TRANSPORT,
348: SERVICE_LEVEL,

Line 461: isc_dbi_tmp_trip_stops its,

457: AND (wdl.parent_delivery_leg_id is null
458: OR wnd.delivery_type = 'CONSOLIDATION')
459: AND wfct.name = 'SUMMARY'
460: AND wfct.freight_cost_type_code = 'FTESUMMARY') ifc,
461: isc_dbi_tmp_trip_stops its,
462: hr_organization_information hoi,
463: gl_sets_of_books gsb
464: WHERE wdl.delivery_id = wnd.delivery_id
465: AND wnd.initial_pickup_date >= g_global_start_date

Line 554: isc_dbi_tmp_trip_stops itr,

550: fih.currency_code TRX_CURRENCY_CODE,
551: gsb.currency_code WH_CURRENCY_CODE
552: FROM fte_invoice_headers fih,
553: wsh_document_instances wdi,
554: isc_dbi_tmp_trip_stops itr,
555: ar_system_parameters_all aspa,
556: gl_sets_of_books gsb
557: WHERE fih.mode_of_transport = 'TL'
558: AND fih.bill_status in ('APPROVED', 'IN_PROGRESS', 'PAID', 'PARTIALLY PAID', 'PARTIAL_PAID')

Line 597: FROM isc_dbi_tmp_trip_stops tmp3

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
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)

Line 613: -- FROM isc_dbi_tmp_trip_stops tmp3

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
614: -- where distance_uom_code is not null);
615:
616: FII_UTIL.Stop_Timer;
617: FII_UTIL.Print_Timer('Retrieved '||sql%rowcount||' uom rates in');

Line 831: INSERT INTO isc_dbi_tmp_trip_stops tmp (

827: COMMIT;
828:
829: FII_UTIL.Start_Timer;
830:
831: INSERT INTO isc_dbi_tmp_trip_stops tmp (
832: STOP_ID,
833: CARRIER_ID,
834: MODE_OF_TRANSPORT,
835: SERVICE_LEVEL,

Line 944: isc_dbi_tmp_trip_stops its,

940: AND (wdl.parent_delivery_leg_id is null
941: OR wnd.delivery_type = 'CONSOLIDATION')
942: AND wfct.name = 'SUMMARY'
943: AND wfct.freight_cost_type_code = 'FTESUMMARY') ifc,
944: isc_dbi_tmp_trip_stops its,
945: hr_organization_information hoi,
946: gl_sets_of_books gsb
947: WHERE wdl.delivery_id = wnd.delivery_id
948: AND wnd.initial_pickup_date >= g_global_start_date

Line 985: FROM isc_dbi_tmp_trip_stops

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
986: where distance_uom_code is not null);
987: END IF;
988:
989: FII_UTIL.Stop_Timer;

Line 1017: UPDATE isc_dbi_tmp_trip_stops SET batch_id = ceil(rownum/g_batch_size);

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;
1019:
1020: COMMIT;
1021:

Line 1242: FROM isc_dbi_tmp_trip_stops tmp

1238: stop_id,
1239: to_char(time_actl_arrl_date_id, 'MM/DD/YYYY') time_actl_arrl_date_id,
1240: to_char(actual_departure_date, 'MM/DD/YYYY') time_actl_dept_date_id,
1241: to_char(time_pln_arrl_date_id,'MM/DD/YYYY') time_pln_arrl_date_id
1242: FROM isc_dbi_tmp_trip_stops tmp
1243: WHERE (least(nvl(time_actl_arrl_date_id,l_time_min),nvl(trunc(actual_departure_date),l_time_min), nvl(time_pln_arrl_date_id,l_time_min)) < l_time_min
1244: OR greatest(nvl(time_actl_arrl_date_id,l_time_max),nvl(trunc(actual_departure_date),l_time_max), nvl(time_pln_arrl_date_id,l_time_max)) > l_time_max);
1245:
1246: l_line LINES_MISSING_DATE%ROWTYPE;

Line 1269: FROM isc_dbi_tmp_trip_stops tmp;

1265: min(time_actl_arrl_date_id), max(time_actl_arrl_date_id),
1266: min(time_init_dept_date_id), max(time_init_dept_date_id),
1267: min(time_pln_arrl_date_id), max(time_pln_arrl_date_id)
1268: INTO l_min_actl_arrl_date, l_max_actl_arrl_date, l_min_init_dept_date, l_max_init_dept_date, l_min_pln_arrl_date, l_max_pln_arrl_date
1269: FROM isc_dbi_tmp_trip_stops tmp;
1270:
1271: l_min := least(nvl(l_min_ip_date,sysdate), nvl(l_min_pr_date,sysdate), nvl(l_min_actl_arrl_date,sysdate),
1272: nvl(l_min_init_dept_date,sysdate), nvl(l_min_pln_arrl_date,sysdate));
1273: l_max := greatest(nvl(l_max_ip_date,sysdate), nvl(l_max_pr_date,sysdate), nvl(l_max_actl_arrl_date,sysdate),

Line 1475: FROM isc_dbi_tmp_trip_stops

1471: stop_id,
1472: to_char(time_actl_arrl_date_id, 'MM/DD/YYYY') time_actl_arrl_date_id,
1473: to_char(actual_departure_date, 'MM/DD/YYYY') time_actl_dept_date_id,
1474: to_char(time_pln_arrl_date_id,'MM/DD/YYYY') time_pln_arrl_date_id
1475: FROM isc_dbi_tmp_trip_stops
1476: WHERE (least(nvl(time_actl_arrl_date_id,l_time_min), nvl(trunc(actual_departure_date),l_time_min), nvl(time_pln_arrl_date_id,l_time_min)) < l_time_min
1477: OR greatest(nvl(time_actl_arrl_date_id,l_time_max),nvl(trunc(actual_departure_date),l_time_max), nvl(time_pln_arrl_date_id,l_time_max)) > l_time_max);
1478:
1479: l_stop STOPS_MISSING_DATE%ROWTYPE;

Line 1493: FROM isc_dbi_tmp_trip_stops tmp;

1489: SELECT min(time_actl_arrl_date_id), max(time_actl_arrl_date_id),
1490: min(time_init_dept_date_id), max(time_init_dept_date_id),
1491: min(time_pln_arrl_date_id), max(time_pln_arrl_date_id)
1492: INTO l_min_actl_arrl_date, l_max_actl_arrl_date, l_min_init_dept_date, l_max_init_dept_date, l_min_pln_arrl_date, l_max_pln_arrl_date
1493: FROM isc_dbi_tmp_trip_stops tmp;
1494:
1495: l_min := least(nvl(l_min_actl_arrl_date,sysdate), nvl(l_min_init_dept_date,sysdate), nvl(l_min_pln_arrl_date,sysdate));
1496: l_max := greatest(nvl(l_max_actl_arrl_date,sysdate), nvl(l_max_init_dept_date,sysdate), nvl(l_max_pln_arrl_date,sysdate));
1497:

Line 2363: FROM isc_dbi_tmp_trip_stops v,

2359: -1 PROGRAM_APPLICATION_ID,
2360: -1 PROGRAM_ID,
2361: sysdate PROGRAM_UPDATE_DATE,
2362: -1 REQUEST_ID
2363: FROM isc_dbi_tmp_trip_stops v,
2364: (select /*+ PARALLEL(tmp) */ trip_id,
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))

Line 2800: from isc_dbi_tmp_trip_stops v,

2796: itr.trip_freight_cost_g TRIP_FREIGHT_COST_G,
2797: itr.trip_freight_cost_g1 TRIP_FREIGHT_COST_G1,
2798: v.trip_id TRIP_ID,
2799: v.ultimate_stop_sequence_number ULTIMATE_STOP_SEQUENCE_NUMBER
2800: from isc_dbi_tmp_trip_stops v,
2801: (select trip_id,
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))

Line 3120: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_TRIP_STOPS';

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';
3124:

Line 3246: TABNAME => 'ISC_DBI_TMP_TRIP_STOPS');

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');
3249: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3250: TABNAME => 'ISC_DBI_FTE_CURR_RATES');

Line 3549: TABNAME => 'ISC_DBI_TMP_TRIP_STOPS');

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');
3552: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3553: TABNAME => 'ISC_DBI_FTE_UOM_RATES');