DBA Data[Home] [Help]

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