APPS.SERIAL_CHECK dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 622: || ' from mtl_transaction_lots_temp where group_header_id = '|| hdr_id||' and transaction_temp_id = '||temp_id

618: IF (l_debug = 1) THEN
619: inv_log_util.TRACE(
620: 'update msn with group_mark_id in ('|| hdr_id || ', '|| temp_id
621: || ' AND (line_mark_id = '|| temp_id || ' OR line_mark_id in (select SERIAL_TRANSACTION_TEMP_ID'
622: || ' from mtl_transaction_lots_temp where group_header_id = '|| hdr_id||' and transaction_temp_id = '||temp_id
623: || ') OR line_mark_id is NULL or line_mark_id = -1 ) AND '
624: || ' serial_number >= nvl(from_serial_number, serial_number) '
625: || ' AND serial_number <= nvl(to_serial_number, nvl(from_serial_number, serial_number)) '
626: || ' AND length(serial_number) = length(nvl(from_serial_number, serial_number))', 'SERIAL_CHECK');

Line 654: from mtl_transaction_lots_temp

650: (line_mark_id = temp_id OR
651: --Added code for bug 11820774,as for both lot and serial
652: --controlled item line_mark_id != temp_id
653: line_mark_id in (select SERIAL_TRANSACTION_TEMP_ID
654: from mtl_transaction_lots_temp
655: where group_header_id = hdr_id
656: and transaction_temp_id = temp_id)
657: --end fix for bug 11820774
658: OR line_mark_id IS NULL OR line_mark_id = -1

Line 679: from mtl_transaction_lots_temp

675: (line_mark_id = temp_id OR
676: --Added code for bug 11820774,as for both lot and serial
677: --controlled item line_mark_id != temp_id
678: line_mark_id in (select SERIAL_TRANSACTION_TEMP_ID
679: from mtl_transaction_lots_temp
680: where group_header_id = hdr_id
681: and transaction_temp_id = temp_id)
682: --end fix for bug 11820774
683: OR line_mark_id IS NULL OR line_mark_id = -1