I_ColltrlREPartMaster

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_ColltrlREPartMaster.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_ColltrlREPartMaster AS
SELECT
  obj_prt_guid AS CollateralRealEstatePartUUID,
  obj_guid AS CollateralRealEstateUUID,
  part_id AS CollateralRealEstatePartID,
  bld_part_type AS ColltrlREBuildingPartType,
  part_cond AS ColltrlRealEstatePartCondition,
  main_usage AS ColltrlREMainUsageType,
  add_usage_1 AS ColltrlREAdditionalUsageType1,
  add_usage_2 AS ColltrlREAdditionalUsageType2,
  bld_method_roof AS ColltrlREBuildingMethodRoof,
  bld_method_body AS ColltrlREBuildingMethodBody,
  bld_metd_cellar AS ColltrlREBuildingMethodCellar,
  utilization AS ColltrlRealEstateUtilization,
  part_desc AS ColltrlREPartDescription,
  comm_usage_pct AS ColltrlRECommlUsagePercent,
  other_usg_flg AS ColltrlREIsOtherUsagePossible,
  ref_obj_prt_guid AS ColltrlREReferencePartUUID,
  is_sub_ast_crea AS ColltrlREIsSubAssetCreated,
  useful_area AS ColltrlREUsableAreaSize,
  usbl_area_uom AS ColltrlREUsblAreaUoM,
  useful_area_ren AS ColltrlRERentedUsableAreaSize,
  usbl_ar_ren_uom AS ColltrlRERntdUsblAreaUoM,
  useful_vol AS ColltrlRealEstateUsableVolume,
  usbl_vol_uom AS ColltrlREUsblVolumeUoM,
  useful_vol_ren AS ColltrlRERentedUsableVolume,
  usbl_vl_ren_uom AS ColltrlRERntdUsblVolumeUoM,
  residential_area AS ColltrlREResidentialAreaSize,
  res_ar_uom AS ColltrlRERsdntlAreaUoM,
  secondary_area AS ColltrlRESecondaryAreaSize,
  sec_area_uom AS ColltrlRESecdryAreaUoM,
  other_area AS ColltrlREOtherAreaSize,
  oth_area_uom AS ColltrlREOthAreaUnitOfMeasure,
  no_prt_unit AS ColltrlRENumberOfBuildingPart,
  no_prt_unit_ren AS ColltrlRENmbrOfBldngPartRented,
  cons_start_date AS ColltrlREConstructionStartDate,
  permsn_appl_date AS ColltrlREPermissionAppliedDate,
  permsn_obtd_date AS ColltrlREPrmssnObtainedDate,
  occy_date AS ColltrlRealEstateOccupancyDate,
  comp_date AS ColltrlRECompletionDate,
  final_insp_date AS ColltrlREFinalInspectionDate,
  rent_amt_planned AS ColltrlRERsdntlPlndRentAmount,
  rent_amt_actual AS ColltrlRERsdntlActlRentAmount,
  rent_plan_curr AS ColltrlRERsdntlPlndRentCrcy,
  rent_act_curr AS ColltrlRERsdntlActlRentCrcy,
  base_period AS ColltrlREResidentialBasePeriod,
  base_measure AS ColltrlRERsdntlBaseMeasure,
  vacant_posn_pct AS ColltrlRERsdntlVacancyPercent,
  res_rent_ind AS ColltrlREResidentialRentType,
  comp_rent_res AS ColltrlRERsdntlComparRentAmt,
  com_ren_res_curr AS ColltrlRERsdntlComparRentCrcy,
  land_area AS ColltrlRealEstateLandAreaSize,
  land_area_uom AS ColltrlRELandAreaUnitOfMeasure,
  land_area_ren AS ColltrlRERentedLandAreaSize,
  land_ar_ren_uom AS ColltrlRERntdLandAreaUoM,
  no_of_units AS ColltrlRealEstateNumberOfUnits,
  no_of_floors AS ColltrlRENumberOfFloors,
  no_garages AS ColltrlRENumberOfGarages,
  no_garages_ren AS ColltrlRENumberOfGaragesRented,
  no_park_unit AS ColltrlRENumberOfParking,
  no_park_unit_ren AS ColltrlRENumberOfParkingRented,
  no_park_ug AS ColltrlRENmbrOfUndrGrndParking,
  no_park_ug_ren AS ColltrlRENrOfUndrGrndPrkngRntd,
  no_cur_units AS ColltrlRENumberOfCurrentUnits,
  no_cur_units_ren AS ColltrlRENmbrOfCurUnitsRented,
  no_old_units AS ColltrlRENumberOfOldUnits,
  no_old_units_ren AS ColltrlRENmbrOfOldUnitsRented,
  no_new_units AS ColltrlRENumberOfNewUnits,
  no_new_units_ren AS ColltrlRENmbrOfNewUnitsRented,
  no_access_str AS ColltrlRENrOfAccessStructures,
  no_sale_level AS ColltrlRENumberOfSaleLevel,
  no_of_rooms AS ColltrlRealEstateNumberOfRooms,
  no_of_beds AS ColltrlRealEstateNumberOfBeds,
  comm_env_desc AS ColltrlRECommlEnvrmtDesc,
  access_str_desc AS ColltrlREAccStrucDescription,
  bld_section_desc AS ColltrlREBldngSctnDescription,
  price_category AS ColltrlRealEstatePriceCategory,
  avg_price AS ColltrlREDailyAvgPriceAmount,
  avg_price_curr AS ColltrlREDailyAvgPriceCurrency,
  occupancy_pct AS ColltrlREOccupancyPercent,
  turnover_amt AS ColltrlRETurnoverAmount,
  turnover_curr AS ColltrlRETurnoverCurrency,
  rental_agmt_typ AS ColltrlRERentalAgreementType,
  last_report_date AS ColltrlRECnstrctnLastRptDate,
  bld_progress_amt AS ColltrlREBldngProgressAmount,
  bld_amt_curr AS ColltrlREBldngProgressCurrency,
  pct_completed AS ColltrlREBldngCompltnPercent,
  insurance_type AS ColltrlRealEstateInsuranceType,
  insurance_amt AS ColltrlREInsuranceAmount,
  insurance_curr AS ColltrlREInsuranceCurrency,
  ins_validity AS ColltrlREInsuranceValidToDate,
  rationing_cost AS ColltrlRERsdntlRatnCostAmount,
  rtn_cst_pct AS ColltrlRERsdntlRatnCostPercent,
  ext_layout_cost AS ColltrlREExtLayoutCostAmount,
  ext_lay_cst_pct AS ColltrlREExtLayoutCostPercent,
  rtn_cst_curr AS ColltrlRERsdntlRatnCostCrcy,
  ext_rtn_cst_curr AS ColltrlREExtLayoutCostCurrency,
  rtn_cst_com AS ColltrlRECommlRationCostAmount,
  rtn_cst_com_curr AS ColltrlRECommlRatnCostCurrency,
  rtn_cst_com_pct AS ColltrlRECommlRatnCostPercent,
  gross_cold_rent AS ColltrlREGrossColdRentAmount,
  gross_rent_curr AS ColltrlREGrossColdRentCurrency,
  net_cold_rent AS ColltrlRENetColdRentAmount,
  net_rent_curr AS ColltrlRENetColdRentCurrency,
  created_by AS CollateralRealEstateEnteredBy,
  created_date AS ColltrlRealEstateEnteredDate,
  created_time AS ColltrlRealEstateEnteredTime,
  entry_src AS ColltrlRealEstateEnteredSource,
  last_chg_by AS ColltrlRealEstateLastChangedBy,
  last_chg_date AS ColltrlRELastChangedDate,
  last_chg_time AS ColltrlRELastChangedTime,
  processing_src AS ColltrlRELastChangedSource,
  no_of_years_com AS ColRECommlNmbrOfYrsLastValn,
  int_rate_com AS ColltrlRECommlValnInterestRate,
  no_of_years AS ColltrlRERsdntlLastValnNrOfYrs,
  int_rate AS ColltrlRERsdntlValnIntrstRate,
  rent_planned_com AS ColltrlRECommlPlndRentAmount,
  rent_actual_com AS ColltrlRECommlActualRentAmount,
  plan_curr_com AS ColltrlRECommlPlndRentCurrency,
  act_curr_com AS ColltrlRECommlActlRentCurrency,
  base_period_com AS ColltrlRECommercialBasePeriod,
  base_meas_com AS ColltrlRECommercialBaseMeasure,
  com_rent_ind AS ColltrlRECommercialRentType,
  comp_rent_com AS ColltrlRECommlComparRentAmount,
  comp_ren_com_cur AS ColltrlRECommlComparRentCrcy,
  plan_rent_land AS ColltrlRELandPlannedRentAmount,
  actual_rent_land AS ColltrlRELandActualRentAmount,
  plan_rent_curr AS ColltrlRELandPlndRentCurrency,
  actual_rent_curr AS ColltrlRELandActlRentCurrency,
  base_period_land AS ColltrlRELandRentBasePeriod,
  base_meas_land AS ColltrlRELandRentBaseMeasure,
  depr AS ColltrlREDepreciationPercent,
  land_cost AS ColltrlRELandCostAmount,
  land_cost_curr AS ColltrlRELandCostCurrency,
  dev_cost AS ColltrlREDevelopmentCostAmount,
  dev_cost_curr AS ColltrlREDevCostCurrency,
  land_cst_base AS ColltrlRELandCostBaseMeasure,
  dev_cst_base AS ColltrlREDevCostBaseMeasure,
  add_land_cst AS ColltrlREAddlLandCostAmount,
  add_cst_curr AS ColltrlREAddlLandCostCurrency,
  add_cst_base AS ColltrlREAddlLandCostBaseMsr,
  const_cost AS ColltrlRECnstrctnCostAmount,
  const_cost_curr AS ColltrlRECnstrctnCostCurrency,
  base_meas AS ColltrlRECnstrctnCostBaseMsr,
  grs_profit AS ColltrlREYrlyGrssProfitAmt,
  grs_profit_curr AS ColltrlREYrlyGrssProfitCrcy
FROM cms_re_obj_prt
LEFT OUTER JOIN I_CollateralRealEstatePart AS _CollateralRealEstatePart ON CollateralRealEstatePartUUID = _CollateralRealEstatePart.CollateralRealEstatePartUUID  -- association [0..1]
LEFT OUTER JOIN I_CollateralRealEstate AS _CollateralRealEstate ON CollateralRealEstateUUID = _CollateralRealEstate.CollateralRealEstateUUID  -- association [0..1]
LEFT OUTER JOIN I_CollateralRealEstateMaster AS _CollateralRealEstateMaster ON CollateralRealEstateUUID = _CollateralRealEstateMaster.CollateralRealEstateUUID  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREPartAccessory AS _ColltrlREPartAccessory ON CollateralRealEstatePartUUID = _ColltrlREPartAccessory.CollateralRealEstatePartUUID  -- association [0..*]
LEFT OUTER JOIN I_ColltrlREPartAccessoryMaster AS _ColltrlREPartAccessoryMaster ON CollateralRealEstatePartUUID = _ColltrlREPartAccessoryMaster.CollateralRealEstatePartUUID  -- association [0..*]
LEFT OUTER JOIN I_ColltrlREPartPartner AS _ColltrlREPartPartner ON CollateralRealEstatePartUUID = _ColltrlREPartPartner.CollateralRealEstatePartUUID  -- association [0..*]
LEFT OUTER JOIN I_CollateralRealEstatePartCost AS _CollateralRealEstatePartCost ON CollateralRealEstatePartUUID = _CollateralRealEstatePartCost.CollateralRealEstatePartUUID  -- association [0..*]
LEFT OUTER JOIN I_ColltrlREPartValue AS _ColltrlREPartValue ON CollateralRealEstatePartUUID = _ColltrlREPartValue.CollateralRealEstatePartUUID  -- association [0..*]
LEFT OUTER JOIN I_ColltrlRELandRegister AS _ColltrlRELandRegister ON CollateralRealEstatePartUUID = _ColltrlRELandRegister.CollateralRealEstatePartUUID  -- association [0..*]
LEFT OUTER JOIN I_ColltrlREUsageType AS _ColltrlREUsageType ON ColltrlREMainUsageType = _ColltrlREUsageType.CollateralRealEstateUsageType  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREUsageType AS _ColltrlREUsageType1 ON ColltrlREAdditionalUsageType1 = _ColltrlREUsageType1.CollateralRealEstateUsageType  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREUsageType AS _ColltrlREUsageType2 ON ColltrlREAdditionalUsageType2 = _ColltrlREUsageType2.CollateralRealEstateUsageType  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREUtilization AS _ColltrlREUtilization ON ColltrlRealEstateUtilization = _ColltrlREUtilization.ColltrlRealEstateUtilization  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ColltrlREUsblAreaUoM ON ColltrlREUsblAreaUoM = _ColltrlREUsblAreaUoM.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ColltrlRERntdUsblAreaUoM ON ColltrlRERntdUsblAreaUoM = _ColltrlRERntdUsblAreaUoM.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ColltrlREUsblVolumeUoM ON ColltrlREUsblVolumeUoM = _ColltrlREUsblVolumeUoM.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ColltrlRERntdUsblVolumeUoM ON ColltrlRERntdUsblVolumeUoM = _ColltrlRERntdUsblVolumeUoM.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ColltrlRERsdntlAreaUoM ON ColltrlRERsdntlAreaUoM = _ColltrlRERsdntlAreaUoM.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ColltrlRESecdryAreaUoM ON ColltrlRESecdryAreaUoM = _ColltrlRESecdryAreaUoM.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ColltrlREOthAreaUnitOfMeasure ON ColltrlREOthAreaUnitOfMeasure = _ColltrlREOthAreaUnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ColltrlRELandAreaUoM ON ColltrlRELandAreaUnitOfMeasure = _ColltrlRELandAreaUoM.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ColltrlRERntdLandAreaUoM ON ColltrlRERntdLandAreaUoM = _ColltrlRERntdLandAreaUoM.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlRERsdntlPlndRentCrcy ON ColltrlRERsdntlPlndRentCrcy = _ColltrlRERsdntlPlndRentCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlRERsdntlActlRentCrcy ON ColltrlRERsdntlActlRentCrcy = _ColltrlRERsdntlActlRentCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlRERsdntlComparRentCrcy ON ColltrlRERsdntlComparRentCrcy = _ColltrlRERsdntlComparRentCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlREDailyAvgPrcCurrency ON ColltrlREDailyAvgPriceCurrency = _ColltrlREDailyAvgPrcCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlRETurnoverCurrency ON ColltrlRETurnoverCurrency = _ColltrlRETurnoverCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlREBldngPrgrsCurrency ON ColltrlREBldngProgressCurrency = _ColltrlREBldngPrgrsCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlREInsuranceCurrency ON ColltrlREInsuranceCurrency = _ColltrlREInsuranceCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlRERsdntlRatnCostCrcy ON ColltrlRERsdntlRatnCostCrcy = _ColltrlRERsdntlRatnCostCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlREExtLaytCostCrcy ON ColltrlREExtLayoutCostCurrency = _ColltrlREExtLaytCostCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlRECommlRatnCostCrcy ON ColltrlRECommlRatnCostCurrency = _ColltrlRECommlRatnCostCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlREGrssColdRentCrcy ON ColltrlREGrossColdRentCurrency = _ColltrlREGrssColdRentCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlRENetColdRentCurrency ON ColltrlRENetColdRentCurrency = _ColltrlRENetColdRentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlRECommlPlndRentCrcy ON ColltrlRECommlPlndRentCurrency = _ColltrlRECommlPlndRentCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlRECommlActlRentCrcy ON ColltrlRECommlActlRentCurrency = _ColltrlRECommlActlRentCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlRECommlComparRentCrcy ON ColltrlRECommlComparRentCrcy = _ColltrlRECommlComparRentCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlRELandPlndRentCurrency ON ColltrlRELandPlndRentCurrency = _ColltrlRELandPlndRentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlRELandActlRentCurrency ON ColltrlRELandActlRentCurrency = _ColltrlRELandActlRentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlRELandCostCurrency ON ColltrlRELandCostCurrency = _ColltrlRELandCostCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlREDevCostCurrency ON ColltrlREDevCostCurrency = _ColltrlREDevCostCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlREAddlLandCostCurrency ON ColltrlREAddlLandCostCurrency = _ColltrlREAddlLandCostCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlRECnstrctnCostCurrency ON ColltrlRECnstrctnCostCurrency = _ColltrlRECnstrctnCostCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlREYrlyGrssProfitCrcy ON ColltrlREYrlyGrssProfitCrcy = _ColltrlREYrlyGrssProfitCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREBasePeriod AS _ColltrlRERsdntlBasePeriod ON ColltrlREResidentialBasePeriod = _ColltrlRERsdntlBasePeriod.CollateralRealEstateBasePeriod  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREBasePeriod AS _ColltrlRECommercialBasePeriod ON ColltrlRECommercialBasePeriod = _ColltrlRECommercialBasePeriod.CollateralRealEstateBasePeriod  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREBasePeriod AS _ColltrlRELandRentBasePeriod ON ColltrlRELandRentBasePeriod = _ColltrlRELandRentBasePeriod.CollateralRealEstateBasePeriod  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREBaseMeasure AS _ColltrlRERsdntlBaseMeasure ON ColltrlRERsdntlBaseMeasure = _ColltrlRERsdntlBaseMeasure.ColltrlRealEstateBaseMeasure  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREBaseMeasure AS _ColltrlRECommlBaseMeasure ON ColltrlRECommercialBaseMeasure = _ColltrlRECommlBaseMeasure.ColltrlRealEstateBaseMeasure  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREBaseMeasure AS _ColltrlRELandRentBaseMeasure ON ColltrlRELandRentBaseMeasure = _ColltrlRELandRentBaseMeasure.ColltrlRealEstateBaseMeasure  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREBaseMeasure AS _ColltrlRECnstrctnCostBaseMsr ON ColltrlRECnstrctnCostBaseMsr = _ColltrlRECnstrctnCostBaseMsr.ColltrlRealEstateBaseMeasure  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _ColltrlREBuildingPartType ON ColltrlREBuildingPartType = _ColltrlREBuildingPartType.CollateralAttributeIndType AND _ColltrlREBuildingPartType.CollateralAttributeIndCat = 'REO006'  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _ColltrlREPartCondition ON ColltrlRealEstatePartCondition = _ColltrlREPartCondition.CollateralAttributeIndType AND _ColltrlREPartCondition.CollateralAttributeIndCat = 'REO001'  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _ColltrlREBuildingMethodRoof ON ColltrlREBuildingMethodRoof = _ColltrlREBuildingMethodRoof.CollateralAttributeIndType AND _ColltrlREBuildingMethodRoof.CollateralAttributeIndCat = 'REO007'  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _ColltrlREBuildingMethodBody ON ColltrlREBuildingMethodBody = _ColltrlREBuildingMethodBody.CollateralAttributeIndType AND _ColltrlREBuildingMethodBody.CollateralAttributeIndCat = 'REO008'  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _ColltrlREBuildingMethodCellar ON ColltrlREBuildingMethodCellar = _ColltrlREBuildingMethodCellar.CollateralAttributeIndType AND _ColltrlREBuildingMethodCellar.CollateralAttributeIndCat = 'REO009'  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _ColltrlREBldngSctnDescription ON ColltrlREBldngSctnDescription = _ColltrlREBldngSctnDescription.CollateralAttributeIndType AND _ColltrlREBldngSctnDescription.CollateralAttributeIndCat = 'REO015'  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _ColltrlREPriceCategory ON ColltrlRealEstatePriceCategory = _ColltrlREPriceCategory.CollateralAttributeIndType AND _ColltrlREPriceCategory.CollateralAttributeIndCat = 'REO013'  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _ColltrlRERentalAgreementType ON ColltrlRERentalAgreementType = _ColltrlRERentalAgreementType.CollateralAttributeIndType AND _ColltrlRERentalAgreementType.CollateralAttributeIndCat = 'REO014'  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _ColltrlREInsuranceType ON ColltrlRealEstateInsuranceType = _ColltrlREInsuranceType.CollateralAttributeIndType AND _ColltrlREInsuranceType.CollateralAttributeIndCat = 'REO011'  -- association [0..1]
;