ECC Enterprise Asset Management, Asset Attributes (Maintenance)

Description
Categories: Enterprise Command Center
Columns: Ecc Spec Id, 'Asset Row Id', 'Asset Context Value', 'Asset Adr1', 'Asset Adr2', 'Asset City', 'Asset State', 'Asset Zip', 'Asset Attachments', 'Asset Attachments1' ...
Imported from Enterprise Command Center
Description: Asset Attributes
Dataset Key: eam-asset-attrs
Query Procedure: EAM_ECC_ASSETS_UTIL_PVT.GET_ECC_ASSET_ATTRS_DATA_LOAD
Security Procedure:
select
x.*
from
(
SELECT meaa.maintenance_object_id ||'-'|| meaa.inventory_item_id ||'-'|| meaa.organization_id ||'-'|| meaa.association_id AS ECC_SPEC_ID , dfv.*,
meaa.SERIAL_NUMBER ASSET_NUMBER,
meaa.ORGANIZATION_ID  ,
mp.organization_code as organization_code
FROM MTL_EAM_ASSET_ATTR_VALUES meaa,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'",TRANSMISSION "'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, 'yyyy-mm-dd')  "'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 MTL_EAM_ASSET_ATTR_VALUES_DFV) dfv  WHERE meaa.rowid = dfv."'ASSET_ROW_ID'"(+) and meaa.organization_id = mp.organization_id(+)
) x
where
2=2