DBA Data[Home] [Help]

APPS.WIP_EAMMTLPROC_PRIV dependencies on MTL_PARAMETERS

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 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,