DBA Data[Home] [Help]

APPS.WSH_ROUTING_RESPONSE_PKG dependencies on WSH_DELIVERY_DETAILS

Line 415: FROM wsh_delivery_details wdd, wsh_delivery_assignments_v wda

411: -- Get the routing request Ids associated with the delivery
412: --
413: CURSOR c_RoutReqId(p_delId IN NUMBER) IS
414: SELECT DISTINCT routing_req_id
415: FROM wsh_delivery_details wdd, wsh_delivery_assignments_v wda
416: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
417: AND wda.delivery_id = p_delId;
418: --
419: -- Given a routing request Id, get the routing request number

Line 1854: FROM wsh_delivery_details wdd,

1850: --Cursor to get PO attributes
1851: CURSOR get_del_detail IS
1852: SELECT source_header_id, source_line_id,
1853: po_shipment_line_id, source_blanket_reference_id
1854: FROM wsh_delivery_details wdd,
1855: wsh_delivery_assignments_v wda
1856: WHERE wda.delivery_id=p_delivery_id
1857: AND wdd.delivery_detail_id = wda.delivery_detail_id
1858: AND nvl(line_direction,'O') not in ('O','IO')