APPS.POS_ASN_CREATE_PVT dependencies on MTL_SERIAL_NUMBERS_INTERFACE

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