DBA Data[Home] [Help]

APPS.INV_RESERVATION_PVT dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 16700: wsh_delivery_assignments wda,

16696: , wdd.requested_quantity_uom
16697: , wdd.delivery_detail_id
16698: , wdd2.lpn_id
16699: FROM wsh_delivery_details wdd,
16700: wsh_delivery_assignments wda,
16701: wsh_delivery_details wdd2
16702: WHERE wdd.container_flag = 'N' --bug4639858 Only want wdd lines that represent items
16703: AND wdd.delivery_detail_id = wda.delivery_detail_id
16704: AND wda.parent_delivery_detail_id = wdd2.delivery_detail_id

Line 16727: FROM wsh_delivery_assignments wda,

16723: AND NVL(revision, '@@@@') = NVL(p_revision, '@@@@')
16724: AND NVL(lot_number, '@@@@') = NVL(p_lot, '@@@@')
16725: AND delivery_detail_id IN
16726: (SELECT wda.delivery_detail_id
16727: FROM wsh_delivery_assignments wda,
16728: wsh_delivery_details wdd2,
16729: wms_license_plate_numbers wlpn
16730: WHERE wda.parent_delivery_detail_id = wdd2.delivery_detail_id
16731: AND wdd2.lpn_id = wlpn.lpn_id