DBA Data[Home] [Help]

APPS.POS_ASN_CREATE_PVT dependencies on MTL_LOT_NUMBERS

Line 1389: from rcv_shipment_lines rsl, rcv_lots_supply rcvls, mtl_lot_numbers mln

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