DBA Data[Home] [Help]

APPS.INV_RCV_DIR_RCPT_APIS dependencies on MTL_SERIAL_NUMBERS_INTERFACE

Line 2232: FROM mtl_serial_numbers_interface

2228: BEGIN
2229: IF (l_rcv_rcpt_rec.serial_number_control_code = 6) THEN
2230: SELECT count(1)
2231: INTO l_msni_count
2232: FROM mtl_serial_numbers_interface
2233: WHERE product_transaction_id = p_transaction_temp_id
2234: AND product_code = 'RCV';
2235: END IF;
2236: IF (l_msni_count = 0) THEN

Line 3806: FROM mtl_serial_numbers_interface

3802: BEGIN
3803: IF (l_rcv_rcpt_rec.serial_number_control_code = 6) THEN
3804: SELECT count(1)
3805: INTO l_msni_count
3806: FROM mtl_serial_numbers_interface
3807: WHERE product_transaction_id = p_transaction_temp_id
3808: AND product_code = 'RCV';
3809: END IF;
3810: