C_FrcElmntOrgTP

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 C_FrcElmntOrgTP.
-- 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.
-- SQL view name: CFEORGTP

CREATE VIEW C_FrcElmntOrgTP AS
SELECT
  FrcElmntOrgTP.ForceElementOrgID AS ForceElementOrgID,
  ForceElementOrgID AS ForceElementOrgIDForEdit,
  FrcElmntOrgTP.ForceElementOrgUUID AS ForceElementOrgUUID,
  FrcElmntOrgTP.NumberOfForceElementOrg AS NumberOfForceElementOrg,
  FrcElmntOrgTP.FrcElmntOrgPlanVersion AS FrcElmntOrgPlanVersion,
  FrcElmntOrgTP.FrcElmntOrgType AS FrcElmntOrgType,
  FrcElmntOrgTP.FrcElmntOrgStockPlant AS FrcElmntOrgStockPlant,
  FrcElmntOrgTP.FrcElmntOrgMRPStockArea AS FrcElmntOrgMRPStockArea,
  FrcElmntOrgTP.FrcElmntOrgIsAccountable AS FrcElmntOrgIsAccountable,
  FrcElmntOrgTP.FrcElmntOrgProvisionsPlant AS FrcElmntOrgProvisionsPlant,
  FrcElmntOrgTP.FrcElmntOrgProvisionStorageLoc AS FrcElmntOrgProvisionStorageLoc,
  FrcElmntOrgTP.FrcElmntOrgPrvsnMRPArea AS FrcElmntOrgPrvsnMRPArea,
  FrcElmntOrgTP.FrcElmntOrgIsStockHolding AS FrcElmntOrgIsStockHolding,
  FrcElmntOrgTP.FrcElmntOrgInitSupSts AS FrcElmntOrgInitSupSts,
  FrcElmntOrgTP.FrcElmntOrgPurgOrg AS FrcElmntOrgPurgOrg,
  FrcElmntOrgTP.FrcElmntOrgPurgGroup AS FrcElmntOrgPurgGroup,
  FrcElmntOrgTP.FrcElmntOrgStockStorageLoc AS FrcElmntOrgStockStorageLoc,
  FrcElmntOrgTP.FrcElmntOrgMatlRdnssPct AS FrcElmntOrgMatlRdnssPct,
  FrcElmntOrgTP.FrcElmntOrgPrsnlRdnssPct AS FrcElmntOrgPrsnlRdnssPct,
  FrcElmntOrgTP.FrcElmntOrgTrngRdnssPct AS FrcElmntOrgTrngRdnssPct,
  FrcElmntOrgTP.FrcElmntOrgPriority AS FrcElmntOrgPriority,
  FrcElmntOrgTP.FrcElmntOrgLogsLevel AS FrcElmntOrgLogsLevel,
  FrcElmntOrgTP.FrcElmntOrgInfrstrucPlant AS FrcElmntOrgInfrstrucPlant,
  FrcElmntOrgTP.FrcElmOrgInfrMRPArea AS FrcElmOrgInfrMRPArea,
  FrcElmntOrgTP.FrcElmOrgInfrStorLoc AS FrcElmOrgInfrStorLoc,
  FrcElmntOrgTP.FrcElmntOrgIsInfrstrucMaterial AS FrcElmntOrgIsInfrstrucMaterial,
  FrcElmntOrgTP.FrcElmntOrgLastChgdByUser AS FrcElmntOrgLastChgdByUser,
  FrcElmntOrgTP.FrcElmntOrgLastChgdDate AS FrcElmntOrgLastChgdDate,
  FrcElmntOrgTP.FrcElmntOrgCreatedByUser AS FrcElmntOrgCreatedByUser,
  FrcElmntOrgTP.FrcElmntOrgCreationDate AS FrcElmntOrgCreationDate,
  FrcElmntOrgTP.FrcElmntOrgLogicalSystem AS FrcElmntOrgLogicalSystem,
  FrcElmntOrgTP.FrcElmntOrgIsRefFrcElmntOrg AS FrcElmntOrgIsRefFrcElmntOrg,
  _FrcElmntOrgStrucTypeVH.FrcElmntOrgStrucTypeDesc AS FrcElmntOrgStrucTypeDesc,
  _FrcElmntOrgBrnchAdditionVH.FrcElmntOrgBranchAdditionDesc AS FrcElmntOrgBranchAdditionDesc,
  _FrcElmntOrgBrnchVH.FrcElmntOrgBranchName AS FrcElmntOrgBranchName,
  _FrcElmntOrgAreaVH.FrcElmntOrgAreaDesc AS FrcElmntOrgAreaDesc,
  _FrcElmntOrgSuplmntyVrtlElmnt.FrcElmntOrgValdtyStartDate AS FrcElmntOrgValdtyStartDate,
  _FrcElmntOrgSuplmntyVrtlElmnt.FrcElmntOrgValdtyEndDate AS FrcElmntOrgValdtyEndDate,
  _FrcElmntOrgSuplmntyVrtlElmnt.FrcElmntOrgName AS FrcElmntOrgName,
  _FrcElmntOrgSuplmntyVrtlElmnt.FrcElmntOrgShortName AS FrcElmntOrgShortName,
  _FrcElmntOrgSuplmntyVrtlElmnt.FrcElmntOrgPlngStatus AS FrcElmntOrgPlngStatus,
  _FrcElmntOrgSuplmntyVrtlElmnt.FrcElmntOrgPlngStatusName AS FrcElmntOrgPlngStatusName,
  _FrcElmntOrgUsageTypeVH.FrcElmntOrgUsageTypeDesc AS FrcElmntOrgUsageTypeDesc,
  _FrcElmntOrgSuplmntyVrtlElmnt.FrcElmntOrgLanguage AS FrcElmntOrgLanguage,
  _FrcElmntOrgSuplmntyVrtlElmnt._FrcElmntOrgSuplmntySymCode.FrcElmntOrgSymbol AS FrcElmntOrgSymbol,
  FrcElmntOrgNameForEdit,
  FrcElmntOrgShortNameForEdit,
  FrcElmntOrgValdtyStartDateFoEd,
  FrcElmntOrgValdtyEndDateFoEd,
  FrcElmntOrgCountryForEdit,
  FrcElmntOrgAreaForEdit,
  FrcElmntOrgStrucTypeForEdit,
  FrcElmntOrgBranchForEdit,
  FrcElmntOrgBranchAdditionFoEd,
  FrcElmntOrgIsAgencyForEdit,
  FrcElmntOrgUsageTypeForEdit,
  FrcElmntOrgStrucLevelForEdit,
  FrcElmntOrgAreaTypeForEdit,
  FrcElmntOrgAreaDescForEdit,
  FrcElmntOrgStrucParentID,
  FrcElmntOrgWarTimeParentID,
  FrcElmntOrgPeaceTimeParentID,
  FrcElmntOrgStrucValdtyStrtDte,
  FrcElmntOrgPeaceTmeStrtDte,
  FrcElmntOrgWarTmeValdtyStrtDte,
  FrcElmntOrgStrucValdtyEndDte,
  FrcElmntOrgPeaceTmeEndDte,
  FrcElmntOrgWarTmeValdtyEndDte,
  _FrcElmntOrgSuplmntyVrtlElmnt.FrcElmntOrgPlngStsCritlty AS FrcElmntOrgPlngStsCritlty,
  FrcElmntOrgTP.FrcElmntOrgMeasureUUID AS FrcElmntOrgMeasureUUID,
  FrcElmntOrgTP.FrcElmntOrgMeasureType AS FrcElmntOrgMeasureType,
  FrcElmntOrgTP.FrcElmntOrgMeasureDesc AS FrcElmntOrgMeasureDesc,
  FrcElmntOrgTP.DfsAssgmtValdtyStrtDate AS DfsAssgmtValdtyStrtDate,
  FrcElmntOrgTP.DfsAssgmtValdtyEndDate AS DfsAssgmtValdtyEndDate,
  _FrcElmntOrgMeasuresettings.DfsOrglMeasureDescription AS DfsOrglMeasureDescription,
  _FrcElmntOrgMeasuresettings.DfsOrglMeasureUUID AS DfsOrglMeasureUUID,
  _FrcElmntOrgMeasuresettings.CaseID AS CaseID,
  _FrcElmntOrgMeasuresettings.DfsOrglMsrEffectivenessDate AS DfsOrglMsrEffectivenessDate,
  _FrcElmntOrgMeasuresettings.DfsOrglMsrEffectivenessDate AS DfsMsrAreaEffectivenessDate,
  FrcElmntOrgTP.FrcElmntOrgRelationshipType AS FrcElmntOrgRelationshipType,
  FrcElmntOrgTP.FrcElmntOrgOplAssgmtParentID AS FrcElmntOrgOplAssgmtParentID,
  FrcElmntOrgTP.FrcElmntOrgOplAssgmtStartDate AS FrcElmntOrgOplAssgmtStartDate,
  FrcElmntOrgTP.FrcElmntOrgOplAssgmtEndDate AS FrcElmntOrgOplAssgmtEndDate,
  FrcElmntOrgTP.FrcElmntOrgExerAssgmtParentID AS FrcElmntOrgExerAssgmtParentID,
  FrcElmntOrgTP.FrcElmntOrgExerAssgmtStartDate AS FrcElmntOrgExerAssgmtStartDate,
  FrcElmntOrgTP.FrcElmntOrgExerAssgmtEndDate AS FrcElmntOrgExerAssgmtEndDate,
  cast( ' ' as boole_d preserving type) AS FrcElmntOrgIsOplForceElement,
  cast( ' ' as boole_d preserving type) AS FrcElmntOrgIsExerForceElement
FROM I_FrcElmntOrgTP AS FrcElmntOrgTP
LEFT OUTER JOIN C_FrcElmntOrgCharcsTP AS _FrcElmntOrgCharcsTP ON _FrcElmntOrgCharcsTP.ForceElementOrgID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntOrgDescriptionTP AS _FrcElmntOrgDescriptionTP ON _FrcElmntOrgDescriptionTP.ForceElementOrgID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntOrgNameTP AS _FrcElmntOrgNameTP ON _FrcElmntOrgNameTP.ForceElementOrgID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntOrgReadinessTP AS _FrcElmntOrgReadinessTP ON _FrcElmntOrgReadinessTP.ForceElementOrgID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntOrgReadinessLevelTP AS _FrcElmntOrgReadinessLevelTP ON _FrcElmntOrgReadinessLevelTP.ForceElementOrgID = ForceElementOrgID AND _FrcElmntOrgReadinessLevelTP.ForceElementOrgUUID = ForceElementOrgUUID  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgStrucRelshpTP AS _FrcElmntOrgStrucRelshpTP ON _FrcElmntOrgStrucRelshpTP.ForceElementOrgID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntOrgPeaceTmeRelshpTP AS _FrcElmntOrgPeaceTmeRelshpTP ON _FrcElmntOrgPeaceTmeRelshpTP.ForceElementOrgID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntOrgWarTmeRelshpTP AS _FrcElmntOrgWarTmeRelshpTP ON _FrcElmntOrgWarTmeRelshpTP.ForceElementOrgID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_DFS_AssgmtFeToSupFeList AS _AssgmtFeToSupFeList ON _AssgmtFeToSupFeList.ForceElementOrgSrceID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_DFS_AssgmtFeToSupByFeList AS _AssgmtFeToSupByFeList ON _AssgmtFeToSupByFeList.ForceElementOrgTargetID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_DFS_AssgmtFeToMaintFeList AS _AssgmtFeToMaintFeList ON _AssgmtFeToMaintFeList.ForceElementOrgSrceID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_DFS_AssgmtFeToMaintByFeList AS _AssgmtFeToMaintByFeList ON _AssgmtFeToMaintByFeList.ForceElementOrgTargetID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_DFS_AssgmtAccogPartHier AS _AssgmtFeToFlxMtPlObjHier ON _AssgmtFeToFlxMtPlObjHier.ForceElementOrgSrceID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_DFS_AssgmtFeToProdList AS _AssgmtFeToProdList ON _AssgmtFeToProdList.ForceElementOrgSrceID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_DFS_AssgmtFeToMsnEsnlTskList AS _AssgmtFeToMsnEsnlTskList ON _AssgmtFeToMsnEsnlTskList.ForceElementOrgSrceID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_DFS_AssgmtFeToCapbltObjList AS _AssgmtFeToCapbltObjList ON _AssgmtFeToCapbltObjList.ForceElementOrgSrceID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_DFS_AssgmtFeToMaintCapbltLi AS _AssgmtFeToMaintCapbltLi ON _AssgmtFeToMaintCapbltLi.ForceElementOrgSrceID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_DFS_AssgmtFrcToTechObjList AS _AssgmtFrcToTechObjList ON _AssgmtFrcToTechObjList.ForceElementOrgSrceID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_DFS_AssgmtFrcOpRotationList AS _AssgmtFrcOpRotationList ON _AssgmtFrcOpRotationList.ForceElementOrgSrceID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_DFS_AssgmtFrcExerRotList AS _AssgmtFrcExerRotList ON _AssgmtFrcExerRotList.ForceElementOrgSrceID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_DFS_AssgmtFrcOplPrvdrList AS _AssgmtFrcOplPrvdrList ON _AssgmtFrcOplPrvdrList.ForceElementOrgSrceID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_DFS_AssgmtFrcExerPrvdrList AS _AssgmtFrcExerPrvdrList ON _AssgmtFrcExerPrvdrList.ForceElementOrgSrceID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntOpStaffPrpslList AS _FrcElmntOpStaffPrpslList ON _FrcElmntOpStaffPrpslList.ForceElementOrgID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntExerStaffPrpslList AS _FrcElmntExerStaffPrpslList ON _FrcElmntExerStaffPrpslList.ForceElementOrgID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntOrgVH AS _FrcElmntOrgVH ON _FrcElmntOrgVH.ForceElementOrgID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntToPlantStorLocVH AS _FrcElmntStorLocVH ON _FrcElmntStorLocVH.ForceElementOrgID = ForceElementOrgID  -- association [0..1]
LEFT OUTER JOIN C_FrcElmntOrgWrkCtrVH AS _FrcElmntOrgWrkCtrVH ON _FrcElmntOrgWrkCtrVH.FrcElmntOrgRelatedOrgID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_DFS_FrcElmntToCapbltObjVH AS _FrcElmntToCapbltObjVH ON _FrcElmntToCapbltObjVH.ForceElementOrgID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_DFS_FrcElmntToFlxMtPlObjVH AS _FrcelmnttoFlxMtPlObjVH ON _FrcelmnttoFlxMtPlObjVH.ForceElementOrgID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_DFS_FrcElmntToSupByVH AS _FrcElmntToSupByVH ON _FrcElmntToSupByVH.ForceElementOrgID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_DFS_FrcElmntToSupVH AS _FrcElmntToSupVH ON _FrcElmntToSupVH.ForceElementOrgID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_DFS_FrcElmntToMaintByVH AS _FrcElmntToMaintByVH ON _FrcElmntToMaintByVH.ForceElementOrgID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_DFS_FrcElmntToMaintainsVH AS _FrcElmntToMaintainsVH ON _FrcElmntToMaintainsVH.ForceElementOrgID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntOrgVH AS _FrcElmntOrgNameVH ON _FrcElmntOrgNameVH.FrcElmntOrgName = frcelmntorgname  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntOrgVH AS _FrcElmntOrgStrucParentVH ON _FrcElmntOrgStrucParentVH.FrcElmntOrgStrucParentID = FrcElmntOrgStrucParentID AND _FrcElmntOrgStrucParentVH.FrcElmntOrgShortName = frcelmntorgshortname AND _FrcElmntOrgStrucParentVH.FrcElmntOrgName = frcelmntorgname AND _FrcElmntOrgStrucParentVH.ForceElementOrgIDForEdit = ForceElementOrgIDForEdit  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntOrgVH AS _FrcElmntOrgPeaceParentVH ON _FrcElmntOrgPeaceParentVH.FrcElmntOrgPeaceTimeParentID = FrcElmntOrgPeaceTimeParentID AND _FrcElmntOrgPeaceParentVH.FrcElmntOrgShortName = frcelmntorgshortname AND _FrcElmntOrgPeaceParentVH.FrcElmntOrgName = frcelmntorgname AND _FrcElmntOrgPeaceParentVH.ForceElementOrgIDForEdit = ForceElementOrgIDForEdit  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntOrgVH AS _FrcElmntOrgWarParentVH ON _FrcElmntOrgWarParentVH.FrcElmntOrgWarTimeParentID = FrcElmntOrgWarTimeParentID AND _FrcElmntOrgWarParentVH.FrcElmntOrgShortName = frcelmntorgshortname AND _FrcElmntOrgWarParentVH.FrcElmntOrgName = frcelmntorgname AND _FrcElmntOrgWarParentVH.ForceElementOrgIDForEdit = ForceElementOrgIDForEdit  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntOrgBrnchVH AS _FrcElmntOrgBrnchVH ON _FrcElmntOrgBrnchVH.FrcElmntOrgBranch = FrcElmntOrgBranchForEdit AND _FrcElmntOrgBrnchVH.FrcElmntOrgCountry = FrcElmntOrgCountryForEdit AND _FrcElmntOrgBrnchVH.FrcElmntOrgArea = FrcElmntOrgAreaForEdit  -- association [0..1]
LEFT OUTER JOIN C_FrcElmntOrgBrnchAdditionVH AS _FrcElmntOrgBrnchAdditionVH ON _FrcElmntOrgBrnchAdditionVH.FrcElmntOrgBranchAddition = FrcElmntOrgBranchAdditionFoEd AND _FrcElmntOrgBrnchAdditionVH.FrcElmntOrgCountry = FrcElmntOrgCountryForEdit AND _FrcElmntOrgBrnchAdditionVH.FrcElmntOrgBranch = FrcElmntOrgBranchForEdit AND _FrcElmntOrgBrnchAdditionVH.FrcElmntOrgArea = FrcElmntOrgAreaForEdit  -- association [0..1]
LEFT OUTER JOIN C_FrcElmntOrgUsageTypeVH AS _FrcElmntOrgUsageTypeVH ON _FrcElmntOrgUsageTypeVH.FrcElmntOrgUsageType = FrcElmntOrgUsageTypeForEdit  -- association [0..1]
LEFT OUTER JOIN C_FrcElmntOrgStrucTypeVH AS _FrcElmntOrgStrucTypeVH ON _FrcElmntOrgStrucTypeVH.FrcElmntOrgStrucType = FrcElmntOrgStrucTypeForEdit AND _FrcElmntOrgStrucTypeVH.FrcElmntOrgCountry = FrcElmntOrgCountryForEdit AND _FrcElmntOrgStrucTypeVH.FrcElmntOrgArea = FrcElmntOrgAreaForEdit AND _FrcElmntOrgStrucTypeVH.FrcElmntOrgStrucLevel = FrcElmntOrgStrucLevelForEdit  -- association [0..1]
LEFT OUTER JOIN C_FrcElmntOrgAreaVH AS _FrcElmntOrgAreaVH ON _FrcElmntOrgAreaVH.FrcElmntOrgArea = FrcElmntOrgAreaForEdit AND _FrcElmntOrgAreaVH.FrcElmntOrgCountry = FrcElmntOrgCountryForEdit AND _FrcElmntOrgAreaVH.FrcElmntOrgAreaType = FrcElmntOrgAreaTypeForEdit AND _FrcElmntOrgAreaVH.FrcElmntOrgAreaDesc = FrcElmntOrgAreaDescForEdit  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgCntryVH AS _FrcElmntOrgCntryVH ON _FrcElmntOrgCntryVH.FrcElmntOrgCountry = FrcElmntOrgCountryForEdit  -- association [0..1]
LEFT OUTER JOIN C_FrcElmntOrgWrkCtr AS _FrcElmntOrgWrkCtr ON _FrcElmntOrgWrkCtr.ForceElementOrgID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntOrgSuplmntyVrtlElmnt AS _FrcElmntOrgSuplmntyVrtlElmnt ON _FrcElmntOrgSuplmntyVrtlElmnt.ForceElementOrgID = ForceElementOrgID  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntToPosStrucRelshpList AS _FrcElmntToPosStrucRelshpList ON _FrcElmntToPosStrucRelshpList.DfsObjectID = ForceElementOrgIDForEdit  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntToPosWarRelshpList AS _FrcElmntToPosWarRelshpList ON _FrcElmntToPosWarRelshpList.DfsObjectRelatedObjectID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntToPosPeaceRelshpList AS _FrcElmntToPosPeaceRelshpList ON _FrcElmntToPosPeaceRelshpList.DfsObjectRelatedObjectID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN I_DFS_OrglMeasureUserSettings AS _FrcElmntOrgMeasuresettings ON _FrcElmntOrgMeasuresettings.ForceElementOrgID = ForceElementOrgID AND _FrcElmntOrgMeasuresettings.DfsIsOrglMeasureSelected = 'X'  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntToCostCtrRelshpList AS _FrcElmntToCostCtrRelshpList ON _FrcElmntToCostCtrRelshpList.DfsObjectID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntToCostCtrGrpRltnList AS _FrcElmntToCostCtrGrpRltnList ON _FrcElmntToCostCtrGrpRltnList.DfsObjectID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntToPrftCtrGrpRltnList AS _FrcElmntToPrftCtrGrpRltnList ON _FrcElmntToPrftCtrGrpRltnList.DfsObjectID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntToAccountAssgmtList AS _FrcElmntToAccountAssgmtList ON _FrcElmntToAccountAssgmtList.ForceElementOrgID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntToPrftCtrRelshpList AS _FrcElmntToPrftCtrRelshpList ON _FrcElmntToPrftCtrRelshpList.ForceElementOrgID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntToWBSElmntList AS _FrcElmntToWBSElmntList ON _FrcElmntToWBSElmntList.ForceElementOrgID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntToMasterWBSElement AS _FrcElmntToMasterWBSElement ON _FrcElmntToMasterWBSElement.ForceElementOrgID = ForceElementOrgID  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgLogisticsDataTP AS _FrcElmntOrgLogisticsDataTP ON _FrcElmntOrgLogisticsDataTP.ForceElementOrgID = ForceElementOrgID  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgOperationTP AS _FrcElmntOrgOperationTP ON _FrcElmntOrgOperationTP.ForceElementOrgID = ForceElementOrgID  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgExerciseTP AS _FrcElmntOrgExerciseTP ON _FrcElmntOrgExerciseTP.ForceElementOrgID = ForceElementOrgID  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgOpRotationTP AS _FrcElmntOrgOpRotationTP ON _FrcElmntOrgOpRotationTP.ForceElementOrgID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntOrgExerRotationTP AS _FrcElmntOrgExerRotationTP ON _FrcElmntOrgExerRotationTP.ForceElementOrgID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntOpExerCommandsList AS _FrcElmntOpExerCommandsList ON _FrcElmntOpExerCommandsList.ForceElementOrgID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntOperationRelshpList AS _FrcElmntOperationRelshpList ON _FrcElmntOperationRelshpList.ForceElementOrgID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntExerciseRelshpList AS _FrcElmntExerciseRelshpList ON _FrcElmntExerciseRelshpList.ForceElementOrgID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntOrgAddressTP AS _FrcElmntOrgAddressTP ON _FrcElmntOrgAddressTP.ForceElementOrgID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntOrgAddrWhereUsedList AS _FrcElmntOrgAddrWhereUsedList ON _FrcElmntOrgAddrWhereUsedList.ForceElementOrgID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntToOperationPosList AS _FrcElmntToOperationPosList ON _FrcElmntToOperationPosList.ForceElementOrgID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntToExercisePosList AS _FrcElmntToExercisePosList ON _FrcElmntToExercisePosList.ForceElementOrgID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntOrgAcctgAssgmtOvw AS _FrcElmntOrgAcctgAssgmtOvw ON _FrcElmntOrgAcctgAssgmtOvw.ForceElementOrgID = ForceElementOrgID  -- association [0..*]
LEFT OUTER JOIN C_FrcElmntOrgFundsDetails AS _FrcElmntOrgFundsDetails ON _FrcElmntOrgFundsDetails.ForceElementOrgID = ForceElementOrgID  -- association [0..1]
LEFT OUTER JOIN C_FrcElmntOrgInhtdMstrCostCtr AS _FrcElmntOrgInhtdMstrCostCtr ON _FrcElmntOrgInhtdMstrCostCtr.ForceElementOrgID = ForceElementOrgID  -- association [0..*]
LEFT OUTER JOIN C_FrcElmntOrgInhtdSupRelshp AS _FrcElmntOrgInhtdSupRelshp ON _FrcElmntOrgInhtdSupRelshp.ForceElementOrgID = ForceElementOrgID  -- association [0..*]
LEFT OUTER JOIN C_FrcElmntOpStaffAssgmtList AS _FrcElmntOpStaffAssgmtList ON _FrcElmntOpStaffAssgmtList.FrcElmntOrgRelatedOrgID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntExerStaffAssgmtList AS _FrcElmntExerStaffAssgmtList ON _FrcElmntExerStaffAssgmtList.FrcElmntOrgRelatedOrgID = ForceElementOrgID  -- association [1..*]
;