APPS.POS_ASN_CREATE_PVT dependencies on MTL_SERIAL_NUMBERS_INTERFACE

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