[Home] [Help]
75: and process_flag = 1
76: and transaction_source_type_id = 5
77: and rebuild_item_id is not null
78: and not exists (select 1
79: from mtl_system_items msi
80: where msi.inventory_item_id = mti.inventory_item_id
81: and msi.organization_id = mti.organization_id
82: and msi.eam_item_type = 3);
83:
126: and process_flag = 1
127: and transaction_source_type_id = 5
128: and rebuild_item_id is not null
129: and not exists(select 1
130: from mtl_system_items msi, mtl_parameters mp
131: where mti.rebuild_item_id = msi.inventory_item_id
132: and msi.organization_id = mp.organization_id
133: and mp.maint_organization_id = mti.organization_id
134: and msi.eam_item_type = 3
155: and process_flag = 1
156: and transaction_source_type_id = 5
157: and rebuild_activity_id is not null
158: and not exists(select 1
159: from mtl_system_items msi
160: where mti.rebuild_activity_id = msi.inventory_item_id
161: and mti.organization_id = msi.organization_id
162: and msi.eam_item_type = 2);
163:
206: and transaction_source_type_id = 5
207: and wip_entity_type = wip_constants.eam -- bug 9312526, this validation is only for eAM WOs not WIP
208: and abs(primary_quantity) <> 1
209: and exists (select 1
210: from mtl_system_items msi
211: where msi.inventory_item_id = mti.inventory_item_id
212: and msi.organization_id = mti.organization_id
213: and msi.eam_item_type = 3);
214:
297: and transaction_source_type_id = 5
298: and rebuild_item_id is not null
299: and rebuild_serial_number is not null
300: and not exists(select 1
301: from mtl_system_items msi, mtl_parameters mp
302: where mti.rebuild_item_id = msi.inventory_item_id
303: and mti.organization_id = mp.maint_organization_id
304: and mp.organization_id = msi.organization_id
305: and msi.serial_number_control_code in (wip_constants.full_sn,