APPS.RCV_PROCESSOR_PVT dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 438: FROM mtl_serial_numbers_temp msnt,

434: ) IS
435: SELECT msnt.fm_serial_number,
436: msnt.to_serial_number,
437: mtlt.lot_number
438: FROM mtl_serial_numbers_temp msnt,
439: mtl_transaction_lots_temp mtlt
440: WHERE msnt.product_transaction_id = p_interface_transaction_id
441: AND msnt.product_code = 'RCV'
442: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id(+);

Line 479: FROM mtl_serial_numbers_temp msnt

475: * In this case we do not error nor insert. So return.
476: */
477: SELECT COUNT(*)
478: INTO l_serial_count
479: FROM mtl_serial_numbers_temp msnt
480: WHERE msnt.product_transaction_id = p_interface_transaction_id
481: AND msnt.product_code = 'RCV';
482:
483: IF (l_serial_count = 0) THEN

Line 1397: FROM mtl_serial_numbers_temp msnt,

1393: ) IS
1394: SELECT msnt.fm_serial_number,
1395: msnt.to_serial_number,
1396: mtlt.lot_number
1397: FROM mtl_serial_numbers_temp msnt,
1398: mtl_transaction_lots_temp mtlt
1399: WHERE msnt.product_transaction_id = p_interface_transaction_id
1400: AND msnt.product_code = 'RCV'
1401: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id(+);

Line 1443: FROM mtl_serial_numbers_temp msnt

1439: * In this case we do not error nor insert. So return.
1440: */
1441: SELECT COUNT(*)
1442: INTO l_serial_count
1443: FROM mtl_serial_numbers_temp msnt
1444: WHERE msnt.product_transaction_id = p_interface_transaction_id
1445: AND msnt.product_code = 'RCV';
1446:
1447: IF (l_serial_count = 0) THEN

Line 1952: FROM mtl_serial_numbers_temp msnt

1948: * In this case we do not error nor insert. So return.
1949: */
1950: SELECT COUNT(*)
1951: INTO l_serial_count
1952: FROM mtl_serial_numbers_temp msnt
1953: WHERE msnt.product_transaction_id = p_interface_transaction_id
1954: AND msnt.product_code = 'RCV';
1955:
1956: IF (l_serial_count = 0) THEN