C_ChangeRecordObjPg

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_ChangeRecordObjPg.
-- 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: CCHGRECTP

CREATE VIEW C_ChangeRecordObjPg AS
SELECT
  ChangeRecord,
  ChangeRecordPriority,
  Document._ChangeRecordCategory.ChangeRecordCategory AS ChangeRecordCategory,
  Document._ChangeRecordCategory.ChgRecordIsUsingProcessRoute AS ChgRecordIsUsingProcessRoute,
  Document._ChangeRecordCategory.ChgRecordIsUsingCollaboration AS ChgRecordIsUsingCollaboration,
  Document._ChangeRecordCategory.ChgRecdCollaborationIsHidden AS ChgRecdCollaborationIsHidden,
  Document._ChangeRecordCategory.ChgRecdItemProcgStatusIsEnbld AS ChgRecdItemProcgStatusIsEnbld,
  Document._ChangeRecordCategory.ChgRecdIsProdnEngOpsRlvt AS ChgRecdIsProdnEngOpsRlvt,
  Document._ChangeRecordCategory.ChangeRecordPurposeType AS ChangeRecordPurposeType,
  Document._ChangeRecordCategory.ChangeRecordTypeDesc AS ChangeRecordTypeDesc,
  cast (' ' as /plmb/cr_id ) AS RootChangeRecord,
  cast (' ' as /iam/issue_type_desc ) AS RootChangeRecordTxt,
  cast( '00000000' as /plmb/created_on ) AS CreationDate,
  cast( '00000000' as /plmb/changed_on ) AS LastChangeDate,
  cast( '' as abap.char( 1333 ) ) AS ChgRecdItmRlvnceProcStsVal,
  cast( '' as abap.char( 1333 ) ) AS ChgRecdItmsAddAuthznVal,
  cast( '' as boolean ) AS AuthorizationFieldName,
  cast( '' as boolean ) AS DigitalSignUserIsAuthorized,
  cast ('' as boolean) AS IsBatchAnalyzable,
  cast ('' as boolean) AS IsEBOMAnalyzable,
  cast ('' as boolean) AS IsMBOMAnalyzable,
  cast ('' as boolean) AS IsRoutingAnalyzable,
  cast( '' as boolean ) AS ChgRecdIsOnPremise,
  cast( '' as boolean ) AS ChangeRecordHasMultipleItems,
  ChangeRecordPriority AS ChangeRecordHdrPriorityCode,
  ChgRecdHdrRsnForChgCode AS ChgRecdRsnForChgHdrCode,
  Document.ChangeRecordType AS ChangeRecordType,
  Document.ParentChangeRecordUUID AS ParentChangeRecordUUID,
  Document.RootChangeRecordUUID AS RootChangeRecordUUID,
  Document.ChgRecordDescriptionText AS ChgRecordDescriptionText,
  Document.ChangeRecordStatus AS ChangeRecordStatus,
  Document.ChangeNumber AS ChangeNumber,
  Document.AccessControlContext AS AccessControlContext,
  Document.CreatedByUser AS CreatedByUser,
  Document.CreationDateTime AS CreationDateTime,
  Document.LastChangedByUser AS LastChangedByUser,
  Document.LastChangeDateTime AS LastChangeDateTime,
  Document.ChangeRecordLifecycleStatus AS ChangeRecordLifecycleStatus,
  Document.ChgRecdDigitalSignatureStatus AS ChgRecdDigitalSignatureStatus,
  Document.ChgRecdInitiatedStatusAction AS ChgRecdInitiatedStatusAction,
  Document.Partner AS Partner,
  Document.ChgRecdExpectedCompletionDate AS ChgRecdExpectedCompletionDate,
  Document.ChgRecdEngEffectiveDate AS ChgRecdEngEffectiveDate,
  Document.ChgRecdMfgEffectiveDate AS ChgRecdMfgEffectiveDate,
  Document.ChgRecdAuthGroup AS ChgRecdAuthGroup,
  Document.ChgRecdPrflIdn AS ChgRecdPrflIdn,
  Document.ChgRecdChangeStatus AS ChgRecdChangeStatus,
  Document.ChangeRecordDetailDescription AS ChangeRecordDetailDescription,
  Document.ChangeRecordItemIsNotEditable AS ChangeRecordItemIsNotEditable,
  Document.ChangeRecordItmIsAddDelEnabled AS ChangeRecordItmIsAddDelEnabled,
  Document.ChangeRecordItemEditMode AS ChangeRecordItemEditMode,
  Document._LogAccMObjectTypeActive AS _LogAccMObjectTypeActive,
  Document._LogAccMObjectUserAuthzn AS _LogAccMObjectUserAuthzn,
  Document._LogAccMObjSecureIDAssgmt AS _LogAccMObjSecureIDAssgmt,
  _ChangeMaster.ChangeNumberStatus AS ChangeNumberStatus,
  _ChangeMaster.ChangeNumberValidFromDate AS ChangeNumberValidFromDate,
  _ChangeRecordContactPerson.AuthorizationGroup AS AuthorizationGroup,
  _ChangeRecordContactPerson.BusinessPartnerIsBlocked AS BusinessPartnerIsBlocked,
  _ChangeRecordContactPerson.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _ChangeRecordContactPerson.DataControllerSet AS DataControllerSet,
  _ChangeRecordContactPerson.DataController1 AS DataController1,
  _ChangeRecordContactPerson.DataController2 AS DataController2,
  _ChangeRecordContactPerson.DataController3 AS DataController3,
  _ChangeRecordContactPerson.DataController4 AS DataController4,
  _ChangeRecordContactPerson.DataController5 AS DataController5,
  _ChangeRecordContactPerson.DataController6 AS DataController6,
  _ChangeRecordContactPerson.DataController7 AS DataController7,
  _ChangeRecordContactPerson.DataController8 AS DataController8,
  _ChangeRecordContactPerson.DataController9 AS DataController9,
  _ChangeRecordContactPerson.DataController10 AS DataController10,
  _ChangeRecordParent.ParentChangeRecordUUID AS ParentObjectUUID,
  _ChangeRecordParent.ParentChangeRecord AS ParentChangeRecord,
  _ChangeRecordParent.ParentChgRecordDescriptionText AS ParentChgRecordDescriptionText,
  _ChangeRecordStatusColor.ChangeRecordStatusColor AS ChangeRecordStatusColor,
  _ChangeRecordType.ChangeRecordScenarioID AS ChangeRecordScenarioID,
  _ChgRecdRefObjVib.ChgRecdRefObjDocVisible AS ChgRecdRefObjDocVisible,
  _ChgRecdRefObjVib.ChgRecdRefObjMatlVisible AS ChgRecdRefObjMatlVisible,
  _ChgRecdRefObjVib.ChgRecdRefObjBOMVisible AS ChgRecdRefObjBOMVisible,
  _ChgRecdRefObjVib.ChgRecdRefObjBOMItemVisible AS ChgRecdRefObjBOMItemVisible,
  _ChgRecdRefObjVib.ChgRecdRefObjEngBOMVisible AS ChgRecdRefObjEngBOMVisible,
  _ChgRecdRefObjVib.ChgRecdRefObjMfgBOMVisible AS ChgRecdRefObjMfgBOMVisible,
  _ChgRecdRefObjVib.ChgRecdRefObjRoutingVisible AS ChgRecdRefObjRoutingVisible,
  _ChgRecdRefObjVib.ChgRecdRefObjProdnRtgVisible AS ChgRecdRefObjProdnRtgVisible,
  _ChgRecdRefObjVib.ChgRecdOrdSpcfcRtgRefIsVisible AS ChgRecdOrdSpcfcRtgRefIsVisible,
  _ChgRecdRefObjVib.ChgRecdRefObjPlngScpVisible AS ChgRecdRefObjPlngScpVisible,
  _ChgRecdRefObjVib.ChgRecdRefObjProdnOrderVisible AS ChgRecdRefObjProdnOrderVisible,
  _ChgRecdRefObjVib.ChgRecdRefObjPurOrderVisible AS ChgRecdRefObjPurOrderVisible,
  _ChgRecdRefObjVib.ChgRecdRefProdStrucVarVisible AS ChgRecdRefProdStrucVarVisible,
  _ChgRecdRefObjVib.ChgRecdRefObjSpecVisible AS ChgRecdRefObjSpecVisible,
  _ChgRecdRefObjVib.ChgRecdRefObjEngSnpshtVisible AS ChgRecdRefObjEngSnpshtVisible,
  _ChgRecdRefObjVib.ChgRecdRefObjMstrRcpVisible AS ChgRecdRefObjMstrRcpVisible,
  _ChgRecdRefObjVib.ChgRecdRefObjInspPlanVisible AS ChgRecdRefObjInspPlanVisible,
  _ChgRecdRefObjVib.ChgRecdRefObjRecipeVisible AS ChgRecdRefObjRecipeVisible,
  _ChgRecdRefObjVib.ChgRecdRefObjLabelVisible AS ChgRecdRefObjLabelVisible,
  _ChgRecdRefObjVib.ChgRecdRefObjPlngRtgVisible AS ChgRecdRefObjPlngRtgVisible,
  _ChgRecdRefObjVib.ChgRecdRefObjTmplRtgVisible AS ChgRecdRefObjTmplRtgVisible,
  _ChgRecdRefObjVib.ChgRecdRefObjOrderBOMVisible AS ChgRecdRefObjOrderBOMVisible,
  _ChgRecdRefObjVib.ChgRecdRefObjClassVisible AS ChgRecdRefObjClassVisible,
  _ChgRecdRefObjVib.ChgRecdRefObjCharcVisible AS ChgRecdRefObjCharcVisible,
  _ChgRecdRefObjVib.ChgRecdObjMaintTskListVisible AS ChgRecdObjMaintTskListVisible,
  _ChgRecdRefObjVib.ChgRecdObjStdBOMVisible AS ChgRecdObjStdBOMVisible,
  _ChgRecdRefObjVib.ChgRecdObjEquipTskListVisible AS ChgRecdObjEquipTskListVisible,
  _ChgRecdRefObjVib.ChgRecdObjWBSElmntBOMVisible AS ChgRecdObjWBSElmntBOMVisible,
  _ChgRecdRefObjVib.ChgRecdObjEquipBOMVisible AS ChgRecdObjEquipBOMVisible,
  _ChgRecdRefObjVib.ChgRecdObjFuncLocBOMVisible AS ChgRecdObjFuncLocBOMVisible,
  _ChgRecdRefObjVib.ChgRecdObjVarBOMVisible AS ChgRecdObjVarBOMVisible,
  _ChgRecdRefObjVib.ChgRecdRefRateRtgVisible AS ChgRecdRefRateRtgVisible,
  _ChgRecdRefObjVib.ChgRecdRateRtgVisible AS ChgRecdRateRtgVisible,
  _ChgRecdRefObjVib.ChgRecdRefCutPlngPrflVisible AS ChgRecdRefCutPlngPrflVisible,
  _ChgRecdRefObjVib.ChgRecdRefOpSetVisible AS ChgRecdRefOpSetVisible,
  _ChgRecdRefObjVib.ChgRecdFuncLocTskListVisible AS ChgRecdFuncLocTskListVisible,
  _ChgRecdRefObjVib.ChgRecdRefObjMfgSnpshtVisible AS ChgRecdRefObjMfgSnpshtVisible,
  _ChgRecdRefObjVib.ChgRecdRefObjETOVersBOMVisible AS ChgRecdRefObjETOVersBOMVisible,
  _ChgRecdRefObjVib.ChgRecdRefObjDefectVisible AS ChgRecdRefObjDefectVisible,
  _ChgRecdRefObjVib.ChgRecdRefObjNotifVisible AS ChgRecdRefObjNotifVisible,
  _ChgRecdRsnForChgTxt.ChgRecdHdrRsnForChgDesc AS ChgRecdHdrRsnForChgDesc,
  _ChgRecordChildIsMerge.ChangeRecordIsMerge AS ChangeRecordIsMerge,
  _ChgRecordChildIsMerge.ChangeRecordIsSplit AS ChangeRecordIsSplit,
  _ChgRecPrioTxt.ChangeRecordPriorityDesc AS ChangeRecordPriorityDesc,
  _CreatedByUserContactCard.FullName AS CreatedByUserFullName,
  _DigSignStatusText.ChgRecdDigSignStatusTxt AS ChgRecdDigSignStatusTxt,
  _LastChangedByUserContactCard.FullName AS LastChangedByUserFullName,
  _LifeCycleStatusText.ChangeRecordLifecycleStatusTxt AS ChangeRecordLifecycleStatusTxt,
  _PendingActionText.ChangeRecordStatusActionText AS ChangeRecordStatusActionText,
  _UserStatusVH.ChangeRecordStatusDescription AS ChangeRecordStatusDescription
FROM I_ChangeRecordDraftTP AS Document
LEFT OUTER JOIN C_ChangeRecordDescription AS _ChangeRecordDescriptionTP ON ChangeRecordUUID = _ChangeRecordDescriptionTP.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChangeRecordTypeVH AS _ChangeRecordTypeVH ON ChangeRecordType = _ChangeRecordTypeVH.ChangeRecordType AND ChangeRecordCategory = _ChangeRecordTypeVH.ChangeRecordCategory  -- association [0..1]
LEFT OUTER JOIN C_ChangeRecordTypeVH AS _ChangeRecordType ON ChangeRecordType = _ChangeRecordType.ChangeRecordType  -- association [0..1]
LEFT OUTER JOIN I_ChangeRecordAccCtrlCntxtVH AS _AccVH ON _AccVH.LogAccMContext = AccessControlContext  -- association [0..1]
LEFT OUTER JOIN C_ChangeRecdStatusVH AS _UserStatusVH ON ChangeRecordStatus = _UserStatusVH.ChangeRecordStatus  -- association [1..1]
LEFT OUTER JOIN C_ChangeRecordNextStatusVH AS _ChangeRecordNextStatusVH ON ChangeRecordType = _ChangeRecordNextStatusVH.ChangeRecordType AND ChangeRecordStatus = _ChangeRecordNextStatusVH.ChangeRecordStatus  -- association [0..*]
LEFT OUTER JOIN I_ChangeRecordContactPerson AS _ChangeRecordContactPerson ON Partner = _ChangeRecordContactPerson.Partner  -- association [0..1]
LEFT OUTER JOIN I_ChgRecLifecycleStatusTxt AS _LifeCycleStatusText ON ChangeRecordLifecycleStatus = _LifeCycleStatusText.ChangeRecordLifecycleStatus  -- association [0..1]
LEFT OUTER JOIN C_ChangeRecdDigSignStatusVH AS _DigSignStatusText ON ChgRecdDigitalSignatureStatus = _DigSignStatusText.ChgRecdDigitalSignatureStatus  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdUserStatusActionTxt AS _PendingActionText ON ChgRecdInitiatedStatusAction = _PendingActionText.ChgRecdInitiatedStatusAction AND _PendingActionText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_ChangeRecordObjPgMatl AS _ChangeRecordReferenceMatTP ON ChangeRecordUUID = _ChangeRecordReferenceMatTP.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChangeRecordObjPgBOM AS _ChangeRecordReferenceBOMTP ON ChangeRecordUUID = _ChangeRecordReferenceBOMTP.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChangeRecordObjPgBOMItm AS _ChangeRecordRefBOMItmTP ON ChangeRecordUUID = _ChangeRecordRefBOMItmTP.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChangeRecordObjPgEngBOM AS _ChgRecdRefEngBOMTP ON ChangeRecordUUID = _ChgRecdRefEngBOMTP.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChangeRecordObjPgMfgBOM AS _ChgRecdRefMfgBOMTP ON ChangeRecordUUID = _ChgRecdRefMfgBOMTP.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChangeRecordObjPgPurOrd AS _ChgRecdRefPurOrdTP ON ChangeRecordUUID = _ChgRecdRefPurOrdTP.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChangeRecordObjPgProdnOrd AS _ChgRecdRefProdnOrdTP ON ChangeRecordUUID = _ChgRecdRefProdnOrdTP.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChangeRecordObjPgPlngScp AS _ChgRecdRefPlngScpTP ON ChangeRecordUUID = _ChgRecdRefPlngScpTP.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChangeRecordObjPgRouting AS _ChgRecdRefRoutingTP ON ChangeRecordUUID = _ChgRecdRefRoutingTP.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChangeRecordObjPgOrdSpcfcRtg AS _ChgRecdRefOrdSpcfcRoutingTP ON ChangeRecordUUID = _ChgRecdRefOrdSpcfcRoutingTP.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChangeRecordObjPgDoc AS _ChangeRecordReferenceDocTP ON ChangeRecordUUID = _ChangeRecordReferenceDocTP.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChgRecdObjPgProdStrucVar AS _ChgRecdRefProdStrucVarTP ON ChangeRecordUUID = _ChgRecdRefProdStrucVarTP.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChangeRecordObjPgSpec AS _ChangeRecordReferenceSpecTP ON ChangeRecordUUID = _ChangeRecordReferenceSpecTP.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChangeRecordObjPgEngSnpsht AS _ChgRecdRefEngSnpshtTP ON ChangeRecordUUID = _ChgRecdRefEngSnpshtTP.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChangeRecordObjPgMasterRcp AS _ChgRecdRefMasterRecipeTP ON ChangeRecordUUID = _ChgRecdRefMasterRecipeTP.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChangeRecordObjPgInspPlan AS _ChgRecdRefInspectionPlanTP ON ChangeRecordUUID = _ChgRecdRefInspectionPlanTP.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChangeRecordObjPgRecipe AS _ChgRecdRefRecipeTP ON ChangeRecordUUID = _ChgRecdRefRecipeTP.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChangeRecdObjPgProdnRouting AS _ChgRecdRefProdnRoutingTP ON ChangeRecordUUID = _ChgRecdRefProdnRoutingTP.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChangeRecordObjPgLabel AS _ChgRecdRefLabelTP ON ChangeRecordUUID = _ChgRecdRefLabelTP.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChangeRecordObjPgPlngRouting AS _ChgRecdRefPlngRoutingTP ON ChangeRecordUUID = _ChgRecdRefPlngRoutingTP.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChangeRecordObjPgTmplRouting AS _ChgRecdRefTmplRoutingTP ON ChangeRecordUUID = _ChgRecdRefTmplRoutingTP.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChgRecdObjPgMaintTskList AS _ChgRecdRefMaintTskListTP ON ChangeRecordUUID = _ChgRecdRefMaintTskListTP.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChangeRecordObjPgMfgSnpsht AS _ChgRecdRefMfgSnpshtTP ON ChangeRecordUUID = _ChgRecdRefMfgSnpshtTP.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChangeMaster AS _ChangeMaster ON ChangeNumber = _ChangeMaster.ChangeNumber  -- association [0..1]
LEFT OUTER JOIN C_ChgRecdRefObjVisibility AS _ChgRecdRefObjVib ON ChangeRecordType = _ChgRecdRefObjVib.ChangeRecordType  -- association [0..1]
LEFT OUTER JOIN I_IssActyMgmtUserStatus1 AS _IssActyMgmtUserStatus ON ChangeRecordStatus = _IssActyMgmtUserStatus.IssActyMgmtUserStatus1  -- association [0..1]
LEFT OUTER JOIN C_ChangeRecordStatusProgress AS _ChangeRecordStatusProgress ON ChangeRecordUUID = _ChangeRecordStatusProgress.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdStatusColorConfign AS _ChangeRecordStatusColor ON ChangeRecordStatus = _ChangeRecordStatusColor.ChangeRecordStatus AND ChangeRecordType = _ChangeRecordStatusColor.ChangeRecordType  -- association [0..1]
LEFT OUTER JOIN C_ChangeRecordItemCount AS _ChangeRecordItemCount ON ChangeRecordUUID = _ChangeRecordItemCount.ParentChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChgRecdImpMgmtNavy AS _ChangeRecordImpNavigation ON ChangeRecordType = _ChangeRecordImpNavigation.ChangeRecordType  -- association [0..*]
LEFT OUTER JOIN C_ChgRecdCmntTop AS _ChgRecdCmntTopTP ON ChangeRecordUUID = _ChgRecdCmntTopTP.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChgRecdObjRefCmntTop AS _ChgRecdObjRefCmntTopTP ON ChangeRecordUUID = _ChgRecdObjRefCmntTopTP.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChangeRecordChildTP AS _ChgRecdChildTP ON _ChgRecdChildTP.ParentChangeRecordUUID = ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChgRecordChildVH AS _ChgRecordChildVH ON _ChgRecordChildVH.ChangeRecordUUID = ChangeRecordUUID  -- association [0..1]
LEFT OUTER JOIN C_ChgRecordChildVH AS _ChgRecordChildIsMerge ON _ChgRecordChildIsMerge.ChangeRecordUUID = ChangeRecordUUID  -- association [0..1]
LEFT OUTER JOIN C_ChangeRecordObjPgClfn AS _ChangeRecordObjPgClfn ON ChangeRecordUUID = _ChangeRecordObjPgClfn.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChangeRecordObjPgOrderBOM AS _ChangeRecordRefOrderBOMTP ON ChangeRecordUUID = _ChangeRecordRefOrderBOMTP.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChangeRecordObjPgCharc AS _ChangeRecordRefCharcTP ON ChangeRecordUUID = _ChangeRecordRefCharcTP.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChangeRecordObjPgClass AS _ChangeRecordRefClassTP ON ChangeRecordUUID = _ChangeRecordRefClassTP.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChgRecdRefStdBOM AS _ChangeRecordRefStdBOMTP ON ChangeRecordUUID = _ChangeRecordRefStdBOMTP.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChgRecdObjPgEquipTskList AS _ChgRecdRefEquipTskListTP ON ChangeRecordUUID = _ChgRecdRefEquipTskListTP.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChgRecdRefWBSElmntBOM AS _ChangeRecordRefWBSElmntBOMTP ON ChangeRecordUUID = _ChangeRecordRefWBSElmntBOMTP.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChgRecdRefEquipBOM AS _ChgRecdRefEquipBOMTP ON ChangeRecordUUID = _ChgRecdRefEquipBOMTP.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChgRecdRefRateRtgTskList AS _ChgRecdRefRateRtgTskListTP ON ChangeRecordUUID = _ChgRecdRefRateRtgTskListTP.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChgRecdObjRateRtgTskList AS _ChgRecdRateRtgTskListTP ON ChangeRecordUUID = _ChgRecdRateRtgTskListTP.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChgRecdRefCutPlngPrfl AS _ChgRecdRefCutPlngPrflTP ON ChangeRecordUUID = _ChgRecdRefCutPlngPrflTP.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChgRecdRefOpSetTskList AS _ChgRecdRefOpSetTskListTP ON ChangeRecordUUID = _ChgRecdRefOpSetTskListTP.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChgRecdFuncLocTskList AS _ChgRecdFuncLocTskListTP ON ChangeRecordUUID = _ChgRecdFuncLocTskListTP.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChgRecdRefFuncLocBOM AS _ChgRecdRefFuncLocBOMTP ON ChangeRecordUUID = _ChgRecdRefFuncLocBOMTP.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChgRecdRefVarBOM AS _ChgRecdRefVarBOMTP ON ChangeRecordUUID = _ChgRecdRefVarBOMTP.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChangeRecordObjPgETOVersBOM AS _ChgRecdRefETOVersBOMTP ON ChangeRecordUUID = _ChgRecdRefETOVersBOMTP.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChangeRecordObjPgDefect AS _ChgRecdRefDefectTP ON ChangeRecordUUID = _ChgRecdRefDefectTP.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChgRecdObjPgNotification AS _ChgRecdRefNotificationTP ON ChangeRecordUUID = _ChgRecdRefNotificationTP.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChangeRecordDetPg AS _ChangeRecordDetPg ON ChangeRecordUUID = _ChangeRecordDetPg.ChangeRecordUUID  -- association [1..1]
LEFT OUTER JOIN I_ChgRecChildTP AS _ChangeRecordParent ON ChangeRecordUUID = _ChangeRecordParent.ChangeRecordUUID  -- association [0..1]
LEFT OUTER JOIN C_ChgRecdObjPgEngCollabn AS _ChgRecdObjPgEngCollabn ON ChangeRecordUUID = _ChgRecdObjPgEngCollabn.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChgRecdPLMEPDCollabn AS _ChgRecdObjPgPLMEPDCollabn ON ChangeRecordUUID = _ChgRecdObjPgPLMEPDCollabn.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN C_ChangeRecordPriorityText AS _ChgRecPrioTxt ON ChangeRecordPriority = _ChgRecPrioTxt.ChangeRecordPriority AND ChangeRecordType = _ChgRecPrioTxt.ChangeRecordType  -- association [0..1]
LEFT OUTER JOIN C_ChgRecdRsnForChgText AS _ChgRecdRsnForChgTxt ON ChgRecdHdrRsnForChgCode = _ChgRecdRsnForChgTxt.ChgRecdHdrRsnForChgCode AND ChangeRecordType = _ChgRecdRsnForChgTxt.ChangeRecordType  -- association [0..1]
;