DBA Data[Home] [Help]

APPS.WSH_ROUTING_REQUEST dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 4018: wsh_delivery_assignments_v wda

4014: -- Select released_status and associated delivery for unplaning and un assigning.
4015: CURSOR unassign_del_csr IS
4016: SELECT wdd.delivery_detail_id,wdd.released_status,wda.delivery_id
4017: FROM wsh_delivery_details wdd,
4018: wsh_delivery_assignments_v wda
4019: WHERE routing_req_id = p_routing_req_id
4020: AND wdd.delivery_detail_id = wda.delivery_detail_id
4021: ORDER BY wda.delivery_id;
4022:

Line 4205: wsh_delivery_assignments_v wda

4201: wdd.po_shipment_line_number,
4202: wdd.source_blanket_reference_num,
4203: wda.delivery_id
4204: FROM wsh_delivery_details wdd,
4205: wsh_delivery_assignments_v wda
4206: WHERE wdd.delivery_detail_id = p_detail_id
4207: AND wdd.delivery_detail_id = wda.delivery_detail_id;
4208:
4209: l_del_info get_del_info%ROWTYPE;