DBA Data[Home] [Help]

APPS.INV_INV_LOVS dependencies on RCV_SHIPMENT_HEADERS

Line 251: rcv_shipment_headers rsh, mtl_material_statuses_tl mmst

247: , mln.description
248: , mln.expiration_date
249: , mmst.status_code
250: FROM mtl_lot_numbers mln, wms_asn_details wad,
251: rcv_shipment_headers rsh, mtl_material_statuses_tl mmst
252: WHERE mln.organization_id = p_organization_id
253: AND mln.inventory_item_id = p_item_id
254: AND mln.lot_number LIKE (p_lot_number)
255: AND mln.lot_number = wad.lot_number_expected