DBA Data[Home] [Help]

APPS.INV_INV_LOVS dependencies on RCV_LOTS_SUPPLY

Line 251: FROM mtl_lot_numbers mln, rcv_lots_supply rls,

247: SELECT rls.lot_num lot_number
248: , mln.description
249: , mln.expiration_date
250: , mmst.status_code
251: FROM mtl_lot_numbers mln, rcv_lots_supply rls,
252: rcv_shipment_lines rsl, mtl_material_statuses_tl mmst
253: WHERE rls.shipment_line_id = rsl.shipment_line_id
254: AND rsl.shipment_header_id = p_source_header_id
255: AND rsl.to_organization_id = p_organization_id

Line 312: FROM mtl_lot_numbers mlnv, rcv_lots_supply rls,

308: SELECT rls.lot_num lot_number
309: , mlnv.description
310: , mlnv.expiration_date
311: , mmst.status_code
312: FROM mtl_lot_numbers mlnv, rcv_lots_supply rls,
313: rcv_shipment_lines rsl, mtl_material_statuses_tl mmst
314: WHERE rls.shipment_line_id = rsl.shipment_line_id
315: AND rsl.shipment_header_id = p_shipment_header_id
316: AND rsl.to_organization_id = p_organization_id