DBA Data[Home] [Help]

APPS.WIP_MOVE_VALIDATOR dependencies on MTL_SERIAL_NUMBERS

Line 2704: mtl_serial_numbers msn

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

Line 2715: mtl_serial_numbers msn,

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

Line 2757: mtl_serial_numbers msn

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