DBA Data[Home] [Help]

APPS.INV_INV_LOVS dependencies on RCV_LOTS_SUPPLY

Line 272: FROM mtl_lot_numbers mln, rcv_lots_supply rls,

268: SELECT rls.lot_num lot_number
269: , mln.description
270: , mln.expiration_date
271: , mmst.status_code
272: FROM mtl_lot_numbers mln, rcv_lots_supply rls,
273: rcv_shipment_lines rsl, mtl_material_statuses_tl mmst
274: WHERE rls.shipment_line_id = rsl.shipment_line_id
275: AND rsl.shipment_header_id = p_source_header_id
276: AND rsl.to_organization_id = p_organization_id

Line 333: FROM mtl_lot_numbers mlnv, rcv_lots_supply rls,

329: SELECT rls.lot_num lot_number
330: , mlnv.description
331: , mlnv.expiration_date
332: , mmst.status_code
333: FROM mtl_lot_numbers mlnv, rcv_lots_supply rls,
334: rcv_shipment_lines rsl, mtl_material_statuses_tl mmst
335: WHERE rls.shipment_line_id = rsl.shipment_line_id
336: AND rsl.shipment_header_id = p_shipment_header_id
337: AND rsl.to_organization_id = p_organization_id