APPS.INV_INV_LOVS dependencies on RCV_SHIPMENT_LINES

Line 252: rcv_shipment_lines rsl, mtl_material_statuses_tl mmst

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

Line 293: FROM mtl_system_items_kfv msik, rcv_shipment_lines rsl

289: BEGIN
290: BEGIN
291: SELECT msik.lot_control_code
292: INTO l_lot_control_code
293: FROM mtl_system_items_kfv msik, rcv_shipment_lines rsl
294: WHERE msik.inventory_item_id = p_item_id
295: AND msik.inventory_item_id = rsl.item_id --Bug 4235750
296: AND rsl.shipment_header_id = p_shipment_header_id
297: AND rsl.to_organization_id = p_organization_id

Line 313: rcv_shipment_lines rsl, mtl_material_statuses_tl mmst

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

Line 2244: FROM mtl_system_items_kfv msik, rcv_shipment_lines rsl

2240: SELECT msik.lot_control_code
2241: , rsl.from_organization_id
2242: INTO x_lot_control_code
2243: , x_from_org_id
2244: FROM mtl_system_items_kfv msik, rcv_shipment_lines rsl
2245: WHERE msik.inventory_item_id = p_item_id
2246: AND rsl.shipment_header_id = p_shipment_header_id
2247: AND rsl.to_organization_id = p_organization_id
2248: AND rsl.from_organization_id = msik.organization_id