ECC Enterprise Asset Management, eAM: Asset Attributes, SQL1

Description
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 ECC
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 'ASSET_ROW_ID','ASSET_CONTEXT_VALUE','ASSET_ADR1','ASSET_ADR2','ASSET_CITY','ASSET_STATE','ASSET_ZIP','ASSET_ATTACHMENTS','ASSET_ATTACHMENTS1','ASSET_ATTACHMENTS2','ASSET_ATTACHMENTS3','ASSET_MAKE','ASSET_BATCH_CONTINUOUS','ASSET_MIXER_TYPE','ASSET_MOUNTING','ASSET_EXTERIOR_PAINT_COLOR','ASSET_INTERIOR_PAINT_COLOR','ASSET_CARPET_STYLE','ASSET_LOBBY_FLOOR_FINISH','ASSET_CUBICAL_SYSTEM_TYPE','ASSET_OFFICE_FURNITURE_SYSTEM_TYPE','ASSET_COMPRESSOR_TYPE','ASSET_SUCTION_PRESSURE__PSIG_','ASSET_DISCHARGE_PRESSURE__PSIG_','ASSET_FLOW_RATE__CFM_','ASSET_COOLING_METHOD','ASSET_HORSEPOWER','ASSET_WEIGHT','ASSET_NOISE_LEVEL_DB_A_','ASSET_COMPLETION_DATE','ASSET_ARCHITECT','ASSET_CONTRACTOR_SHELL','ASSET_CONTRACTOR_CORE','ASSET_ELECTRICAL_CONTRACTOR','ASSET_PLUMBING_CONTRACTOR','ASSET_HVAC_CONTRACTOR','ASSET_SPEED','ASSET_VOLTAGE','ASSET_NETWORKED','ASSET_NAME','ASSET_ACCT','ASSET_CONTACT','ASSET_PHONE','ASSET_BLOCK','ASSET_CYLINDER_HEAD','ASSET_TORQUE','ASSET_DISPLACEMENT','ASSET_VALVE_CONFIGURATION','ASSET_COMPRESSION_RATIO','ASSET_BORE___STROKE','ASSET_VOLTS','ASSET_PHASES','ASSET_LINE_SIZE','ASSET_MODEL','ASSET_LOAD','ASSET_MAST','ASSET_TONS','ASSET_BTUN','ASSET_KW','ASSET_CLAMP_FORCE','ASSET_OPENING_FORCE','ASSET_DRY_CYCLE_RATE','ASSET_SPECIFIC_INJECTION_PRESSURE','ASSET_BARREL_HEATING_POWER','ASSET_IDENTIFICATION','ASSET_DEPRECIATED_LIFE','ASSET_ESTIMATED_COST','ASSET_ENGINE','ASSET_TRANSMISSION','ASSET_SURFACE_REACH','ASSET_DIGGING_DEPTH','ASSET_GVW','ASSET_CLEARANCE','ASSET_TILE','ASSET_ATLAS','ASSET_COORDINATE_FOR_X','ASSET_COORDINATE_FOR_Y','ASSET_RESPONSIBLE_PARTY','ASSET_PARTS','ASSET_LABOR','ASSET_YEAR','ASSET_PRODUCT_NUMBER','ASSET_PART_NUMBER','ASSET_DRILLING_LINE','ASSET_AUXILIARY_BRAKE','ASSET_TYPE','ASSET_HEIGHT','ASSET_CASING_LOAD','ASSET_SETBACK_LOAD','ASSET_PAINT_COLOR','ASSET_SVP_OFFICE','ASSET_RAISED_FLOOR','ASSET_ORIENTATION','ASSET_MAX_CAPACITY','ASSET_WALL_MATERIAL','ASSET_WALL_CONFIGURATION','ASSET_STN_CONFIG','ASSET_CAT','ASSET_GIS_LOC','ASSET_DAT_IN_SRV','ASSET_ALT_ZON','ASSET_ENC_TYP','ASSET_IN_PRSR','ASSET_SEC_PRSR','ASSET_SURFACE','ASSET_SQ_FT_','ASSET_STORE_OPENING','ASSET_TURNOVER','ASSET_CONSTRUCTION_COMPLETE','ASSET_FIXTURES_ONSITE','ASSET_THERMOSTAT_FUNCTION','ASSET_THERMOSTAT_TYPE','ASSET_THERMOSTAT_ACTION','ASSET_ZONE','ASSET_ROOMS___CUBES_NUMBERS_SERVED','ASSET_SECONDARY_FUNCTION','ASSET_SECONDARY_ZONE','ASSET_EQUIPMENT_VOCATION','ASSET_AXLE_CONFIGURATION','ASSET_ENGINE_TYPE','ASSET_POWER_SOURCE','ASSET_TRANSMISSION_TYPE','ASSET_VIN','ASSET_BODY_TYPE','ASSET_ENGINE_DESCRIPTION','ASSET_WHEELBASE','ASSET_GROSS_VEHICLE_WEIGHT','ASSET_WARRANTY_TYPE','ASSET_WARRANTY_EXPIRATION_DATE','ASSET_MILAGE_LIMIT','ASSET_COVERAGE','ASSET_INSTALLATION_DATE','ASSET_MFGR','ASSET_REG_SIZE','ASSET_SPR_RNG','ASSET_ORFC','ASSET_ST_PSIG','ASSET_ST_WC','ASSET_IN_PRS','ASSET_OUT_PRS','ASSET_CNCTN','ASSET_PRS_TAG','ASSET_CONCATENATED_SEGMENTS' from dual where 1=2  union select ROWIDTOCHAR(ROW_ID),CONTEXT_VALUE,ADR1,ADR2,CITY,STATE,ZIP,ATTACHMENTS,ATTACHMENTS1,ATTACHMENTS2,ATTACHMENTS3,MAKE,BATCH_CONTINUOUS,MIXER_TYPE,MOUNTING,EXTERIOR_PAINT_COLOR,INTERIOR_PAINT_COLOR,CARPET_STYLE,LOBBY_FLOOR_FINISH,CUBICAL_SYSTEM_TYPE,OFFICE_FURNITURE_SYSTEM_TYPE,COMPRESSOR_TYPE,SUCTION_PRESSURE__PSIG_,DISCHARGE_PRESSURE__PSIG_,to_char(FLOW_RATE__CFM_),COOLING_METHOD,HORSEPOWER,WEIGHT,to_char(NOISE_LEVEL_DB_A_),COMPLETION_DATE,ARCHITECT,CONTRACTOR_SHELL,CONTRACTOR_CORE,ELECTRICAL_CONTRACTOR,PLUMBING_CONTRACTOR,HVAC_CONTRACTOR,SPEED,VOLTAGE,NETWORKED,NAME,ACCT,CONTACT,PHONE,BLOCK,CYLINDER_HEAD,TORQUE,DISPLACEMENT,VALVE_CONFIGURATION,COMPRESSION_RATIO,BORE___STROKE,VOLTS,PHASES,LINE_SIZE,MODEL,LOAD,MAST,TONS,BTUN,KW,CLAMP_FORCE,OPENING_FORCE,DRY_CYCLE_RATE,SPECIFIC_INJECTION_PRESSURE,BARREL_HEATING_POWER,IDENTIFICATION,DEPRECIATED_LIFE,ESTIMATED_COST,ENGINE,TRANSMISSION,SURFACE_REACH,DIGGING_DEPTH,GVW,CLEARANCE,TILE,ATLAS,COORDINATE_FOR_X,COORDINATE_FOR_Y,RESPONSIBLE_PARTY,PARTS,LABOR,YEAR,PRODUCT_NUMBER,PART_NUMBER,DRILLING_LINE,AUXILIARY_BRAKE,TYPE,to_char(HEIGHT),to_char(CASING_LOAD),to_char(SETBACK_LOAD),PAINT_COLOR,SVP_OFFICE,RAISED_FLOOR,ORIENTATION,MAX_CAPACITY,WALL_MATERIAL,WALL_CONFIGURATION,STN_CONFIG,CAT,GIS_LOC,DAT_IN_SRV,ALT_ZON,ENC_TYP,IN_PRSR,SEC_PRSR,SURFACE,SQ_FT_,to_char(STORE_OPENING, 'yyyy-mm-dd') ,TURNOVER,CONSTRUCTION_COMPLETE,FIXTURES_ONSITE,THERMOSTAT_FUNCTION,THERMOSTAT_TYPE,THERMOSTAT_ACTION,ZONE,ROOMS___CUBES_NUMBERS_SERVED,SECONDARY_FUNCTION,SECONDARY_ZONE,EQUIPMENT_VOCATION,AXLE_CONFIGURATION,ENGINE_TYPE,POWER_SOURCE,TRANSMISSION_TYPE,VIN,BODY_TYPE,ENGINE_DESCRIPTION,to_char(WHEELBASE),to_char(GROSS_VEHICLE_WEIGHT),WARRANTY_TYPE,WARRANTY_EXPIRATION_DATE,to_char(MILAGE_LIMIT),COVERAGE,INSTALLATION_DATE,MFGR,REG_SIZE,SPR_RNG,ORFC,ST_PSIG,ST_WC,IN_PRS,OUT_PRS,CNCTN,PRS_TAG,CONCATENATED_SEGMENTS from MTL_EAM_ASSET_ATTR_VALUES_DFV) dfv  WHERE meaa.rowid = dfv."'ASSET_ROW_ID'"(+) and meaa.organization_id = mp.organization_id(+)