APPS.POS_ASN_CREATE_PVT dependencies on RCV_SERIALS_SUPPLY
Line 1433: from rcv_serials_supply rss, rcv_shipment_lines rsl,
1429: and mut.SERIAL_NUMBER is not null;
1430:
1431: select count(*)
1432: into l_temp 1433: from rcv_serials_supply rss, rcv_shipment_lines rsl, 1434: mtl_serial_numbers msn
1435: where rsl.SHIPMENT_LINE_ID = rss.SHIPMENT_LINE_ID
1436: and rsl.to_organization_id = msn.CURRENT_ORGANIZATION_ID
1437: and rsl.ITEM_ID = msn.INVENTORY_ITEM_ID