APPS.WIP_MOVE_VALIDATOR dependencies on WIP_SERIAL_MOVE_INTERFACE

Line 2675: FROM wip_serial_move_interface wsmi

2671: wmti.to_intraoperation_step_type = WIP_CONSTANTS.QUEUE))))
2672: )
2673: AND EXISTS
2674: (SELECT 'X'
2675: FROM wip_serial_move_interface wsmi
2676: WHERE wsmi.transaction_id = wmti.transaction_id)
2677: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
2678:
2679: fnd_message.set_name('WIP', 'WIP_SERIAL_INFO_NOT_ALLOW');

Line 2703: FROM wip_serial_move_interface wsmi,

2699: AND wmti.fm_operation_seq_num >= wdj.serialization_start_op
2700: AND wmti.to_operation_seq_num >= wdj.serialization_start_op)
2701: AND wmti.primary_quantity <>
2702: (SELECT COUNT(*)
2703: FROM wip_serial_move_interface wsmi,
2704: mtl_serial_numbers msn
2705: WHERE wsmi.transaction_id = wmti.transaction_id
2706: AND wsmi.assembly_serial_number = msn.serial_number
2707: AND wmti.organization_id = msn.current_organization_id

Line 2713: FROM wip_serial_move_interface wsmi,

2709: AND msn.wip_entity_id IS NOT NULL
2710: AND msn.wip_entity_id = wmti.wip_entity_id)
2711: AND wmti.primary_quantity <>
2712: (SELECT COUNT(*)
2713: FROM wip_serial_move_interface wsmi,
2714: wip_entities we,
2715: mtl_serial_numbers msn,
2716: mtl_object_genealogy mog
2717: WHERE wsmi.transaction_id = wmti.transaction_id

Line 2756: FROM wip_serial_move_interface wsmi,

2752: AND wmti.fm_operation_seq_num >= wdj.serialization_start_op
2753: AND wmti.to_operation_seq_num >= wdj.serialization_start_op)
2754: AND NOT EXISTS
2755: (SELECT 'X'
2756: FROM wip_serial_move_interface wsmi,
2757: mtl_serial_numbers msn
2758: WHERE wsmi.transaction_id = wmti.transaction_id
2759: AND wsmi.assembly_serial_number = msn.serial_number
2760: AND wmti.organization_id = msn.current_organization_id