APPS.WIP_MOVPROC_PRIV dependencies on MTL_SERIAL_NUMBERS

Line 2148: FROM mtl_serial_numbers msn,

2144:
2145: SELECT msn.serial_number serial,
2146: NVL(msn.operation_seq_num, p_start_op) sn_op,
2147: NVL(msn.intraoperation_step_type, WIP_CONSTANTS.QUEUE) sn_step
2148: FROM mtl_serial_numbers msn,
2149: wip_serial_move_interface wsmi,
2150: wip_move_txn_interface wmti
2151: WHERE msn.inventory_item_id = wmti.primary_item_id
2152: AND msn.current_organization_id = wmti.organization_id

Line 9024: INSERT INTO mtl_serial_numbers_interface

9020: /* IF records under serial control THEN continue */
9021: IF(l_mti_ser_rec > 0) THEN
9022: /* Insert serial records into serial interface table */
9023:
9024: INSERT INTO mtl_serial_numbers_interface
9025: (transaction_interface_id,
9026: creation_date,
9027: created_by,
9028: last_update_date,

Line 9065: fnd_message.set_token('ENTITY2', 'MTL_SERIAL_NUMBERS_INTERFACE');

9061: -- IF debug message level = 2, write statement below to log file
9062: IF (l_logLevel <= wip_constants.full_logging) THEN
9063: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
9064: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
9065: fnd_message.set_token('ENTITY2', 'MTL_SERIAL_NUMBERS_INTERFACE');
9066: l_msg := fnd_message.get;
9067: wip_logger.log(p_msg => l_msg,
9068: x_returnStatus => l_returnStatus);
9069: END IF;

Line 10479: UPDATE mtl_serial_numbers msn1

10475: END LOOP; -- c_txn_date FETCH
10476: /*---------------------------------------------------------------------+
10477: | Set group_mark_id to wip_entity_id for Return and Move transactions |
10478: +---------------------------------------------------------------------*/
10479: UPDATE mtl_serial_numbers msn1
10480: SET msn1.group_mark_id = msn1.wip_entity_id
10481: WHERE msn1.gen_object_id =
10482: (SELECT msn2.gen_object_id
10483: FROM wip_move_txn_interface wmti,

Line 10485: mtl_serial_numbers msn2

10481: WHERE msn1.gen_object_id =
10482: (SELECT msn2.gen_object_id
10483: FROM wip_move_txn_interface wmti,
10484: wip_serial_move_interface wsmi,
10485: mtl_serial_numbers msn2
10486: WHERE wmti.transaction_id = wsmi.transaction_id
10487: AND wsmi.assembly_serial_number = msn2.serial_number
10488: AND wmti.primary_item_id = msn2.inventory_item_id
10489: AND wmti.organization_id = msn2.current_organization_id