APPS.POS_ASN_CREATE_PVT dependencies on MTL_SERIAL_NUMBERS

Line 595: l_to_serial_number mtl_serial_numbers_interface.to_serial_number%type;

591: l_val_mode number;
592: l_org_id number;
593: l_item_id number;
594: l_revision number;
595: l_to_serial_number mtl_serial_numbers_interface.to_serial_number%type;
596: BEGIN
597: l_to_serial_number := p_to_serial_number;
598:
599: select

Line 1408: from mtl_serial_numbers_interface msni,

1404: IF (p_processing_stage = 'I') THEN
1405: /*only for I*/
1406: select count(*)
1407: into l_rows
1408: from mtl_serial_numbers_interface msni,
1409: rcv_transactions_interface rti
1410: where rti.INTERFACE_TRANSACTION_ID = msni.PRODUCT_TRANSACTION_ID
1411: and msni.PRODUCT_CODE = 'RCV'
1412: and rti.INTERFACE_TRANSACTION_ID = p_asn_line_id

Line 1433: mtl_serial_numbers msn

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
1437: and rss.SERIAL_NUM = msn.SERIAL_NUMBER