DBA Data[Home] [Help]

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