DBA Data[Home] [Help]

APPS.INV_INV_LOVS dependencies on RCV_SHIPMENT_HEADERS

Line 230: rcv_shipment_headers rsh, mtl_material_statuses_tl mmst

226: , mln.description
227: , mln.expiration_date
228: , mmst.status_code
229: FROM mtl_lot_numbers mln, wms_asn_details wad,
230: rcv_shipment_headers rsh, mtl_material_statuses_tl mmst
231: WHERE mln.organization_id = p_organization_id
232: AND mln.inventory_item_id = p_item_id
233: AND mln.lot_number LIKE (p_lot_number)
234: AND mln.lot_number = wad.lot_number_expected