DBA Data[Home] [Help]

APPS.INV_RESERVATION_PVT dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 17867: wsh_delivery_assignments wda,

17863: , wdd.requested_quantity_uom
17864: , wdd.delivery_detail_id
17865: , wdd2.lpn_id
17866: FROM wsh_delivery_details wdd,
17867: wsh_delivery_assignments wda,
17868: wsh_delivery_details wdd2
17869: WHERE wdd.container_flag = 'N' --bug4639858 Only want wdd lines that represent items
17870: AND wdd.delivery_detail_id = wda.delivery_detail_id
17871: AND wda.parent_delivery_detail_id = wdd2.delivery_detail_id

Line 17894: FROM wsh_delivery_assignments wda,

17890: AND NVL(revision, '@@@@') = NVL(p_revision, '@@@@')
17891: AND NVL(lot_number, '@@@@') = NVL(p_lot, '@@@@')
17892: AND delivery_detail_id IN
17893: (SELECT wda.delivery_detail_id
17894: FROM wsh_delivery_assignments wda,
17895: wsh_delivery_details wdd2,
17896: wms_license_plate_numbers wlpn
17897: WHERE wda.parent_delivery_detail_id = wdd2.delivery_detail_id
17898: AND wdd2.lpn_id = wlpn.lpn_id