APPS.WSH_IB_UI_RECON_GRP dependencies on WSH_NEW_DELIVERIES

Line 33: wsh_new_deliveries wnd

29: select distinct wt.trip_id
30: from wsh_trips wt,
31: wsh_trip_stops wts,
32: wsh_delivery_legs wdl,
33: wsh_new_deliveries wnd
34: where wnd.RCV_SHIPMENT_HEADER_ID = p_shpmt_header_id
35: and wnd.delivery_id = wdl.delivery_id
36: and wdl.pick_up_stop_id = wts.stop_id
37: and wts.trip_id = wt.trip_id;

Line 249: update wsh_new_deliveries

245:
246: IF (p_delivery_id_tab.count > 0 ) THEN
247: --{
248: FOR i in p_delivery_id_tab.FIRST..p_delivery_id_tab.LAST LOOP
249: update wsh_new_deliveries
250: set rcv_shipment_header_id = NULL,
251: status_code = p_status_code_tab(i)
252: where delivery_id = p_delivery_id_tab(i)
253: RETURNING organization_id into l_organization_id ; --Added for Pick To POD WF

Line 478: -- rcv_shipment_header_id from wsh_new_deliveries.

474: and wth1.transaction_type = 'ASN'
475: and wth2.parent_shipment_header_id = wth1.shipment_header_id;
476:
477: -- This is used to obtain all the delivery details based on the
478: -- rcv_shipment_header_id from wsh_new_deliveries.
479: -- These will be the delivery details that we need to revert.
480: cursor l_del_details_csr(p_shipment_header_id NUMBER) is
481: select wdd.source_line_id,
482: wdd.po_shipment_line_id,

Line 495: wsh_new_deliveries wnd

491: wdd.picked_quantity,
492: wdd.shipped_quantity
493: from wsh_delivery_details wdd,
494: wsh_delivery_assignments_v wda,
495: wsh_new_deliveries wnd
496: where wnd.rcv_shipment_header_id = p_shipment_header_id
497: and wnd.delivery_id = wda.delivery_id
498: and wda.delivery_detail_id = wdd.delivery_detail_id
499: and wdd.source_code = 'PO'

Line 548: wsh_new_deliveries wnd

544: select wdd.po_shipment_line_id,
545: wdd.delivery_detail_id
546: from wsh_delivery_details wdd,
547: wsh_delivery_assignments_v wda,
548: wsh_new_deliveries wnd
549: where wnd.rcv_shipment_header_id = p_shipment_header_id
550: and wnd.delivery_id = wda.delivery_id
551: and wda.delivery_detail_id = wdd.delivery_detail_id
552: and wdd.source_code = 'PO';

Line 998: wsh_new_deliveries wnd

994: last_updated_by = fnd_global.user_id,
995: last_update_login = fnd_global.user_id
996: where delivery_detail_id in (select wda.delivery_detail_id
997: from wsh_delivery_assignments_v wda,
998: wsh_new_deliveries wnd
999: where wnd.rcv_shipment_header_id = p_shipment_header_id
1000: and wda.delivery_id = wnd.delivery_id)
1001: and container_flag = 'Y'
1002: returning delivery_detail_id