APPS.RCV_PROCESSOR_PVT dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 451: FROM mtl_serial_numbers_temp msnt,

447: ) IS
448: SELECT msnt.fm_serial_number,
449: msnt.to_serial_number,
450: mtlt.lot_number
451: FROM mtl_serial_numbers_temp msnt,
452: mtl_transaction_lots_temp mtlt
453: WHERE msnt.product_transaction_id = p_interface_transaction_id
454: AND msnt.product_code = 'RCV'
455: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id(+);

Line 492: FROM mtl_serial_numbers_temp msnt

488: * In this case we do not error nor insert. So return.
489: */
490: SELECT COUNT(*)
491: INTO l_serial_count
492: FROM mtl_serial_numbers_temp msnt
493: WHERE msnt.product_transaction_id = p_interface_transaction_id
494: AND msnt.product_code = 'RCV';
495:
496: IF (l_serial_count = 0) THEN

Line 1410: FROM mtl_serial_numbers_temp msnt,

1406: ) IS
1407: SELECT msnt.fm_serial_number,
1408: msnt.to_serial_number,
1409: mtlt.lot_number
1410: FROM mtl_serial_numbers_temp msnt,
1411: mtl_transaction_lots_temp mtlt
1412: WHERE msnt.product_transaction_id = p_interface_transaction_id
1413: AND msnt.product_code = 'RCV'
1414: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id(+);

Line 1456: FROM mtl_serial_numbers_temp msnt

1452: * In this case we do not error nor insert. So return.
1453: */
1454: SELECT COUNT(*)
1455: INTO l_serial_count
1456: FROM mtl_serial_numbers_temp msnt
1457: WHERE msnt.product_transaction_id = p_interface_transaction_id
1458: AND msnt.product_code = 'RCV';
1459:
1460: IF (l_serial_count = 0) THEN

Line 1965: FROM mtl_serial_numbers_temp msnt

1961: * In this case we do not error nor insert. So return.
1962: */
1963: SELECT COUNT(*)
1964: INTO l_serial_count
1965: FROM mtl_serial_numbers_temp msnt
1966: WHERE msnt.product_transaction_id = p_interface_transaction_id
1967: AND msnt.product_code = 'RCV';
1968:
1969: IF (l_serial_count = 0) THEN