APPS.WMS_SHIPPING_TRANSACTION_PUB dependencies on WMS_DOCK_APPOINTMENTS_B

Line 169: FROM wms_dock_appointments_b wda, mtl_item_locations_kfv milk,

165: --Bug#6018835.Added following cursor.
166: --cursor to check if any apptmts within the current time window.
167: CURSOR current_schedule_cur IS
168: SELECT 1
169: FROM wms_dock_appointments_b wda, mtl_item_locations_kfv milk,
170: wsh_delivery_legs_ob_grp_v wdl, wsh_Trip_stops_ob_grp_v wts, mtl_item_locations_kfv milk1,wsh_trips wt
171: WHERE wda.dock_id = milk.inventory_location_id (+)
172: and wda.organization_id = milk.organization_id (+)
173: and wda.trip_stop = wdl.pick_up_stop_id (+)

Line 190: FROM wms_dock_appointments_b wda, mtl_item_locations_kfv milk,

186: --Bug#6018835.Added following cursor.
187: --cursor to check if any apptmts missed to be used in the past.
188: CURSOR last_recent_schedule_cur IS
189: SELECT 1
190: FROM wms_dock_appointments_b wda, mtl_item_locations_kfv milk,
191: wsh_delivery_legs_ob_grp_v wdl,wsh_Trip_stops_ob_grp_v wts, mtl_item_locations_kfv milk1,wsh_trips wt
192: WHERE wda.dock_id = milk.inventory_location_id (+)
193: and wda.organization_id = milk.organization_id (+)
194: and wda.trip_stop = wdl.pick_up_stop_id (+)

Line 236: from wms_dock_appointments_b wda

232: , milk1.subinventory_code
233: , milk1.concatenated_segments
234: , is_loaded(p_organization_id,wda.dock_id,'Y')
235: , wt.name trip_name
236: from wms_dock_appointments_b wda
237: , mtl_item_locations_kfv milk
238: , wsh_delivery_legs_ob_grp_v wdl
239: , wsh_Trip_stops_ob_grp_v wts
240: , mtl_item_locations_kfv milk1

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

271: wda.dock_appointment_id, wda.organization_id, wda.trip_stop, wts.trip_id,
272: milk1.subinventory_code, milk1.concatenated_segments ,
273: WMS_SHIPPING_TRANSACTION_PUB.is_loaded(p_organization_id,wda.dock_id,'Y') is_loaded ,
274: wt.name trip_name , ( SYSDATE - wda.end_time ) last_schedule_time_diff
275: FROM wms_dock_appointments_b wda, mtl_item_locations_kfv milk, wsh_delivery_legs_ob_grp_v wdl,
276: wsh_Trip_stops_ob_grp_v wts, mtl_item_locations_kfv milk1,wsh_trips wt
277: WHERE wda.dock_id = milk.inventory_location_id (+)
278: and wda.organization_id = milk.organization_id (+)
279: and wda.trip_stop = wdl.pick_up_stop_id (+)

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

300: wda.dock_appointment_id, wda.organization_id, wda.trip_stop, wts.trip_id,
301: milk1.subinventory_code, milk1.concatenated_segments ,
302: WMS_SHIPPING_TRANSACTION_PUB.is_loaded(p_organization_id,wda.dock_id,'Y') is_loaded ,
303: wt.name trip_name , ( wda.start_time - SYSDATE) next_schedule_time_diff
304: FROM wms_dock_appointments_b wda, mtl_item_locations_kfv milk, wsh_delivery_legs_ob_grp_v wdl,
305: wsh_Trip_stops_ob_grp_v wts, mtl_item_locations_kfv milk1,wsh_trips wt
306: WHERE wda.dock_id = milk.inventory_location_id (+)
307: and wda.organization_id = milk.organization_id (+)
308: and wda.trip_stop = wdl.pick_up_stop_id (+)

Line 585: from wms_dock_appointments_b wda

581: BEGIN
582: if( p_txn_dock = 'Y' ) then
583: open x_staging_lane_lov for
584: select distinct wda.staging_lane_id, milk.concatenated_segments
585: from wms_dock_appointments_b wda
586: , mtl_item_locations_kfv milk
587: , wsh_trip_Stops_ob_grp_v pickup_stop
588: where milk.inventory_location_id(+) = wda.staging_lane_id
589: and milk.organization_id(+) = wda.organization_id

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

1588: -- First check if this delivery have trip which is scheduled
1589: BEGIN
1590: select wt.name, milk.concatenated_segments
1591: into x_trip_name, x_loaded_dock_door
1592: from wsh_delivery_legs_ob_grp_v wdl, wsh_trip_stops_ob_grp_v wts,wms_dock_appointments_b wda,
1593: mtl_item_locations_kfv milk, wsh_trips_ob_grp_v wt
1594: where wdl.delivery_id = l_delivery_id
1595: and wdl.pick_up_stop_id = wts.stop_id
1596: and wda.trip_stop = wts.stop_id