DBA Data[Home] [Help]

APPS.POS_ASN_CREATE_PVT dependencies on RCV_SERIALS_SUPPLY

Line 1432: from rcv_serials_supply rss, rcv_shipment_lines rsl,

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