APPS.POS_ASN_CREATE_PVT dependencies on MTL_LOT_NUMBERS
Line 1388: from rcv_shipment_lines rsl, rcv_lots_supply rcvls, mtl_lot_numbers mln
1384: and mtln.LOT_NUMBER is not null;
1385:
1386: select count(*)
1387: into l_temp 1388: from rcv_shipment_lines rsl, rcv_lots_supply rcvls, mtl_lot_numbers mln 1389: where rsl.SHIPMENT_LINE_ID= rcvls.SHIPMENT_LINE_ID
1390: and rsl.to_organization_id = mln.ORGANIZATION_ID
1391: and rsl.ITEM_ID = mln.INVENTORY_ITEM_ID
1392: and rcvls.LOT_NUM = mln.LOT_NUMBER