DBA Data[Home] [Help]

APPS.INV_RCV_DIR_RCPT_APIS dependencies on MTL_SERIAL_NUMBERS_INTERFACE

Line 2316: FROM mtl_serial_numbers_interface

2312: BEGIN
2313: IF (l_rcv_rcpt_rec.serial_number_control_code = 6) THEN
2314: SELECT count(1)
2315: INTO l_msni_count
2316: FROM mtl_serial_numbers_interface
2317: WHERE product_transaction_id = p_transaction_temp_id
2318: AND product_code = 'RCV';
2319: END IF;
2320: IF (l_msni_count = 0) THEN

Line 3946: FROM mtl_serial_numbers_interface

3942: BEGIN
3943: IF (l_rcv_rcpt_rec.serial_number_control_code = 6) THEN
3944: SELECT count(1)
3945: INTO l_msni_count
3946: FROM mtl_serial_numbers_interface
3947: WHERE product_transaction_id = p_transaction_temp_id
3948: AND product_code = 'RCV';
3949: END IF;
3950: