APPS.POS_ASN_CREATE_PVT dependencies on MTL_SERIAL_NUMBERS

Line 596: l_to_serial_number mtl_serial_numbers_interface.to_serial_number%type;

592: l_val_mode number;
593: l_org_id number;
594: l_item_id number;
595: l_revision po_lines_all.item_revision%type; /* Bug 9734095 */
596: l_to_serial_number mtl_serial_numbers_interface.to_serial_number%type;
597: BEGIN
598: l_to_serial_number := p_to_serial_number;
599:
600: select

Line 1409: from mtl_serial_numbers_interface msni,

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

Line 1434: mtl_serial_numbers msn

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