DBA Data[Home] [Help]

APPS.WIP_MOVE_VALIDATOR dependencies on MTL_SERIAL_NUMBERS

Line 2772: mtl_serial_numbers msn

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
2776: AND wmti.primary_item_id = msn.inventory_item_id

Line 2783: mtl_serial_numbers msn,

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
2786: AND wsmi.assembly_serial_number = msn.serial_number
2787: AND wmti.organization_id = msn.current_organization_id

Line 2825: mtl_serial_numbers msn

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
2829: AND wmti.primary_item_id = msn.inventory_item_id