APPS.INV_RCV_STD_TRANSFER_APIS dependencies on MTL_SERIAL_NUMBERS

Line 689: FROM mtl_serial_numbers_interface

685: -- (For other docs, the value of l_msni_count would be 0).
686: IF (p_doc_type = 'INTSHIP') THEN
687: SELECT count(1)
688: INTO l_msni_count
689: FROM mtl_serial_numbers_interface
690: WHERE product_transaction_id = p_original_rti_id
691: AND product_code = 'RCV';
692: END IF;
693:

Line 721: UPDATE mtl_serial_numbers_interface

717: print_debug('Updated ' || SQL%ROWCOUNT || ' lot records', 4);
718: END IF;
719:
720: --For a lot and serial controlled item, update the MSNI records too
721: UPDATE mtl_serial_numbers_interface
722: SET product_transaction_id = l_interface_txn_id
723: WHERE product_code = 'RCV'
724: AND product_transaction_id = p_original_rti_id;
725:

Line 732: UPDATE mtl_serial_numbers_interface

728: END IF;
729:
730: ELSIF (p_serial_control_code > 1) THEN
731: --Update the serial interface records
732: UPDATE mtl_serial_numbers_interface
733: SET product_transaction_id = l_interface_txn_id
734: WHERE product_code = 'RCV'
735: AND product_transaction_id = p_original_rti_id;
736:

Line 2871: FROM mtl_serial_numbers

2867:
2868: --Get the serial status
2869: SELECT status_id
2870: INTO l_serial_status_id
2871: FROM mtl_serial_numbers
2872: WHERE serial_number = p_serial_number
2873: AND inventory_item_id = p_item_id;
2874:
2875: --Call the insert_msni API

Line 2966: mtl_serial_numbers_interface msni

2962: rcv_transactions rt,
2963: rcv_serials_supply rss,
2964: rcv_shipment_lines rsl,
2965: rcv_shipment_headers rsh,
2966: mtl_serial_numbers_interface msni
2967: WHERE rs.item_id = p_item_id
2968: AND Nvl(rs.item_revision,nvl(p_revision,'@@@')) = nvl(p_revision,'@@@')
2969: AND rs.to_organization_id = p_organization_id
2970: AND nvl(rs.lpn_id,-1) = nvl(p_lpn_id,-1)