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_TRIP_STOPS

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 188: , wsh_Trip_stops_ob_grp_v wts

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 (+)
192: and wda.organization_id = milk.organization_id (+)

Line 225: wsh_Trip_stops_ob_grp_v wts, mtl_item_locations_kfv milk1,wsh_trips wt

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 (+)
229: and wdl.pick_up_stop_id = wts.stop_id (+)

Line 254: wsh_Trip_stops_ob_grp_v wts, mtl_item_locations_kfv milk1,wsh_trips wt

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 (+)
258: and wdl.pick_up_stop_id = wts.stop_id (+)

Line 488: , wsh_trip_stops_ob_grp_v pickup_stop

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
492: and pickup_stop.trip_id = dropoff_stop.trip_id

Line 489: , wsh_trip_stops_ob_grp_v dropoff_stop

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
492: and pickup_stop.trip_id = dropoff_stop.trip_id
493: and pickup_stop.trip_id = p_trip_id;

Line 534: , wsh_trip_Stops_ob_grp_v pickup_stop

530: open x_staging_lane_lov for
531: select distinct wda.staging_lane_id, milk.concatenated_segments
532: from wms_dock_appointments_b wda
533: , mtl_item_locations_kfv milk
534: , wsh_trip_Stops_ob_grp_v pickup_stop
535: where milk.inventory_location_id(+) = wda.staging_lane_id
536: and milk.organization_id(+) = wda.organization_id
537: and milk.organization_id = p_organization_id
538: and milk.subinventory_code = p_sub_code

Line 567: , wsh_trip_stops_ob_grp_v pickup_stop

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
571: and wdl.pick_up_stop_id = pickup_stop.stop_id

Line 568: , wsh_trip_stops_ob_grp_v dropoff_stop

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
571: and wdl.pick_up_stop_id = pickup_stop.stop_id
572: and wdl.drop_off_Stop_id = dropoff_stop.stop_id

Line 744: , wsh_trip_stops_ob_grp_v wts

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:
748: EXCEPTION

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 2694: wsh_trip_stops_ob_grp_v wts

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;
2698: EXCEPTION

Line 2865: wsh_trip_stops_ob_grp_v wts,

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
2869: AND wt.trip_id=wts.trip_id

Line 2965: from wms_license_plate_numbers lpn, mtl_item_locations_kfv milk,wsh_trip_stops_ob_grp_v pickup_stop,

2961: select DISTINCT wlpn.license_plate_number,
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'

Line 3003: wsh_trip_stops_ob_grp_v wts

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
3007: and wstt.organization_id = p_organization_id

Line 3046: from wsh_trip_stops_ob_grp_v pickup_stop

3042: if (p_trip_id <> 0) then
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

Line 3088: , wsh_trip_stops_ob_grp_v pickup_stop

3084: , milk.concatenated_segments
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

Line 3136: ,wsh_trip_stops_ob_grp_v wts

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
3139: and wstt.dock_door_id = p_dock_door_id
3140: and wstt.organization_id = p_organization_id

Line 3191: ,wsh_trip_stops_ob_grp_v wts

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
3194: and wstt.dock_door_id = p_dock_door_id
3195: and wstt.organization_id = p_organization_id

Line 3243: , wsh_Trip_stops_ob_grp_v pickup_stop

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
3247: AND wda.delivery_detail_id = wdd.delivery_detail_id

Line 3277: , wsh_trip_Stops_ob_grp_v pickup_stop

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
3281: AND wda.delivery_detail_id = wdd.delivery_detail_id

Line 3312: ,wsh_trip_stops_ob_grp_v wts

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
3315: and wstt.dock_door_id = p_dock_door_id
3316: and wstt.organization_id = p_organization_id

Line 3362: ,wsh_trip_stops_ob_grp_v wts

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
3365: and wstt.dock_door_id = p_dock_door_id
3366: and wstt.organization_id = p_organization_id

Line 3921: wsh_trip_stops_ob_grp_v wts

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
3925: and wstt.organization_id = p_organization_id

Line 3934: wsh_trip_stops wts

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
3938: and wstt.organization_id = p_organization_id

Line 3947: wsh_trip_stops_ob_grp_v wts,

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
3951: AND wt.trip_id = wts.trip_id

Line 4484: debug('Calling wsh_trip_stops_pub.stop_action','LPN_SHIP');

4480: IF (p_close_trip_flag = 'Y' OR (l_intransit_flag = 'Y' AND l_open_delivery_id IS NULL))
4481: AND (l_stop_rows.COUNT >= 1) THEN
4482: FOR i IN 1..l_stop_rows.COUNT LOOP
4483: IF l_debug = 1 THEN
4484: debug('Calling wsh_trip_stops_pub.stop_action','LPN_SHIP');
4485: debug('l_stop_rows(i) ' || l_stop_rows(i),'LPN_SHIP');
4486: END IF;
4487:
4488: --patchset J. Shipping API cleanup

Line 4489: wsh_trip_stops_pub.stop_action

4485: debug('l_stop_rows(i) ' || l_stop_rows(i),'LPN_SHIP');
4486: END IF;
4487:
4488: --patchset J. Shipping API cleanup
4489: wsh_trip_stops_pub.stop_action
4490: (p_api_version_number => 1.0,
4491: p_init_msg_list => G_TRUE,
4492: x_return_status => l_return_status,
4493: x_msg_count => l_msg_count,

Line 4528: wsh_trip_stops_pub.stop_action

4524: debug('Calling change status for the drop-off stops','LPN_SHIP');
4525: END IF;
4526:
4527: FOR i IN 1..l_drop_off_stops.COUNT LOOP
4528: wsh_trip_stops_pub.stop_action
4529: (p_api_version_number => 1.0,
4530: p_init_msg_list => G_TRUE,
4531: x_return_status => l_return_status,
4532: x_msg_count => l_msg_count,

Line 4539: debug('wsh_trip_stops_actions.change_status return status: ' || l_return_status,'LPN_SHIP');

4535: p_stop_id => l_drop_off_stops(i),
4536: p_actual_date => sysdate,
4537: p_defer_interface_flag => 'Y');
4538: IF l_debug = 1 THEN
4539: debug('wsh_trip_stops_actions.change_status return status: ' || l_return_status,'LPN_SHIP');
4540: END IF;
4541:
4542: IF l_return_status NOT IN ('S','W') THEN
4543: IF l_debug = 1 THEN

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 4699: wsh_trip_stops_pub.stop_action

4695:
4696: l_stop_rows(1) := p_trip_stop_id;
4697: --patchset J. Shipping API cleanup
4698: IF p_close_trip_flag = 'Y' OR l_intransit_flag = 'Y' THEN
4699: wsh_trip_stops_pub.stop_action
4700: (p_api_version_number => 1.0,
4701: p_init_msg_list => G_TRUE,
4702: x_return_status => l_return_status,
4703: x_msg_count => l_msg_count,

Line 4732: wsh_trip_stops_pub.stop_action

4728: debug('Call Shipping to close drop-off stops','LPN_SHIP');
4729: END IF;
4730:
4731: FOR i IN 1..l_drop_off_stops.COUNT LOOP
4732: wsh_trip_stops_pub.stop_action
4733: (p_api_version_number => 1.0,
4734: p_init_msg_list => G_TRUE,
4735: x_return_status => l_return_status,
4736: x_msg_count => l_msg_count,

Line 4744: debug('wsh_trip_stops_actions.change_status return status: ' || l_return_status,'LPN_SHIP');

4740: p_actual_date => sysdate,
4741: p_defer_interface_flag =>'Y');
4742:
4743: IF l_debug = 1 THEN
4744: debug('wsh_trip_stops_actions.change_status return status: ' || l_return_status,'LPN_SHIP');
4745: END IF;
4746: IF l_return_status NOT IN ('S','W') THEN
4747: IF l_debug = 1 THEN
4748: debug('Could not close the drop-off stops. Let the transaction go through','LPN_SHIP');

Line 5590: wsh_trip_Stops_ob_grp_v pickup_stop,

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
5594: AND wda.delivery_detail_id = wdd.delivery_detail_id

Line 5623: wsh_trip_stops_ob_grp_v pickup_stop,

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
5627: AND wda.delivery_detail_id = wdd.delivery_detail_id

Line 5655: wsh_trip_stops_ob_grp_v wts

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
5658: AND wstt.dock_door_id = p_dock_door_id
5659: AND wstt.organization_id = p_organization_id

Line 5701: wsh_trip_stops_ob_grp_v wts

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
5704: AND wstt.dock_door_id = p_dock_door_id
5705: AND wstt.organization_id = p_organization_id