APPS.INV_INV_LOVS dependencies on RCV_SHIPMENT_LINES

Line 273: rcv_shipment_lines rsl, mtl_material_statuses_tl mmst

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
277: AND rsl.item_id = p_item_id

Line 314: FROM mtl_system_items_kfv msik, rcv_shipment_lines rsl

310: BEGIN
311: BEGIN
312: SELECT msik.lot_control_code
313: INTO l_lot_control_code
314: FROM mtl_system_items_kfv msik, rcv_shipment_lines rsl
315: WHERE msik.inventory_item_id = p_item_id
316: AND msik.inventory_item_id = rsl.item_id --Bug 4235750
317: AND rsl.shipment_header_id = p_shipment_header_id
318: AND rsl.to_organization_id = p_organization_id

Line 334: rcv_shipment_lines rsl, mtl_material_statuses_tl mmst

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
338: AND rsl.item_id = p_item_id

Line 2274: FROM mtl_system_items_kfv msik, rcv_shipment_lines rsl

2270: SELECT msik.lot_control_code
2271: , rsl.from_organization_id
2272: INTO x_lot_control_code
2273: , x_from_org_id
2274: FROM mtl_system_items_kfv msik, rcv_shipment_lines rsl
2275: WHERE msik.inventory_item_id = p_item_id
2276: AND rsl.shipment_header_id = p_shipment_header_id
2277: AND rsl.to_organization_id = p_organization_id
2278: AND rsl.from_organization_id = msik.organization_id