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.WMS_SHIPPING_TRANSACTION_PUB dependencies on WSH_DELIVERY_LEGS

Line 119: wsh_delivery_legs_ob_grp_v wdl, wsh_Trip_stops_ob_grp_v wts, mtl_item_locations_kfv milk1,wsh_trips wt

115: --cursor to check if any apptmts within the current time window.
116: CURSOR current_schedule_cur IS
117: SELECT 1
118: FROM wms_dock_appointments_b wda, mtl_item_locations_kfv milk,
119: wsh_delivery_legs_ob_grp_v wdl, wsh_Trip_stops_ob_grp_v wts, mtl_item_locations_kfv milk1,wsh_trips wt
120: WHERE wda.dock_id = milk.inventory_location_id (+)
121: and wda.organization_id = milk.organization_id (+)
122: and wda.trip_stop = wdl.pick_up_stop_id (+)
123: and wdl.pick_up_stop_id = wts.stop_id (+)

Line 140: wsh_delivery_legs_ob_grp_v wdl,wsh_Trip_stops_ob_grp_v wts, mtl_item_locations_kfv milk1,wsh_trips wt

136: --cursor to check if any apptmts missed to be used in the past.
137: CURSOR last_recent_schedule_cur IS
138: SELECT 1
139: FROM wms_dock_appointments_b wda, mtl_item_locations_kfv milk,
140: wsh_delivery_legs_ob_grp_v wdl,wsh_Trip_stops_ob_grp_v wts, mtl_item_locations_kfv milk1,wsh_trips wt
141: WHERE wda.dock_id = milk.inventory_location_id (+)
142: and wda.organization_id = milk.organization_id (+)
143: and wda.trip_stop = wdl.pick_up_stop_id (+)
144: and wdl.pick_up_stop_id = wts.stop_id (+)

Line 187: , wsh_delivery_legs_ob_grp_v wdl

183: , is_loaded(p_organization_id,wda.dock_id,'Y')
184: , wt.name trip_name
185: from wms_dock_appointments_b wda
186: , mtl_item_locations_kfv milk
187: , wsh_delivery_legs_ob_grp_v wdl
188: , wsh_Trip_stops_ob_grp_v wts
189: , mtl_item_locations_kfv milk1
190: ,wsh_trips wt
191: where wda.dock_id = milk.inventory_location_id (+)

Line 224: FROM wms_dock_appointments_b wda, mtl_item_locations_kfv milk, wsh_delivery_legs_ob_grp_v wdl,

220: wda.dock_appointment_id, wda.organization_id, wda.trip_stop, wts.trip_id,
221: milk1.subinventory_code, milk1.concatenated_segments ,
222: WMS_SHIPPING_TRANSACTION_PUB.is_loaded(p_organization_id,wda.dock_id,'Y') is_loaded ,
223: wt.name trip_name , ( SYSDATE - wda.end_time ) last_schedule_time_diff
224: FROM wms_dock_appointments_b wda, mtl_item_locations_kfv milk, wsh_delivery_legs_ob_grp_v wdl,
225: wsh_Trip_stops_ob_grp_v wts, mtl_item_locations_kfv milk1,wsh_trips wt
226: WHERE wda.dock_id = milk.inventory_location_id (+)
227: and wda.organization_id = milk.organization_id (+)
228: and wda.trip_stop = wdl.pick_up_stop_id (+)

Line 253: FROM wms_dock_appointments_b wda, mtl_item_locations_kfv milk, wsh_delivery_legs_ob_grp_v wdl,

249: wda.dock_appointment_id, wda.organization_id, wda.trip_stop, wts.trip_id,
250: milk1.subinventory_code, milk1.concatenated_segments ,
251: WMS_SHIPPING_TRANSACTION_PUB.is_loaded(p_organization_id,wda.dock_id,'Y') is_loaded ,
252: wt.name trip_name , ( wda.start_time - SYSDATE) next_schedule_time_diff
253: FROM wms_dock_appointments_b wda, mtl_item_locations_kfv milk, wsh_delivery_legs_ob_grp_v wdl,
254: wsh_Trip_stops_ob_grp_v wts, mtl_item_locations_kfv milk1,wsh_trips wt
255: WHERE wda.dock_id = milk.inventory_location_id (+)
256: and wda.organization_id = milk.organization_id (+)
257: and wda.trip_stop = wdl.pick_up_stop_id (+)

Line 487: from wsh_delivery_legs_ob_grp_v wdl

483: p_trip_id IN NUMBER) IS
484: BEGIN
485: open x_delivery_lov FOR
486: select wdl.delivery_id
487: from wsh_delivery_legs_ob_grp_v wdl
488: , wsh_trip_stops_ob_grp_v pickup_stop
489: , wsh_trip_stops_ob_grp_v dropoff_stop
490: where wdl.pick_up_stop_id = pickup_stop.stop_id
491: and wdl.drop_off_stop_id = dropoff_stop.stop_id

Line 566: , wsh_delivery_legs_ob_grp_v wdl

562: open x_delivery_detail_id for
563: select wdd.delivery_detail_id, wdd.lpn_id
564: from wsh_delivery_details_ob_grp_v wdd
565: , wsh_delivery_assignments_v wda
566: , wsh_delivery_legs_ob_grp_v wdl
567: , wsh_trip_stops_ob_grp_v pickup_stop
568: , wsh_trip_stops_ob_grp_v dropoff_stop
569: where wdd.delivery_detail_id = wda.delivery_detail_id
570: and wda.delivery_id = wdl.delivery_id

Line 743: FROM wsh_delivery_legs_ob_grp_v wdl

739: -- get the trip id if there is a trip associated with the delivery
740: BEGIN
741: SELECT wts.trip_id
742: INTO l_trip_id
743: FROM wsh_delivery_legs_ob_grp_v wdl
744: , wsh_trip_stops_ob_grp_v wts
745: WHERE wdl.delivery_id = l_delivery_id
746: AND wdl.pick_up_stop_id = wts.stop_id;
747:

Line 921: , wsh_delivery_legs_ob_grp_v wdl

917: , nvl(wdd.load_seq_number,0) as load_seq_num
918: from wms_license_plate_numbers lpn
919: , wms_license_plate_numbers wlpn
920: , wsh_new_deliveries_ob_grp_v wnd
921: , wsh_delivery_legs_ob_grp_v wdl
922: , wsh_delivery_details_ob_grp_v wdd
923: , wsh_delivery_assignments_v wda
924: , wsh_delivery_details_ob_grp_v wdd2
925: where wdl.pick_up_stop_id = p_trip_stop_id

Line 1049: , wsh_delivery_legs_ob_grp_v wdl

1045: , wnd.delivery_id,wnd.name
1046: from wms_license_plate_numbers lpn
1047: , wms_license_plate_numbers wlpn
1048: , wsh_new_deliveries_ob_grp_v wnd
1049: , wsh_delivery_legs_ob_grp_v wdl
1050: , wsh_delivery_details_ob_grp_v wdd
1051: , wsh_delivery_assignments_v wda
1052: , wsh_delivery_details_ob_grp_v wdd2
1053: where wdl.pick_up_stop_id = p_trip_stop_id

Line 1454: from wsh_delivery_legs_ob_grp_v wdl, wsh_trip_stops_ob_grp_v wts

1450: BEGIN
1451: -- check the trip
1452: select wts.trip_id
1453: into l_trip_id
1454: from wsh_delivery_legs_ob_grp_v wdl, wsh_trip_stops_ob_grp_v wts
1455: where wdl.delivery_id = l_delivery_id
1456: and wdl.pick_up_stop_id = wts.stop_id;
1457:
1458: select 1

Line 1534: from wsh_delivery_legs_ob_grp_v wdl, wsh_trip_stops_ob_grp_v wts,wms_dock_appointments_b wda,

1530: -- First check if this delivery have trip which is scheduled
1531: BEGIN
1532: select wt.name, milk.concatenated_segments
1533: into x_trip_name, x_loaded_dock_door
1534: from wsh_delivery_legs_ob_grp_v wdl, wsh_trip_stops_ob_grp_v wts,wms_dock_appointments_b wda,
1535: mtl_item_locations_kfv milk, wsh_trips_ob_grp_v wt
1536: where wdl.delivery_id = l_delivery_id
1537: and wdl.pick_up_stop_id = wts.stop_id
1538: and wda.trip_stop = wts.stop_id

Line 1570: from wsh_delivery_legs_ob_grp_v wdl, wsh_trip_stops_ob_grp_v wts

1566: -- check the corresponding trip if any
1567: BEGIN
1568: select wts.trip_id
1569: into l_trip_id
1570: from wsh_delivery_legs_ob_grp_v wdl, wsh_trip_stops_ob_grp_v wts
1571: where wdl.delivery_id = l_delivery_id
1572: and wdl.pick_up_stop_id = wts.stop_id;
1573:
1574: OPEN lpn_in_other_dock2(l_trip_id);

Line 2693: FROM wsh_delivery_legs_ob_grp_v wdl,

2689: p_trip_id = 0 THEN
2690: begin
2691: SELECT wts.trip_id
2692: INTO l_trip_id
2693: FROM wsh_delivery_legs_ob_grp_v wdl,
2694: wsh_trip_stops_ob_grp_v wts
2695: WHERE wdl.delivery_id=p_delivery_id
2696: AND wdl.pick_up_stop_id=wts.stop_id
2697: AND ROWNUM=1;

Line 2864: FROM wsh_delivery_legs_ob_grp_v wdl,

2860: BEGIN
2861:
2862: SELECT wts.trip_id,wt.ship_method_code
2863: INTO l_trip_id,l_trip_ship_method_code
2864: FROM wsh_delivery_legs_ob_grp_v wdl,
2865: wsh_trip_stops_ob_grp_v wts,
2866: wsh_trips_ob_grp_v wt
2867: WHERE wdl.delivery_id=p_delivery_id
2868: AND wdl.pick_up_stop_id=wts.stop_id

Line 2966: wsh_delivery_legs_ob_grp_v wdl,wsh_delivery_assignments_v wda,wsh_delivery_details_ob_grp_v wdd,

2962: lpn.subinventory_code,
2963: milk.concatenated_segments,
2964: wnd.name
2965: from wms_license_plate_numbers lpn, mtl_item_locations_kfv milk,wsh_trip_stops_ob_grp_v pickup_stop,
2966: wsh_delivery_legs_ob_grp_v wdl,wsh_delivery_assignments_v wda,wsh_delivery_details_ob_grp_v wdd,
2967: wsh_delivery_details_ob_grp_v wdd2,wsh_new_deliveries_ob_grp_v wnd,wms_license_plate_numbers wlpn
2968: where wdd.delivery_detail_id = wda.delivery_detail_id
2969: and wdd.released_status = 'Y'
2970: and wdd2.delivery_detail_id = wda.parent_delivery_detail_id

Line 3002: from wsh_delivery_legs_ob_grp_v wdl,wms_shipping_transaction_temp wstt,

2998: and dock_door_id = p_dock_door_id
2999: and delivery_id is not null
3000: UNION
3001: select distinct wdl.delivery_id
3002: from wsh_delivery_legs_ob_grp_v wdl,wms_shipping_transaction_temp wstt,
3003: wsh_trip_stops_ob_grp_v wts
3004: where wdl.pick_up_stop_id = wts.stop_id
3005: and wts.trip_id = wstt.trip_id
3006: and wstt.dock_door_id = p_dock_door_id

Line 3047: ,wsh_delivery_legs_ob_grp_v wdl

3043: BEGIN
3044: select count(distinct lpn.outermost_lpn_id)
3045: into l_count
3046: from wsh_trip_stops_ob_grp_v pickup_stop
3047: ,wsh_delivery_legs_ob_grp_v wdl
3048: ,wsh_delivery_assignments_v wda
3049: ,wsh_delivery_details_ob_grp_v wdd
3050: ,wsh_delivery_details_ob_grp_v wdd2
3051: ,wms_license_plate_numbers lpn

Line 3089: , wsh_delivery_legs_ob_grp_v wdl

3085: , wnd.name
3086: from wms_license_plate_numbers lpn
3087: , mtl_item_locations_kfv milk
3088: , wsh_trip_stops_ob_grp_v pickup_stop
3089: , wsh_delivery_legs_ob_grp_v wdl
3090: , wsh_delivery_assignments_v wda
3091: , wsh_delivery_details_ob_grp_v wdd
3092: , wsh_delivery_details_ob_grp_v wdd2
3093: , wsh_new_deliveries_ob_grp_v wnd

Line 3134: from wsh_delivery_legs_ob_grp_v wdl

3130: and dock_door_id = p_dock_door_id
3131: and delivery_id is not null
3132: UNION
3133: select distinct wdl.delivery_id
3134: from wsh_delivery_legs_ob_grp_v wdl
3135: ,wms_shipping_transaction_temp wstt
3136: ,wsh_trip_stops_ob_grp_v wts
3137: where wdl.pick_up_stop_id = wts.stop_id
3138: and wts.trip_id = wstt.trip_id

Line 3189: from wsh_delivery_legs_ob_grp_v wdl

3185: and dock_door_id = p_dock_door_id
3186: and delivery_id is not null
3187: UNION
3188: select distinct wdl.delivery_id
3189: from wsh_delivery_legs_ob_grp_v wdl
3190: ,wms_shipping_transaction_temp wstt
3191: ,wsh_trip_stops_ob_grp_v wts
3192: where wdl.pick_up_stop_id = wts.stop_id
3193: and wts.trip_id = wstt.trip_id

Line 3242: , wsh_delivery_legs_ob_grp_v wdl

3238: select count(*)
3239: into l_count
3240: from wsh_delivery_details_ob_grp_v wdd
3241: , wsh_delivery_assignments_v wda
3242: , wsh_delivery_legs_ob_grp_v wdl
3243: , wsh_Trip_stops_ob_grp_v pickup_stop
3244: , mtl_system_items_kfv msik
3245: where
3246: wda.delivery_id = wdl.delivery_id

Line 3276: , wsh_delivery_legs_ob_grp_v wdl

3272: , msik.description
3273: from wsh_delivery_details_ob_grp_v wdd
3274: , wsh_delivery_assignments_v wda
3275: , wsh_new_deliveries_ob_grp_v wnd
3276: , wsh_delivery_legs_ob_grp_v wdl
3277: , wsh_trip_Stops_ob_grp_v pickup_stop
3278: , mtl_system_items_kfv msik
3279: where wnd.delivery_id = wda.delivery_id
3280: AND wda.delivery_id = wdl.delivery_id

Line 3310: from wsh_delivery_legs_ob_grp_v wdl

3306: and nvl(direct_ship_flag,'N') = 'N'
3307: and delivery_id is not null
3308: UNION
3309: select distinct wdl.delivery_id
3310: from wsh_delivery_legs_ob_grp_v wdl
3311: ,wms_shipping_transaction_temp wstt
3312: ,wsh_trip_stops_ob_grp_v wts
3313: where wdl.pick_up_stop_id = wts.stop_id
3314: and wts.trip_id = wstt.trip_id

Line 3360: from wsh_delivery_legs_ob_grp_v wdl

3356: and nvl(direct_ship_flag,'N') = 'N'
3357: and delivery_id is not null
3358: UNION
3359: select distinct wdl.delivery_id
3360: from wsh_delivery_legs_ob_grp_v wdl
3361: ,wms_shipping_transaction_temp wstt
3362: ,wsh_trip_stops_ob_grp_v wts
3363: where wdl.pick_up_stop_id = wts.stop_id
3364: and wts.trip_id = wstt.trip_id

Line 3920: from wsh_delivery_legs_ob_grp_v wdl,wms_shipping_transaction_temp wstt,

3916: AND wstt.delivery_id = wnd.delivery_id;
3917:
3918: cursor pick_up_stops is
3919: select distinct wdl.pick_up_stop_id,wts.stop_sequence_number
3920: from wsh_delivery_legs_ob_grp_v wdl,wms_shipping_transaction_temp wstt,
3921: wsh_trip_stops_ob_grp_v wts
3922: where wdl.pick_up_stop_id = wts.stop_id
3923: and wts.trip_id = wstt.trip_id
3924: and wstt.dock_door_id = p_dock_door_id

Line 3933: from wsh_delivery_legs wdl,wms_shipping_transaction_temp wstt,

3929: ORDER BY wts.stop_sequence_number asc;
3930:
3931: cursor drop_off_stops(p_dock_appoint_flag varchar2) is
3932: select distinct wdl.drop_off_stop_id
3933: from wsh_delivery_legs wdl,wms_shipping_transaction_temp wstt,
3934: wsh_trip_stops wts
3935: where wdl.drop_off_stop_id = wts.stop_id
3936: and wts.trip_id = wstt.trip_id
3937: and wstt.dock_door_id = p_dock_door_id

Line 3946: FROM wsh_delivery_legs_ob_grp_v wdl,

3942:
3943: CURSOR c_get_trip_ship_method(l_delivery_id NUMBER)IS
3944: SELECT wts.trip_id,
3945: wt.ship_method_code
3946: FROM wsh_delivery_legs_ob_grp_v wdl,
3947: wsh_trip_stops_ob_grp_v wts,
3948: wsh_trips_ob_grp_v wt
3949: WHERE wdl.delivery_id = l_delivery_id
3950: AND wdl.pick_up_stop_id = wts.stop_id

Line 4598: FROM wsh_trip_stops wts, wsh_delivery_legs wdl

4594: END IF;
4595:
4596: SELECT COUNT(DISTINCT wdl.pick_up_stop_id)
4597: INTO l_pick_up_count
4598: FROM wsh_trip_stops wts, wsh_delivery_legs wdl
4599: where wts.stop_id = wdl.pick_up_stop_id
4600: and wts.trip_id = p_trip_id;
4601:
4602: debug('l_pick_up_count: ' || l_pick_up_count,'LPN_SHIP');

Line 5589: wsh_delivery_legs_ob_grp_v wdl,

5585: INTO l_count
5586: FROM wsh_delivery_details_ob_grp_v wdd,
5587: wsh_delivery_assignments_v wda,
5588: wsh_new_deliveries_ob_grp_v wnd,
5589: wsh_delivery_legs_ob_grp_v wdl,
5590: wsh_trip_Stops_ob_grp_v pickup_stop,
5591: mtl_system_items_kfv msik
5592: WHERE wnd.delivery_id = wda.delivery_id
5593: AND wda.delivery_id = wdl.delivery_id

Line 5622: wsh_delivery_legs_ob_grp_v wdl,

5618: msik.description
5619: FROM wsh_delivery_details_ob_grp_v wdd,
5620: wsh_delivery_assignments_v wda,
5621: wsh_new_deliveries_ob_grp_v wnd,
5622: wsh_delivery_legs_ob_grp_v wdl,
5623: wsh_trip_stops_ob_grp_v pickup_stop,
5624: mtl_system_items_kfv msik
5625: WHERE wnd.delivery_id = wda.delivery_id
5626: AND wda.delivery_id = wdl.delivery_id

Line 5653: from wsh_delivery_legs_ob_grp_v wdl,

5649: AND dock_appoint_flag = 'N'
5650: AND delivery_id IS NOT NULL
5651: UNION
5652: SELECT DISTINCT wdl.delivery_id
5653: from wsh_delivery_legs_ob_grp_v wdl,
5654: wms_shipping_transaction_temp wstt,
5655: wsh_trip_stops_ob_grp_v wts
5656: WHERE wdl.pick_up_stop_id = wts.stop_id
5657: AND wts.trip_id = wstt.trip_id

Line 5699: FROM wsh_delivery_legs_ob_grp_v wdl,

5695: AND nvl(direct_ship_flag,'N') = 'N'
5696: AND delivery_id IS NOT NULL
5697: UNION
5698: SELECT DISTINCT wdl.delivery_id
5699: FROM wsh_delivery_legs_ob_grp_v wdl,
5700: wms_shipping_transaction_temp wstt,
5701: wsh_trip_stops_ob_grp_v wts
5702: WHERE wdl.pick_up_stop_id = wts.stop_id
5703: AND wts.trip_id = wstt.trip_id