APPS.INV_RCV_STD_RCPT_APIS dependencies on MTL_SERIAL_NUMBERS_INTERFACE

Line 2831: FROM mtl_serial_numbers_interface

2827: */
2828: --9651496,9764650-starts
2829: BEGIN
2830: SELECT fm_serial_number INTO l_serial_number
2831: FROM mtl_serial_numbers_interface
2832: WHERE product_transaction_id = p_original_rti_id ;
2833: EXCEPTION
2834: WHEN No_Data_Found THEN
2835: IF (l_debug = 1) THEN

Line 3172: FROM mtl_serial_numbers_interface

3168: BEGIN
3169: IF (l_rcv_rcpt_rec.serial_number_control_code = 6) THEN
3170: SELECT count(1)
3171: INTO l_msni_count
3172: FROM mtl_serial_numbers_interface
3173: WHERE product_transaction_id = p_original_rti_id
3174: AND product_code = 'RCV';
3175: END IF;
3176:

Line 4917: FROM mtl_serial_numbers_interface

4913: BEGIN
4914: IF (l_rcv_rcpt_rec.serial_number_control_code = 6) THEN
4915: SELECT count(1)
4916: INTO l_msni_count
4917: FROM mtl_serial_numbers_interface
4918: WHERE product_transaction_id = p_original_rti_id
4919: AND product_code = 'RCV';
4920: END IF;
4921:

Line 5625: from mtl_serial_numbers_interface msni, rcv_transactions_interface rti,

5621: END IF;
5622:
5623: select count(1) into
5624: l_msni_count
5625: from mtl_serial_numbers_interface msni, rcv_transactions_interface rti,
5626: wms_license_plate_numbers lpn, rcv_shipment_headers rsh,
5627: mtl_serial_numbers msn -- Bug 16517269
5628: where rti.interface_transaction_id = msni.product_transaction_id
5629: and rsh.shipment_header_id = p_shipment_header_id