ECC Enterprise Asset Management, Asset Attributes (Maintenance)

select
x.*
from
(
SELECT meaa.maintenance_object_id ||'-'|| meaa.inventory_item_id ||'-'|| cii.last_vld_organization_id ||'-'|| meaa.association_id AS ECC_SPEC_ID , dfv.*,
meaa.SERIAL_NUMBER ASSET_NUMBER,
cii.last_vld_organization_id organization_id  ,
mp.organization_code as organization_code
FROM MTL_EAM_ASSET_ATTR_VALUES meaa, csi_item_instances cii, mtl_parameters mp  , (select "ROW_ID" "'ASSET_ROW_ID'","CONTEXT_VALUE" "'ASSET_CONTEXT_VALUE'","ADR1" "'ASSET_ADR1'","ADR2" "'ASSET_ADR2'","CITY" "'ASSET_CITY'","STATE" "'ASSET_STATE'","ZIP" "'ASSET_ZIP'","ATTACHMENTS" "'ASSET_ATTACHMENTS'","ATTACHMENTS1" "'ASSET_ATTACHMENTS1'","ATTACHMENTS2" "'ASSET_ATTACHMENTS2'","ATTACHMENTS3" "'ASSET_ATTACHMENTS3'","MAKE" "'ASSET_MAKE'","BATCH_CONTINUOUS" "'ASSET_BATCH_CONTINUOUS'","MIXER_TYPE" "'ASSET_MIXER_TYPE'","MOUNTING" "'ASSET_MOUNTING'","EXTERIOR_PAINT_COLOR" "'ASSET_EXTERIOR_PAINT_COLOR'","INTERIOR_PAINT_COLOR" "'ASSET_INTERIOR_PAINT_COLOR'","CARPET_STYLE" "'ASSET_CARPET_STYLE'","LOBBY_FLOOR_FINISH" "'ASSET_LOBBY_FLOOR_FINISH'","CUBICAL_SYSTEM_TYPE" "'ASSET_CUBICAL_SYSTEM_TYPE'","OFFICE_FURNITURE_SYSTEM_TYPE" "'ASSET_OFFICE_FURNITURE_SYSTEM_TYPE'","COMPRESSOR_TYPE" "'ASSET_COMPRESSOR_TYPE'","SUCTION_PRESSURE__PSIG_" "'ASSET_SUCTION_PRESSURE__PSIG_'","DISCHARGE_PRESSURE__PSIG_" "'ASSET_DISCHARGE_PRESSURE__PSIG_'",to_char("FLOW_RATE__CFM_") "'ASSET_FLOW_RATE__CFM_'","COOLING_METHOD" "'ASSET_COOLING_METHOD'","HORSEPOWER" "'ASSET_HORSEPOWER'","WEIGHT" "'ASSET_WEIGHT'",to_char("NOISE_LEVEL_DB_A_") "'ASSET_NOISE_LEVEL_DB_A_'","COMPLETION_DATE" "'ASSET_COMPLETION_DATE'","ARCHITECT" "'ASSET_ARCHITECT'","CONTRACTOR_SHELL" "'ASSET_CONTRACTOR_SHELL'","CONTRACTOR_CORE" "'ASSET_CONTRACTOR_CORE'","ELECTRICAL_CONTRACTOR" "'ASSET_ELECTRICAL_CONTRACTOR'","PLUMBING_CONTRACTOR" "'ASSET_PLUMBING_CONTRACTOR'","HVAC_CONTRACTOR" "'ASSET_HVAC_CONTRACTOR'","SPEED" "'ASSET_SPEED'","VOLTAGE" "'ASSET_VOLTAGE'","NETWORKED" "'ASSET_NETWORKED'","NAME" "'ASSET_NAME'","ACCT" "'ASSET_ACCT'","CONTACT" "'ASSET_CONTACT'","PHONE" "'ASSET_PHONE'","BLOCK" "'ASSET_BLOCK'","CYLINDER_HEAD" "'ASSET_CYLINDER_HEAD'","TORQUE" "'ASSET_TORQUE'","DISPLACEMENT" "'ASSET_DISPLACEMENT'","VALVE_CONFIGURATION" "'ASSET_VALVE_CONFIGURATION'","COMPRESSION_RATIO" "'ASSET_COMPRESSION_RATIO'","BORE___STROKE" "'ASSET_BORE___STROKE'","VOLTS" "'ASSET_VOLTS'","PHASES" "'ASSET_PHASES'","LINE_SIZE" "'ASSET_LINE_SIZE'","MODEL" "'ASSET_MODEL'","LOAD" "'ASSET_LOAD'","MAST" "'ASSET_MAST'","TONS" "'ASSET_TONS'","BTUN" "'ASSET_BTUN'","KW" "'ASSET_KW'","CLAMP_FORCE" "'ASSET_CLAMP_FORCE'","OPENING_FORCE" "'ASSET_OPENING_FORCE'","DRY_CYCLE_RATE" "'ASSET_DRY_CYCLE_RATE'","SPECIFIC_INJECTION_PRESSURE" "'ASSET_SPECIFIC_INJECTION_PRESSURE'","BARREL_HEATING_POWER" "'ASSET_BARREL_HEATING_POWER'","IDENTIFICATION" "'ASSET_IDENTIFICATION'","DEPRECIATED_LIFE" "'ASSET_DEPRECIATED_LIFE'","ESTIMATED_COST" "'ASSET_ESTIMATED_COST'","ENGINE" "'ASSET_ENGINE'",fnd_ecc_dff_util.get_vset_values_dff('MTL_EAM_ASSET_ATTR_VALUES','TRANSMISSION',"TRANSMISSION",401,"CONTEXT_VALUE") "'ASSET_TRANSMISSION'","SURFACE_REACH" "'ASSET_SURFACE_REACH'","DIGGING_DEPTH" "'ASSET_DIGGING_DEPTH'","GVW" "'ASSET_GVW'","CLEARANCE" "'ASSET_CLEARANCE'","TILE" "'ASSET_TILE'","ATLAS" "'ASSET_ATLAS'","COORDINATE_FOR_X" "'ASSET_COORDINATE_FOR_X'","COORDINATE_FOR_Y" "'ASSET_COORDINATE_FOR_Y'","RESPONSIBLE_PARTY" "'ASSET_RESPONSIBLE_PARTY'","PARTS" "'ASSET_PARTS'","LABOR" "'ASSET_LABOR'","YEAR" "'ASSET_YEAR'","PRODUCT_NUMBER" "'ASSET_PRODUCT_NUMBER'","PART_NUMBER" "'ASSET_PART_NUMBER'","DRILLING_LINE" "'ASSET_DRILLING_LINE'","AUXILIARY_BRAKE" "'ASSET_AUXILIARY_BRAKE'","TYPE" "'ASSET_TYPE'",to_char("HEIGHT") "'ASSET_HEIGHT'",to_char("CASING_LOAD") "'ASSET_CASING_LOAD'",to_char("SETBACK_LOAD") "'ASSET_SETBACK_LOAD'","PAINT_COLOR" "'ASSET_PAINT_COLOR'","SVP_OFFICE" "'ASSET_SVP_OFFICE'","RAISED_FLOOR" "'ASSET_RAISED_FLOOR'","ORIENTATION" "'ASSET_ORIENTATION'","MAX_CAPACITY" "'ASSET_MAX_CAPACITY'","WALL_MATERIAL" "'ASSET_WALL_MATERIAL'","WALL_CONFIGURATION" "'ASSET_WALL_CONFIGURATION'","STN_CONFIG" "'ASSET_STN_CONFIG'","CAT" "'ASSET_CAT'","GIS_LOC" "'ASSET_GIS_LOC'","DAT_IN_SRV" "'ASSET_DAT_IN_SRV'","ALT_ZON" "'ASSET_ALT_ZON'","ENC_TYP" "'ASSET_ENC_TYP'","IN_PRSR" "'ASSET_IN_PRSR'","SEC_PRSR" "'ASSET_SEC_PRSR'","SURFACE" "'ASSET_SURFACE'","SQ_FT_" "'ASSET_SQ_FT_'",to_char("STORE_OPENING")  "'ASSET_STORE_OPENING'","TURNOVER" "'ASSET_TURNOVER'","CONSTRUCTION_COMPLETE" "'ASSET_CONSTRUCTION_COMPLETE'","FIXTURES_ONSITE" "'ASSET_FIXTURES_ONSITE'","THERMOSTAT_FUNCTION" "'ASSET_THERMOSTAT_FUNCTION'","THERMOSTAT_TYPE" "'ASSET_THERMOSTAT_TYPE'","THERMOSTAT_ACTION" "'ASSET_THERMOSTAT_ACTION'","ZONE" "'ASSET_ZONE'","ROOMS___CUBES_NUMBERS_SERVED" "'ASSET_ROOMS___CUBES_NUMBERS_SERVED'","SECONDARY_FUNCTION" "'ASSET_SECONDARY_FUNCTION'","SECONDARY_ZONE" "'ASSET_SECONDARY_ZONE'","EQUIPMENT_VOCATION" "'ASSET_EQUIPMENT_VOCATION'","AXLE_CONFIGURATION" "'ASSET_AXLE_CONFIGURATION'","ENGINE_TYPE" "'ASSET_ENGINE_TYPE'","POWER_SOURCE" "'ASSET_POWER_SOURCE'","TRANSMISSION_TYPE" "'ASSET_TRANSMISSION_TYPE'","VIN" "'ASSET_VIN'","BODY_TYPE" "'ASSET_BODY_TYPE'","ENGINE_DESCRIPTION" "'ASSET_ENGINE_DESCRIPTION'",to_char("WHEELBASE") "'ASSET_WHEELBASE'",to_char("GROSS_VEHICLE_WEIGHT") "'ASSET_GROSS_VEHICLE_WEIGHT'","WARRANTY_TYPE" "'ASSET_WARRANTY_TYPE'","WARRANTY_EXPIRATION_DATE" "'ASSET_WARRANTY_EXPIRATION_DATE'",to_char("MILAGE_LIMIT") "'ASSET_MILAGE_LIMIT'","COVERAGE" "'ASSET_COVERAGE'","INSTALLATION_DATE" "'ASSET_INSTALLATION_DATE'","MFGR" "'ASSET_MFGR'","REG_SIZE" "'ASSET_REG_SIZE'","SPR_RNG" "'ASSET_SPR_RNG'","ORFC" "'ASSET_ORFC'","ST_PSIG" "'ASSET_ST_PSIG'","ST_WC" "'ASSET_ST_WC'","IN_PRS" "'ASSET_IN_PRS'","OUT_PRS" "'ASSET_OUT_PRS'","CNCTN" "'ASSET_CNCTN'","PRS_TAG" "'ASSET_PRS_TAG'","CONCATENATED_SEGMENTS" "'ASSET_CONCATENATED_SEGMENTS'" from ( select ROWID "ROW_ID",ATTRIBUTE_CATEGORY "CONTEXT_VALUE",(DECODE(ATTRIBUTE_CATEGORY,'Address',C_ATTRIBUTE1,NULL)) "ADR1",(DECODE(ATTRIBUTE_CATEGORY,'Address',C_ATTRIBUTE2,NULL)) "ADR2",(DECODE(ATTRIBUTE_CATEGORY,'Address',C_ATTRIBUTE3,NULL)) "CITY",(DECODE(ATTRIBUTE_CATEGORY,'Address',C_ATTRIBUTE4,NULL)) "STATE",(DECODE(ATTRIBUTE_CATEGORY,'Address',C_ATTRIBUTE5,NULL)) "ZIP",(DECODE(ATTRIBUTE_CATEGORY,'Available Attachments',C_ATTRIBUTE12,NULL)) "ATTACHMENTS",(DECODE(ATTRIBUTE_CATEGORY,'Available Attachments',C_ATTRIBUTE13,NULL)) "ATTACHMENTS1",(DECODE(ATTRIBUTE_CATEGORY,'Available Attachments',C_ATTRIBUTE14,NULL)) "ATTACHMENTS2",(DECODE(ATTRIBUTE_CATEGORY,'Available Attachments',C_ATTRIBUTE15,NULL)) "ATTACHMENTS3",(DECODE(ATTRIBUTE_CATEGORY,'Vehicle Classifications',C_ATTRIBUTE5,'Production Tank Data',C_ATTRIBUTE10,'Nameplate Data',C_ATTRIBUTE10,'Fork Lift Classifications',C_ATTRIBUTE1,'Blender/Mixer Data',C_ATTRIBUTE16,NULL)) "MAKE",(DECODE(ATTRIBUTE_CATEGORY,'Blender/Mixer Data',C_ATTRIBUTE17,NULL)) "BATCH_CONTINUOUS",(DECODE(ATTRIBUTE_CATEGORY,'Blender/Mixer Data',C_ATTRIBUTE18,NULL)) "MIXER_TYPE",(DECODE(ATTRIBUTE_CATEGORY,'Blender/Mixer Data',C_ATTRIBUTE19,NULL)) "MOUNTING",(DECODE(ATTRIBUTE_CATEGORY,'Building Finishes',C_ATTRIBUTE10,NULL)) "EXTERIOR_PAINT_COLOR",(DECODE(ATTRIBUTE_CATEGORY,'Building Finishes',C_ATTRIBUTE11,NULL)) "INTERIOR_PAINT_COLOR",(DECODE(ATTRIBUTE_CATEGORY,'Office Finishes',C_ATTRIBUTE13,'Building Finishes',C_ATTRIBUTE13,NULL)) "CARPET_STYLE",(DECODE(ATTRIBUTE_CATEGORY,'Building Finishes',C_ATTRIBUTE14,NULL)) "LOBBY_FLOOR_FINISH",(DECODE(ATTRIBUTE_CATEGORY,'Building Finishes',C_ATTRIBUTE19,NULL)) "CUBICAL_SYSTEM_TYPE",(DECODE(ATTRIBUTE_CATEGORY,'Office Finishes',C_ATTRIBUTE10,'Building Finishes',C_ATTRIBUTE16,NULL)) "OFFICE_FURNITURE_SYSTEM_TYPE",(DECODE(ATTRIBUTE_CATEGORY,'Compressor',C_ATTRIBUTE1,NULL)) "COMPRESSOR_TYPE",(DECODE(ATTRIBUTE_CATEGORY,'Compressor',C_ATTRIBUTE10,NULL)) "SUCTION_PRESSURE__PSIG_",(DECODE(ATTRIBUTE_CATEGORY,'Compressor',C_ATTRIBUTE11,NULL)) "DISCHARGE_PRESSURE__PSIG_",(DECODE(ATTRIBUTE_CATEGORY,'Compressor',C_ATTRIBUTE12,NULL)) "FLOW_RATE__CFM_",(DECODE(ATTRIBUTE_CATEGORY,'Compressor',C_ATTRIBUTE16,NULL)) "COOLING_METHOD",(DECODE(ATTRIBUTE_CATEGORY,'OG-Mast',C_ATTRIBUTE1,'Engine Specifications',C_ATTRIBUTE12,'Compressor',C_ATTRIBUTE15,NULL)) "HORSEPOWER",(DECODE(ATTRIBUTE_CATEGORY,'HVAC Specifications',C_ATTRIBUTE13,'Compressor',C_ATTRIBUTE13,NULL)) "WEIGHT",(DECODE(ATTRIBUTE_CATEGORY,'Compressor',C_ATTRIBUTE17,NULL)) "NOISE_LEVEL_DB_A_",(DECODE(ATTRIBUTE_CATEGORY,'Construction History',C_ATTRIBUTE10,NULL)) "COMPLETION_DATE",(DECODE(ATTRIBUTE_CATEGORY,'Construction History',C_ATTRIBUTE11,NULL)) "ARCHITECT",(DECODE(ATTRIBUTE_CATEGORY,'Construction History',C_ATTRIBUTE12,NULL)) "CONTRACTOR_SHELL",(DECODE(ATTRIBUTE_CATEGORY,'Construction History',C_ATTRIBUTE14,NULL)) "CONTRACTOR_CORE",(DECODE(ATTRIBUTE_CATEGORY,'Construction History',C_ATTRIBUTE15,NULL)) "ELECTRICAL_CONTRACTOR",(DECODE(ATTRIBUTE_CATEGORY,'Construction History',C_ATTRIBUTE17,NULL)) "PLUMBING_CONTRACTOR",(DECODE(ATTRIBUTE_CATEGORY,'Construction History',C_ATTRIBUTE19,NULL)) "HVAC_CONTRACTOR",(DECODE(ATTRIBUTE_CATEGORY,'Copier',C_ATTRIBUTE10,NULL)) "SPEED",(DECODE(ATTRIBUTE_CATEGORY,'Copier',C_ATTRIBUTE12,NULL)) "VOLTAGE",(DECODE(ATTRIBUTE_CATEGORY,'Copier',C_ATTRIBUTE14,NULL)) "NETWORKED",(DECODE(ATTRIBUTE_CATEGORY,'Customer',C_ATTRIBUTE1,NULL)) "NAME",(DECODE(ATTRIBUTE_CATEGORY,'Customer',C_ATTRIBUTE2,NULL)) "ACCT",(DECODE(ATTRIBUTE_CATEGORY,'Customer',C_ATTRIBUTE3,NULL)) "CONTACT",(DECODE(ATTRIBUTE_CATEGORY,'Customer',C_ATTRIBUTE4,NULL)) "PHONE",(DECODE(ATTRIBUTE_CATEGORY,'Engine Specifications',C_ATTRIBUTE10,NULL)) "BLOCK",(DECODE(ATTRIBUTE_CATEGORY,'Engine Specifications',C_ATTRIBUTE11,NULL)) "CYLINDER_HEAD",(DECODE(ATTRIBUTE_CATEGORY,'Engine Specifications',C_ATTRIBUTE13,NULL)) "TORQUE",(DECODE(ATTRIBUTE_CATEGORY,'Engine Specifications',C_ATTRIBUTE14,NULL)) "DISPLACEMENT",(DECODE(ATTRIBUTE_CATEGORY,'Engine Specifications',C_ATTRIBUTE15,NULL)) "VALVE_CONFIGURATION",(DECODE(ATTRIBUTE_CATEGORY,'Engine Specifications',C_ATTRIBUTE16,NULL)) "COMPRESSION_RATIO",(DECODE(ATTRIBUTE_CATEGORY,'Engine Specifications',C_ATTRIBUTE17,NULL)) "BORE___STROKE",(DECODE(ATTRIBUTE_CATEGORY,'Feeder Line',C_ATTRIBUTE10,NULL)) "VOLTS",(DECODE(ATTRIBUTE_CATEGORY,'Feeder Line',C_ATTRIBUTE11,NULL)) "PHASES",(DECODE(ATTRIBUTE_CATEGORY,'Feeder Line',C_ATTRIBUTE12,NULL)) "LINE_SIZE",(DECODE(ATTRIBUTE_CATEGORY,'Work Monitor',C_ATTRIBUTE2,'Vehicle Classifications',C_ATTRIBUTE6,'Nameplate Data',C_ATTRIBUTE11,'Loader Specifications',C_ATTRIBUTE2,'Fork Lift Classifications',C_ATTRIBUTE2,NULL)) "MODEL",(DECODE(ATTRIBUTE_CATEGORY,'Fork Lift Classifications',C_ATTRIBUTE3,NULL)) "LOAD",(DECODE(ATTRIBUTE_CATEGORY,'Fork Lift Classifications',C_ATTRIBUTE4,NULL)) "MAST",(DECODE(ATTRIBUTE_CATEGORY,'HVAC Specifications',C_ATTRIBUTE10,NULL)) "TONS",(DECODE(ATTRIBUTE_CATEGORY,'HVAC Specifications',C_ATTRIBUTE11,NULL)) "BTUN",(DECODE(ATTRIBUTE_CATEGORY,'HVAC Specifications',C_ATTRIBUTE12,NULL)) "KW",(DECODE(ATTRIBUTE_CATEGORY,'Injection Molding Specs',C_ATTRIBUTE10,NULL)) "CLAMP_FORCE",(DECODE(ATTRIBUTE_CATEGORY,'Injection Molding Specs',C_ATTRIBUTE11,NULL)) "OPENING_FORCE",(DECODE(ATTRIBUTE_CATEGORY,'Injection Molding Specs',C_ATTRIBUTE12,NULL)) "DRY_CYCLE_RATE",(DECODE(ATTRIBUTE_CATEGORY,'Injection Molding Specs',C_ATTRIBUTE13,NULL)) "SPECIFIC_INJECTION_PRESSURE",(DECODE(ATTRIBUTE_CATEGORY,'Injection Molding Specs',C_ATTRIBUTE14,NULL)) "BARREL_HEATING_POWER",(DECODE(ATTRIBUTE_CATEGORY,'Loader Specifications',C_ATTRIBUTE1,NULL)) "IDENTIFICATION",(DECODE(ATTRIBUTE_CATEGORY,'Loader Specifications',C_ATTRIBUTE3,NULL)) "DEPRECIATED_LIFE",(DECODE(ATTRIBUTE_CATEGORY,'Loader Specifications',C_ATTRIBUTE4,NULL)) "ESTIMATED_COST",(DECODE(ATTRIBUTE_CATEGORY,'Loader Specifications',C_ATTRIBUTE5,NULL)) "ENGINE",(DECODE(ATTRIBUTE_CATEGORY,'Vehicle Classifications',C_ATTRIBUTE15,'Loader Specifications',C_ATTRIBUTE6,NULL)) "TRANSMISSION",(DECODE(ATTRIBUTE_CATEGORY,'Loader Specifications',C_ATTRIBUTE7,NULL)) "SURFACE_REACH",(DECODE(ATTRIBUTE_CATEGORY,'Loader Specifications',C_ATTRIBUTE8,NULL)) "DIGGING_DEPTH",(DECODE(ATTRIBUTE_CATEGORY,'Loader Specifications',C_ATTRIBUTE9,NULL)) "GVW",(DECODE(ATTRIBUTE_CATEGORY,'Loader Specifications',C_ATTRIBUTE10,NULL)) "CLEARANCE",(DECODE(ATTRIBUTE_CATEGORY,'Location',C_ATTRIBUTE1,NULL)) "TILE",(DECODE(ATTRIBUTE_CATEGORY,'Location',C_ATTRIBUTE2,NULL)) "ATLAS",(DECODE(ATTRIBUTE_CATEGORY,'Location',C_ATTRIBUTE3,NULL)) "COORDINATE_FOR_X",(DECODE(ATTRIBUTE_CATEGORY,'Location',C_ATTRIBUTE4,NULL)) "COORDINATE_FOR_Y",(DECODE(ATTRIBUTE_CATEGORY,'Maintenance Responsibility',C_ATTRIBUTE10,NULL)) "RESPONSIBLE_PARTY",(DECODE(ATTRIBUTE_CATEGORY,'Maintenance Responsibility',C_ATTRIBUTE11,NULL)) "PARTS",(DECODE(ATTRIBUTE_CATEGORY,'Maintenance Responsibility',C_ATTRIBUTE12,NULL)) "LABOR",(DECODE(ATTRIBUTE_CATEGORY,'Vehicle Classifications',C_ATTRIBUTE7,'Nameplate Data',C_ATTRIBUTE12,NULL)) "YEAR",(DECODE(ATTRIBUTE_CATEGORY,'Nameplate Data',C_ATTRIBUTE13,NULL)) "PRODUCT_NUMBER",(DECODE(ATTRIBUTE_CATEGORY,'Nameplate Data',C_ATTRIBUTE14,NULL)) "PART_NUMBER",(DECODE(ATTRIBUTE_CATEGORY,'OG-Mast',C_ATTRIBUTE2,NULL)) "DRILLING_LINE",(DECODE(ATTRIBUTE_CATEGORY,'OG-Mast',C_ATTRIBUTE4,NULL)) "AUXILIARY_BRAKE",(DECODE(ATTRIBUTE_CATEGORY,'Roof Specifications',C_ATTRIBUTE10,'OG-Substructure',C_ATTRIBUTE1,NULL)) "TYPE",(DECODE(ATTRIBUTE_CATEGORY,'OG-Substructure',C_ATTRIBUTE2,NULL)) "HEIGHT",(DECODE(ATTRIBUTE_CATEGORY,'OG-Substructure',C_ATTRIBUTE3,NULL)) "CASING_LOAD",(DECODE(ATTRIBUTE_CATEGORY,'OG-Substructure',C_ATTRIBUTE4,NULL)) "SETBACK_LOAD",(DECODE(ATTRIBUTE_CATEGORY,'Office Finishes',C_ATTRIBUTE12,NULL)) "PAINT_COLOR",(DECODE(ATTRIBUTE_CATEGORY,'Office Finishes',C_ATTRIBUTE14,NULL)) "SVP_OFFICE",(DECODE(ATTRIBUTE_CATEGORY,'Office Finishes',C_ATTRIBUTE15,NULL)) "RAISED_FLOOR",(DECODE(ATTRIBUTE_CATEGORY,'Production Tank Data',C_ATTRIBUTE11,NULL)) "ORIENTATION",(DECODE(ATTRIBUTE_CATEGORY,'Production Tank Data',C_ATTRIBUTE12,NULL)) "MAX_CAPACITY",(DECODE(ATTRIBUTE_CATEGORY,'Production Tank Data',C_ATTRIBUTE13,NULL)) "WALL_MATERIAL",(DECODE(ATTRIBUTE_CATEGORY,'Production Tank Data',C_ATTRIBUTE14,NULL)) "WALL_CONFIGURATION",(DECODE(ATTRIBUTE_CATEGORY,'Reg Station',C_ATTRIBUTE1,NULL)) "STN_CONFIG",(DECODE(ATTRIBUTE_CATEGORY,'Reg Station',C_ATTRIBUTE2,NULL)) "CAT",(DECODE(ATTRIBUTE_CATEGORY,'Reg Station',C_ATTRIBUTE3,NULL)) "GIS_LOC",(DECODE(ATTRIBUTE_CATEGORY,'Reg Station',C_ATTRIBUTE4,NULL)) "DAT_IN_SRV",(DECODE(ATTRIBUTE_CATEGORY,'Reg Station',C_ATTRIBUTE5,NULL)) "ALT_ZON",(DECODE(ATTRIBUTE_CATEGORY,'Reg Station',C_ATTRIBUTE6,NULL)) "ENC_TYP",(DECODE(ATTRIBUTE_CATEGORY,'Reg Station',C_ATTRIBUTE7,NULL)) "IN_PRSR",(DECODE(ATTRIBUTE_CATEGORY,'Reg Station',C_ATTRIBUTE8,NULL)) "SEC_PRSR",(DECODE(ATTRIBUTE_CATEGORY,'Roof Specifications',C_ATTRIBUTE11,NULL)) "SURFACE",(DECODE(ATTRIBUTE_CATEGORY,'Roof Specifications',C_ATTRIBUTE12,NULL)) "SQ_FT_",(DECODE(ATTRIBUTE_CATEGORY,'Store Information',C_ATTRIBUTE13,NULL)) "STORE_OPENING",(DECODE(ATTRIBUTE_CATEGORY,'Store Information',C_ATTRIBUTE1,NULL)) "TURNOVER",(DECODE(ATTRIBUTE_CATEGORY,'Store Information',C_ATTRIBUTE10,NULL)) "CONSTRUCTION_COMPLETE",(DECODE(ATTRIBUTE_CATEGORY,'Store Information',C_ATTRIBUTE12,NULL)) "FIXTURES_ONSITE",(DECODE(ATTRIBUTE_CATEGORY,'Thermostat Information',C_ATTRIBUTE10,NULL)) "THERMOSTAT_FUNCTION",(DECODE(ATTRIBUTE_CATEGORY,'Thermostat Information',C_ATTRIBUTE12,NULL)) "THERMOSTAT_TYPE",(DECODE(ATTRIBUTE_CATEGORY,'Thermostat Information',C_ATTRIBUTE14,NULL)) "THERMOSTAT_ACTION",(DECODE(ATTRIBUTE_CATEGORY,'Thermostat Information',C_ATTRIBUTE15,NULL)) "ZONE",(DECODE(ATTRIBUTE_CATEGORY,'Thermostat Information',C_ATTRIBUTE16,NULL)) "ROOMS___CUBES_NUMBERS_SERVED",(DECODE(ATTRIBUTE_CATEGORY,'Thermostat Information',C_ATTRIBUTE18,NULL)) "SECONDARY_FUNCTION",(DECODE(ATTRIBUTE_CATEGORY,'Thermostat Information',C_ATTRIBUTE19,NULL)) "SECONDARY_ZONE",(DECODE(ATTRIBUTE_CATEGORY,'VMRS Codes',C_ATTRIBUTE10,NULL)) "EQUIPMENT_VOCATION",(DECODE(ATTRIBUTE_CATEGORY,'VMRS Codes',C_ATTRIBUTE11,NULL)) "AXLE_CONFIGURATION",(DECODE(ATTRIBUTE_CATEGORY,'VMRS Codes',C_ATTRIBUTE12,NULL)) "ENGINE_TYPE",(DECODE(ATTRIBUTE_CATEGORY,'VMRS Codes',C_ATTRIBUTE13,NULL)) "POWER_SOURCE",(DECODE(ATTRIBUTE_CATEGORY,'VMRS Codes',C_ATTRIBUTE14,NULL)) "TRANSMISSION_TYPE",(DECODE(ATTRIBUTE_CATEGORY,'Vehicle Classifications',C_ATTRIBUTE12,NULL)) "VIN",(DECODE(ATTRIBUTE_CATEGORY,'Vehicle Classifications',C_ATTRIBUTE11,NULL)) "BODY_TYPE",(DECODE(ATTRIBUTE_CATEGORY,'Vehicle Classifications',C_ATTRIBUTE16,NULL)) "ENGINE_DESCRIPTION",(DECODE(ATTRIBUTE_CATEGORY,'Vehicle Classifications',C_ATTRIBUTE18,NULL)) "WHEELBASE",(DECODE(ATTRIBUTE_CATEGORY,'Vehicle Classifications',C_ATTRIBUTE10,NULL)) "GROSS_VEHICLE_WEIGHT",(DECODE(ATTRIBUTE_CATEGORY,'Warranty Data',C_ATTRIBUTE8,NULL)) "WARRANTY_TYPE",(DECODE(ATTRIBUTE_CATEGORY,'Warranty Data',C_ATTRIBUTE9,NULL)) "WARRANTY_EXPIRATION_DATE",(DECODE(ATTRIBUTE_CATEGORY,'Warranty Data',C_ATTRIBUTE10,NULL)) "MILAGE_LIMIT",(DECODE(ATTRIBUTE_CATEGORY,'Warranty Data',C_ATTRIBUTE12,NULL)) "COVERAGE",(DECODE(ATTRIBUTE_CATEGORY,'Warranty Data',C_ATTRIBUTE14,NULL)) "INSTALLATION_DATE",(DECODE(ATTRIBUTE_CATEGORY,'Work Monitor',C_ATTRIBUTE1,NULL)) "MFGR",(DECODE(ATTRIBUTE_CATEGORY,'Work Monitor',C_ATTRIBUTE3,NULL)) "REG_SIZE",(DECODE(ATTRIBUTE_CATEGORY,'Work Monitor',C_ATTRIBUTE4,NULL)) "SPR_RNG",(DECODE(ATTRIBUTE_CATEGORY,'Work Monitor',C_ATTRIBUTE5,NULL)) "ORFC",(DECODE(ATTRIBUTE_CATEGORY,'Work Monitor',C_ATTRIBUTE6,NULL)) "ST_PSIG",(DECODE(ATTRIBUTE_CATEGORY,'Work Monitor',C_ATTRIBUTE7,NULL)) "ST_WC",(DECODE(ATTRIBUTE_CATEGORY,'Work Monitor',C_ATTRIBUTE8,NULL)) "IN_PRS",(DECODE(ATTRIBUTE_CATEGORY,'Work Monitor',C_ATTRIBUTE9,NULL)) "OUT_PRS",(DECODE(ATTRIBUTE_CATEGORY,'Work Monitor',C_ATTRIBUTE10,NULL)) "CNCTN",(DECODE(ATTRIBUTE_CATEGORY,'Work Monitor',C_ATTRIBUTE11,NULL)) "PRS_TAG",(DECODE(ATTRIBUTE_CATEGORY,'Address',ATTRIBUTE_CATEGORY||'.'||C_ATTRIBUTE1||'.'||C_ATTRIBUTE2||'.'||C_ATTRIBUTE3||'.'||C_ATTRIBUTE4||'.'||C_ATTRIBUTE5,'Available Attachments',ATTRIBUTE_CATEGORY||'.'||C_ATTRIBUTE12||'.'||C_ATTRIBUTE13||'.'||C_ATTRIBUTE14||'.'||C_ATTRIBUTE15,'Blender/Mixer Data',ATTRIBUTE_CATEGORY||'.'||C_ATTRIBUTE16||'.'||C_ATTRIBUTE17||'.'||C_ATTRIBUTE18||'.'||C_ATTRIBUTE19,'Building Finishes',ATTRIBUTE_CATEGORY||'.'||C_ATTRIBUTE10||'.'||C_ATTRIBUTE11||'.'||C_ATTRIBUTE13||'.'||C_ATTRIBUTE14||'.'||C_ATTRIBUTE19||'.'||C_ATTRIBUTE16,'Compressor',ATTRIBUTE_CATEGORY||'.'||C_ATTRIBUTE1||'.'||C_ATTRIBUTE10||'.'||C_ATTRIBUTE11||'.'||C_ATTRIBUTE12||'.'||C_ATTRIBUTE16||'.'||C_ATTRIBUTE15||'.'||C_ATTRIBUTE13||'.'||C_ATTRIBUTE17,'Construction History',ATTRIBUTE_CATEGORY||'.'||C_ATTRIBUTE10||'.'||C_ATTRIBUTE11||'.'||C_ATTRIBUTE12||'.'||C_ATTRIBUTE14||'.'||C_ATTRIBUTE15||'.'||C_ATTRIBUTE17||'.'||C_ATTRIBUTE19,'Copier',ATTRIBUTE_CATEGORY||'.'||C_ATTRIBUTE10||'.'||C_ATTRIBUTE12||'.'||C_ATTRIBUTE14,'Customer',ATTRIBUTE_CATEGORY||'.'||C_ATTRIBUTE1||'.'||C_ATTRIBUTE2||'.'||C_ATTRIBUTE3||'.'||C_ATTRIBUTE4,'Engine Specifications',ATTRIBUTE_CATEGORY||'.'||C_ATTRIBUTE10||'.'||C_ATTRIBUTE11||'.'||C_ATTRIBUTE12||'.'||C_ATTRIBUTE13||'.'||C_ATTRIBUTE14||'.'||C_ATTRIBUTE15||'.'||C_ATTRIBUTE16||'.'||C_ATTRIBUTE17,'Feeder Line',ATTRIBUTE_CATEGORY||'.'||C_ATTRIBUTE10||'.'||C_ATTRIBUTE11||'.'||C_ATTRIBUTE12,'Fork Lift Classifications',ATTRIBUTE_CATEGORY||'.'||C_ATTRIBUTE1||'.'||C_ATTRIBUTE2||'.'||C_ATTRIBUTE3||'.'||C_ATTRIBUTE4,'HVAC Specifications',ATTRIBUTE_CATEGORY||'.'||C_ATTRIBUTE10||'.'||C_ATTRIBUTE11||'.'||C_ATTRIBUTE12||'.'||C_ATTRIBUTE13,'Injection Molding Specs',ATTRIBUTE_CATEGORY||'.'||C_ATTRIBUTE10||'.'||C_ATTRIBUTE11||'.'||C_ATTRIBUTE12||'.'||C_ATTRIBUTE13||'.'||C_ATTRIBUTE14,'Loader Specifications',ATTRIBUTE_CATEGORY||'.'||C_ATTRIBUTE1||'.'||C_ATTRIBUTE2||'.'||C_ATTRIBUTE3||'.'||C_ATTRIBUTE4||'.'||C_ATTRIBUTE5||'.'||C_ATTRIBUTE6||'.'||C_ATTRIBUTE7||'.'||C_ATTRIBUTE8||'.'||C_ATTRIBUTE9||'.'||C_ATTRIBUTE10,'Location',ATTRIBUTE_CATEGORY||'.'||C_ATTRIBUTE1||'.'||C_ATTRIBUTE2||'.'||C_ATTRIBUTE3||'.'||C_ATTRIBUTE4,'Maintenance Responsibility',ATTRIBUTE_CATEGORY||'.'||C_ATTRIBUTE10||'.'||C_ATTRIBUTE11||'.'||C_ATTRIBUTE12,'Nameplate Data',ATTRIBUTE_CATEGORY||'.'||C_ATTRIBUTE10||'.'||C_ATTRIBUTE11||'.'||C_ATTRIBUTE12||'.'||C_ATTRIBUTE13||'.'||C_ATTRIBUTE14,'OG-Mast',ATTRIBUTE_CATEGORY||'.'||C_ATTRIBUTE1||'.'||C_ATTRIBUTE2||'.'||C_ATTRIBUTE4,'OG-Substructure',ATTRIBUTE_CATEGORY||'.'||C_ATTRIBUTE1||'.'||C_ATTRIBUTE2||'.'||C_ATTRIBUTE3||'.'||C_ATTRIBUTE4,'Office Finishes',ATTRIBUTE_CATEGORY||'.'||C_ATTRIBUTE10||'.'||C_ATTRIBUTE12||'.'||C_ATTRIBUTE13||'.'||C_ATTRIBUTE14||'.'||C_ATTRIBUTE15,'Production Tank Data',ATTRIBUTE_CATEGORY||'.'||C_ATTRIBUTE10||'.'||C_ATTRIBUTE11||'.'||C_ATTRIBUTE12||'.'||C_ATTRIBUTE13||'.'||C_ATTRIBUTE14,'Reg Station',ATTRIBUTE_CATEGORY||'.'||C_ATTRIBUTE1||'.'||C_ATTRIBUTE2||'.'||C_ATTRIBUTE3||'.'||C_ATTRIBUTE4||'.'||C_ATTRIBUTE5||'.'||C_ATTRIBUTE6||'.'||C_ATTRIBUTE7||'.'||C_ATTRIBUTE8,'Roof Specifications',ATTRIBUTE_CATEGORY||'.'||C_ATTRIBUTE10||'.'||C_ATTRIBUTE11||'.'||C_ATTRIBUTE12,'Store Information',ATTRIBUTE_CATEGORY||'.'||C_ATTRIBUTE13||'.'||C_ATTRIBUTE1||'.'||C_ATTRIBUTE10||'.'||C_ATTRIBUTE12,'Thermostat Information',ATTRIBUTE_CATEGORY||'.'||C_ATTRIBUTE10||'.'||C_ATTRIBUTE12||'.'||C_ATTRIBUTE14||'.'||C_ATTRIBUTE15||'.'||C_ATTRIBUTE16||'.'||C_ATTRIBUTE18||'.'||C_ATTRIBUTE19,'VMRS Codes',ATTRIBUTE_CATEGORY||'.'||C_ATTRIBUTE10||'.'||C_ATTRIBUTE11||'.'||C_ATTRIBUTE12||'.'||C_ATTRIBUTE13||'.'||C_ATTRIBUTE14,'Vehicle Classifications',ATTRIBUTE_CATEGORY||'.'||C_ATTRIBUTE12||'.'||C_ATTRIBUTE11||'.'||C_ATTRIBUTE15||'.'||C_ATTRIBUTE16||'.'||C_ATTRIBUTE5||'.'||C_ATTRIBUTE6||'.'||C_ATTRIBUTE7||'.'||C_ATTRIBUTE18||'.'||C_ATTRIBUTE10,'Warranty Data',ATTRIBUTE_CATEGORY||'.'||C_ATTRIBUTE8||'.'||C_ATTRIBUTE9||'.'||C_ATTRIBUTE10||'.'||C_ATTRIBUTE12||'.'||C_ATTRIBUTE14,'Work Monitor',ATTRIBUTE_CATEGORY||'.'||C_ATTRIBUTE1||'.'||C_ATTRIBUTE2||'.'||C_ATTRIBUTE3||'.'||C_ATTRIBUTE4||'.'||C_ATTRIBUTE5||'.'||C_ATTRIBUTE6||'.'||C_ATTRIBUTE7||'.'||C_ATTRIBUTE8||'.'||C_ATTRIBUTE9||'.'||C_ATTRIBUTE10||'.'||C_ATTRIBUTE11,NULL)) "CONCATENATED_SEGMENTS" from MTL_EAM_ASSET_ATTR_VALUES )) dfv
WHERE meaa.maintenance_object_id = cii.instance_id
AND cii.last_vld_organization_id = mp.organization_id (+)   AND meaa.rowid = dfv."'ASSET_ROW_ID'"(+)
) x
where
2=2