APPS.WMS_SHIPPING_TRANSACTION_PUB dependencies on WMS_DOCK_APPOINTMENTS_B

Line 118: FROM wms_dock_appointments_b wda, mtl_item_locations_kfv milk,

114: --Bug#6018835.Added following cursor.
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 (+)

Line 139: FROM wms_dock_appointments_b wda, mtl_item_locations_kfv milk,

135: --Bug#6018835.Added following cursor.
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 (+)

Line 185: from wms_dock_appointments_b wda

181: , milk1.subinventory_code
182: , milk1.concatenated_segments
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

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 532: from wms_dock_appointments_b wda

528: BEGIN
529: if( p_txn_dock = 'Y' ) then
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

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