DBA Data[Home] [Help]

APPS.INV_COMINGLING_UTILS dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 687: FROM mtl_serial_numbers_temp

683: SELECT 'Y' INTO l_serials_exist
684: FROM dual
685: WHERE exists
686: ( SELECT 1
687: FROM mtl_serial_numbers_temp
688: WHERE transaction_temp_id = p_mmtt_rec.transaction_temp_id);
689: EXCEPTION
690: WHEN no_data_found THEN
691: BEGIN

Line 697: mtl_serial_numbers_temp msnt,

693: FROM dual
694: WHERE exists
695: (SELECT msnt.transaction_temp_id
696: FROM
697: mtl_serial_numbers_temp msnt,
698: mtl_transaction_lots_temp mtlt
699: WHERE mtlt.transaction_temp_id = p_mmtt_rec.transaction_temp_id
700: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id);
701: EXCEPTION