you guys asked for it
CREATE VIEW V_WELL_ATTRIBUTES
AS
SELECT
WELL.WELL_ID AS ENUM_0,
WELL.DISPLAY_NAME_FORMAT AS ENUM_10,
WELL.WELL_NAME AS ENUM_20,
WELL.WELL_ALIAS_NAME AS ENUM_30,
WELL.API_NUMBER AS ENUM_40,
'' AS ENUM_50,
WELL.DLS AS ENUM_60,
WELL.NTS AS ENUM_70,
WELL.PROD_ID AS ENUM_80,
WELL.IMPORT_STATUS_DATE AS ENUM_90,
LKUP_GIS_STATUS.GIS_STATUS AS ENUM_100,
LKUP_PRIMARY_FLUID.PRIMARY_FLUID AS ENUM_110,
WELL.IMPORT_STATUS AS ENUM_120,
LKUP_COUNTRY.COUNTRY_NAME AS ENUM_130,
LKUP_PROVINCE_STATE.PROVINCE_STATE_NAME AS ENUM_140,
LKUP_COUNTY.COUNTY_NAME AS ENUM_150,
WELL.DISTRICT AS ENUM_160,
LKUP_PROPERTY.PROPERTY_NAME AS ENUM_170,
WELL.ONSHORE_OFFSHORE AS ENUM_180,
LKUP_BASIN.BASIN_NAME AS ENUM_190,
LKUP_BASIN.BASIN_CODE AS ENUM_200,
LKUP_FIELD.FIELD_NAME AS ENUM_210,
LKUP_FIELD.FIELD_CODE AS ENUM_220,
LKUP_FORMATION.FORMATION_NAME AS ENUM_230,
LKUP_FORMATION.FORMATION_CODE AS ENUM_240,
LKUP_POOL.POOL_NAME AS ENUM_250,
LKUP_POOL.POOL_CODE AS ENUM_260,
' ' AS ENUM_270,
' ' AS ENUM_280,
' ' AS ENUM_290,
' ' AS ENUM_300,
' ' AS ENUM_310,
' ' AS ENUM_320,
' ' AS ENUM_330,
' ' AS ENUM_340,
' ' AS ENUM_350,
' ' AS ENUM_360,
' ' AS ENUM_370,
' ' AS ENUM_380,
WELL.RIG_RELEASE_DATE AS ENUM_390,
WELL.SPUD_DATE AS ENUM_400,
WELL.KELLY_BUSHING_MSL AS ENUM_410,
WELL.GROUND_LEVEL_MSL AS ENUM_420,
WELL.CASING_FLANGE_MSL AS ENUM_430,
WELL.PLUGBACK_DEPTH_TVD_KB AS ENUM_440,
WELL.PLUGBACK_DEPTH_MD_KB AS ENUM_450,
LKUP_OPERATOR1.OPERATOR_NAME AS ENUM_460,
LKUP_OPERATOR1.OPERATOR_CODE AS ENUM_470,
LKUP_OPERATOR2.OPERATOR_NAME AS ENUM_480,
LKUP_OPERATOR2.OPERATOR_CODE AS ENUM_490,
' ' AS ENUM_500,
LKUP_BATTERY.BATTERY_NAME AS ENUM_510,
LKUP_BATTERY.BATTERY_CODE AS ENUM_520,
LKUP_PLANT_TYPE.PLANT_TYPE AS ENUM_530,
LKUP_PLANT_TYPE.PLANT_TYPE_DESC AS ENUM_540,
LKUP_PLANT_CODE.PLANT_CODE AS ENUM_550,
LKUP_PLANT_CODE.PLANT_CODE AS ENUM_560,
LKUP_LATERAL.LATERAL_NAME AS ENUM_570,
LKUP_LATERAL.LATERAL_CODE AS ENUM_580,
WELL.METER_NUMBER AS ENUM_590,
WELL.OIL_CONDENSATE_GATHERER AS ENUM_600,
WELL.GAS_GATHERER AS ENUM_610,
WELL.wellbore_radius AS ENUM_620,
WELL.well_type_ID AS ENUM_630,
' ' AS ENUM_640,
' ' AS ENUM_650,
' ' AS ENUM_660,
' ' AS ENUM_670,
' ' AS ENUM_680,
' ' AS ENUM_690,
' ' AS ENUM_700,
' ' AS ENUM_710,
' ' AS ENUM_720,
' ' AS ENUM_730,
' ' AS ENUM_740,
' ' AS ENUM_750,
' ' AS ENUM_760,
' ' AS ENUM_770,
' ' AS ENUM_780,
' ' AS ENUM_790,
' ' AS ENUM_800,
' ' AS ENUM_810,
' ' AS ENUM_820,
' ' AS ENUM_830,
' ' AS ENUM_840,
' ' AS ENUM_850,
' ' AS ENUM_860,
' ' AS ENUM_870,
' ' AS ENUM_880,
' ' AS ENUM_890,
' ' AS ENUM_900,
' ' AS ENUM_910,
' ' AS ENUM_920,
' ' AS ENUM_930,
' ' AS ENUM_940,
' ' AS ENUM_950,
' ' AS ENUM_960,
' ' AS ENUM_970,
' ' AS ENUM_980,
' ' AS ENUM_990,
' ' AS ENUM_1000,
' ' AS ENUM_1010,
' ' AS ENUM_1020,
' ' AS ENUM_1030,
' ' AS ENUM_1040,
' ' AS ENUM_1050,
' ' AS ENUM_1060
FROM
WELL
LEFT OUTER JOIN LKUP_GIS_STATUS LKUP_GIS_STATUS ON ( WELL.GIS_STATUS_ID = LKUP_GIS_STATUS.GIS_STATUS_ID)
LEFT OUTER JOIN LKUP_PRIMARY_FLUID LKUP_PRIMARY_FLUID ON ( WELL.primary_fluid_ID = LKUP_PRIMARY_FLUID.primary_fluid_ID )
LEFT OUTER JOIN LKUP_COUNTRY LKUP_COUNTRY ON ( WELL.country_ID = LKUP_COUNTRY.country_ID )
LEFT OUTER JOIN LKUP_PROVINCE_STATE LKUP_PROVINCE_STATE ON ( WELL.province_state_ID = LKUP_PROVINCE_STATE.province_state_ID )
LEFT OUTER JOIN LKUP_COUNTY LKUP_COUNTY ON ( WELL.county_ID = LKUP_COUNTY.county_ID )
LEFT OUTER JOIN LKUP_PROPERTY LKUP_PROPERTY ON ( WELL.property_ID = LKUP_PROPERTY.property_id)
LEFT OUTER JOIN LKUP_BASIN LKUP_BASIN ON ( WELL.basin_ID = LKUP_BASIN.basin_ID)
LEFT OUTER JOIN LKUP_FIELD LKUP_FIELD ON ( WELL.Field_ID = LKUP_FIELD.Field_ID)
LEFT OUTER JOIN LKUP_FORMATION LKUP_FORMATION ON ( WELL.Formation_ID = LKUP_FORMATION.Formation_ID)
LEFT OUTER JOIN LKUP_POOL LKUP_POOL ON ( WELL.Pool_ID = LKUP_POOL.Pool_ID)
LEFT OUTER JOIN LKUP_OPERATOR LKUP_OPERATOR1 ON ( WELL.Original_Operator_ID = LKUP_OPERATOR1.Operator_ID)
LEFT OUTER JOIN LKUP_OPERATOR LKUP_OPERATOR2 ON ( WELL.Operator_ID = LKUP_OPERATOR2.Operator_ID)
LEFT OUTER JOIN LKUP_BATTERY LKUP_BATTERY ON ( WELL.battery_ID = LKUP_BATTERY.Battery_ID)
LEFT OUTER JOIN LKUP_PLANT_CODE LKUP_PLANT_CODE ON ( WELL.Plant_Code_ID = LKUP_PLANT_CODE.Plant_Code_ID)
LEFT OUTER JOIN LKUP_PLANT_TYPE LKUP_PLANT_TYPE ON ( WELL.Plant_Type_ID = LKUP_PLANT_TYPE.Plant_Type_ID)
LEFT OUTER JOIN LKUP_LATERAL LKUP_LATERAL ON ( WELL.Lateral_ID = LKUP_LATERAL.Lateral_ID)
LEFT OUTER JOIN FACILITY FACILITY ON ( FACILITY.facility_ID = WELL.well_ID )
LEFT OUTER JOIN ANALYSIS_PROP ANALYSIS_PROP ON ( FACILITY.facility_ID = ANALYSIS_PROP.facility_ID)
LEFT OUTER JOIN RESERVOIR_DATA RESERVOIR_DATA ON ( RESERVOIR_DATA.analysis_prop_ID = ANALYSIS_PROP.analysis_prop_ID);