APPS.WIP_EAMMTLPROC_PRIV dependencies on MTL_SYSTEM_ITEMS

Line 79: from mtl_system_items msi

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:

Line 130: from mtl_system_items msi, mtl_parameters mp

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

Line 159: from mtl_system_items msi

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:

Line 209: from mtl_system_items msi

205: and process_flag = 1
206: and transaction_source_type_id = 5
207: and abs(primary_quantity) <> 1
208: and exists (select 1
209: from mtl_system_items msi
210: where msi.inventory_item_id = mti.inventory_item_id
211: and msi.organization_id = mti.organization_id
212: and msi.eam_item_type = 3);
213:

Line 300: from mtl_system_items msi, mtl_parameters mp

296: and transaction_source_type_id = 5
297: and rebuild_item_id is not null
298: and rebuild_serial_number is not null
299: and not exists(select 1
300: from mtl_system_items msi, mtl_parameters mp
301: where mti.rebuild_item_id = msi.inventory_item_id
302: and mti.organization_id = mp.maint_organization_id
303: and mp.organization_id = msi.organization_id
304: and msi.serial_number_control_code in (wip_constants.full_sn,