[Home] [Help]
2265:
2266: SELECT msn.serial_number serial,
2267: NVL(msn.operation_seq_num, p_start_op) sn_op,
2268: NVL(msn.intraoperation_step_type, WIP_CONSTANTS.QUEUE) sn_step
2269: FROM mtl_serial_numbers msn,
2270: wip_serial_move_interface wsmi,
2271: wip_move_txn_interface wmti
2272: WHERE msn.inventory_item_id = wmti.primary_item_id
2273: AND msn.current_organization_id = wmti.organization_id
9293: /* IF records under serial control THEN continue */
9294: IF(l_mti_ser_rec > 0) THEN
9295: /* Insert serial records into serial interface table */
9296:
9297: INSERT INTO mtl_serial_numbers_interface
9298: (transaction_interface_id,
9299: creation_date,
9300: created_by,
9301: last_update_date,
9334: -- IF debug message level = 2, write statement below to log file
9335: IF (l_logLevel <= wip_constants.full_logging) THEN
9336: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
9337: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
9338: fnd_message.set_token('ENTITY2', 'MTL_SERIAL_NUMBERS_INTERFACE');
9339: l_msg := fnd_message.get;
9340: wip_logger.log(p_msg => l_msg,
9341: x_returnStatus => l_returnStatus);
9342: END IF;
10832: END LOOP; -- c_txn_date FETCH
10833: /*---------------------------------------------------------------------+
10834: | Set group_mark_id to wip_entity_id for Return and Move transactions |
10835: +---------------------------------------------------------------------*/
10836: UPDATE mtl_serial_numbers msn1
10837: SET msn1.group_mark_id = msn1.wip_entity_id
10838: WHERE msn1.gen_object_id =
10839: (SELECT msn2.gen_object_id
10840: FROM wip_move_txn_interface wmti,
10838: WHERE msn1.gen_object_id =
10839: (SELECT msn2.gen_object_id
10840: FROM wip_move_txn_interface wmti,
10841: wip_serial_move_interface wsmi,
10842: mtl_serial_numbers msn2
10843: WHERE wmti.transaction_id = wsmi.transaction_id
10844: AND wsmi.assembly_serial_number = msn2.serial_number
10845: AND wmti.primary_item_id = msn2.inventory_item_id
10846: AND wmti.organization_id = msn2.current_organization_id