APPS.WIP_MOVE_VALIDATOR dependencies on WIP_SERIAL_MOVE_INTERFACE

Line 2743: FROM wip_serial_move_interface wsmi

2739: wmti.to_intraoperation_step_type = WIP_CONSTANTS.QUEUE))))
2740: )
2741: AND EXISTS
2742: (SELECT 'X'
2743: FROM wip_serial_move_interface wsmi
2744: WHERE wsmi.transaction_id = wmti.transaction_id)
2745: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
2746:
2747: fnd_message.set_name('WIP', 'WIP_SERIAL_INFO_NOT_ALLOW');

Line 2771: FROM wip_serial_move_interface wsmi,

2767: AND wmti.fm_operation_seq_num >= wdj.serialization_start_op
2768: AND wmti.to_operation_seq_num >= wdj.serialization_start_op)
2769: AND wmti.primary_quantity <>
2770: (SELECT COUNT(*)
2771: FROM wip_serial_move_interface wsmi,
2772: mtl_serial_numbers msn
2773: WHERE wsmi.transaction_id = wmti.transaction_id
2774: AND wsmi.assembly_serial_number = msn.serial_number
2775: AND wmti.organization_id = msn.current_organization_id

Line 2781: FROM wip_serial_move_interface wsmi,

2777: AND msn.wip_entity_id IS NOT NULL
2778: AND msn.wip_entity_id = wmti.wip_entity_id)
2779: AND wmti.primary_quantity <>
2780: (SELECT COUNT(*)
2781: FROM wip_serial_move_interface wsmi,
2782: wip_entities we,
2783: mtl_serial_numbers msn,
2784: mtl_object_genealogy mog
2785: WHERE wsmi.transaction_id = wmti.transaction_id

Line 2824: FROM wip_serial_move_interface wsmi,

2820: AND wmti.fm_operation_seq_num >= wdj.serialization_start_op
2821: AND wmti.to_operation_seq_num >= wdj.serialization_start_op)
2822: AND NOT EXISTS
2823: (SELECT 'X'
2824: FROM wip_serial_move_interface wsmi,
2825: mtl_serial_numbers msn
2826: WHERE wsmi.transaction_id = wmti.transaction_id
2827: AND wsmi.assembly_serial_number = msn.serial_number
2828: AND wmti.organization_id = msn.current_organization_id