P_MfgOrderStatus

@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE
@VDM.private: true
// provides the non-aggregated status per order header (multiple lines per key!)

// to be used in aggregation views such as I_MfgOrderStatus only


define view entity P_MfgOrderStatus
    as select from I_MfgOrderBasic            as aufk
      inner join   I_StatusObjectActiveStatus as jest on jest.StatusObject = aufk.ObjectInternalID
    
  association [0..1] to I_StatusCode as _OrderIsCreatedCode          on  _OrderIsCreatedCode.StatusCode    = 'I0001'
                                                                     and _OrderIsCreatedCode.StatusProfile = jest.StatusProfile
  association [0..1] to I_StatusCode as _OrderIsReleasedCode         on  _OrderIsReleasedCode.StatusCode    = 'I0002'
                                                                     and _OrderIsReleasedCode.StatusProfile = jest.StatusProfile
  association [0..1] to I_StatusCode as _OrderHasMatlShortageCode    on  _OrderHasMatlShortageCode.StatusCode    = 'I0004'
                                                                     and _OrderHasMatlShortageCode.StatusProfile = jest.StatusProfile
  association [0..1] to I_StatusCode as _OrderIsPrintedCode          on  _OrderIsPrintedCode.StatusCode    = 'I0007'
                                                                     and _OrderIsPrintedCode.StatusProfile = jest.StatusProfile                                                                     
  association [0..1] to I_StatusCode as _OrderIsPrtlyPrintedCode     on  _OrderIsPrtlyPrintedCode.StatusCode    = 'I0008'
                                                                     and _OrderIsPrtlyPrintedCode.StatusProfile = jest.StatusProfile
  association [0..1] to I_StatusCode as _OrderIsConfirmedCode        on  _OrderIsConfirmedCode.StatusCode    = 'I0009'
                                                                     and _OrderIsConfirmedCode.StatusProfile = jest.StatusProfile
  association [0..1] to I_StatusCode as _OrderIsPrtlyConfirmedCode   on  _OrderIsPrtlyConfirmedCode.StatusCode    = 'I0010'
                                                                     and _OrderIsPrtlyConfirmedCode.StatusProfile = jest.StatusProfile
  association [0..1] to I_StatusCode as _OrderIsDeliveredCode        on  _OrderIsDeliveredCode.StatusCode    = 'I0012'
                                                                     and _OrderIsDeliveredCode.StatusProfile = jest.StatusProfile
  association [0..1] to I_StatusCode as _OrderIsDeletedCode          on  _OrderIsDeletedCode.StatusCode    = 'I0013'
                                                                     and _OrderIsDeletedCode.StatusProfile = jest.StatusProfile
  association [0..1] to I_StatusCode as _OrderIsProductCostedCode    on  _OrderIsProductCostedCode.StatusCode    = 'I0014'
                                                                     and _OrderIsProductCostedCode.StatusProfile = jest.StatusProfile
  association [0..1] to I_StatusCode as _OrderIsPreCostedCode        on  _OrderIsPreCostedCode.StatusCode    = 'I0016'
                                                                     and _OrderIsPreCostedCode.StatusProfile = jest.StatusProfile
  association [0..1] to I_StatusCode as _SettlmtRuleIsCreatedCode    on  _SettlmtRuleIsCreatedCode.StatusCode    = 'I0028'
                                                                     and _SettlmtRuleIsCreatedCode.StatusProfile = jest.StatusProfile
  association [0..1] to I_StatusCode as _OrderIsPrtlyReleasedCode    on  _OrderIsPrtlyReleasedCode.StatusCode    = 'I0042'
                                                                     and _OrderIsPrtlyReleasedCode.StatusProfile = jest.StatusProfile
  association [0..1] to I_StatusCode as _OrderIsLockedCode           on  _OrderIsLockedCode.StatusCode    = 'I0043'
                                                                     and _OrderIsLockedCode.StatusProfile = jest.StatusProfile
  association [0..1] to I_StatusCode as _OrderIsTechlyCmpltdCode     on  _OrderIsTechlyCmpltdCode.StatusCode    = 'I0045'
                                                                     and _OrderIsTechlyCmpltdCode.StatusProfile = jest.StatusProfile
  association [0..1] to I_StatusCode as _OrderIsClosedCode           on  _OrderIsClosedCode.StatusCode    = 'I0046'
                                                                     and _OrderIsClosedCode.StatusProfile = jest.StatusProfile
  association [0..1] to I_StatusCode as _OrderIsDistributionRlvtCode on  _OrderIsDistributionRlvtCode.StatusCode    = 'I0047'
                                                                     and _OrderIsDistributionRlvtCode.StatusProfile = jest.StatusProfile
  association [0..1] to I_StatusCode as _OrderIsDistrdToMESCode      on  _OrderIsDistrdToMESCode.StatusCode    = 'I0048'
                                                                     and _OrderIsDistrdToMESCode.StatusProfile = jest.StatusProfile
  association [0..1] to I_StatusCode as _OrderReleaseIsRejectedCode  on  _OrderReleaseIsRejectedCode.StatusCode    = 'I0055'
                                                                     and _OrderReleaseIsRejectedCode.StatusProfile = jest.StatusProfile
  association [0..1] to I_StatusCode as _OrderIsPrtlyDeliveredCode   on  _OrderIsPrtlyDeliveredCode.StatusCode    = 'I0074'
                                                                     and _OrderIsPrtlyDeliveredCode.StatusProfile = jest.StatusProfile
  association [0..1] to I_StatusCode as _OrderIsMrkdForDeletionCode  on  _OrderIsMrkdForDeletionCode.StatusCode    = 'I0076'
                                                                     and _OrderIsMrkdForDeletionCode.StatusProfile = jest.StatusProfile
  association [0..1] to I_StatusCode as _SettlmtRuleIsCrtedMnllyCode on  _SettlmtRuleIsCrtedMnllyCode.StatusCode    = 'I0102'
                                                                     and _SettlmtRuleIsCrtedMnllyCode.StatusProfile = jest.StatusProfile
  association [0..1] to I_StatusCode as _OrderHasCostCalcErrorCode   on  _OrderHasCostCalcErrorCode.StatusCode    = 'I0115'
                                                                     and _OrderHasCostCalcErrorCode.StatusProfile = jest.StatusProfile
  association [0..1] to I_StatusCode as _OrderIsScheduledCode        on  _OrderIsScheduledCode.StatusCode    = 'I0117'
                                                                     and _OrderIsScheduledCode.StatusProfile = jest.StatusProfile
  association [0..1] to I_StatusCode as _DistributionToMESCmpltdCode on  _DistributionToMESCmpltdCode.StatusCode    = 'I0168'
                                                                     and _DistributionToMESCmpltdCode.StatusProfile = ''
  association [0..1] to I_StatusCode as _OrderIsDiscardedByMESCode   on  _OrderIsDiscardedByMESCode.StatusCode    = 'I0169'
                                                                     and _OrderIsDiscardedByMESCode.StatusProfile = ''
  association [0..1] to I_StatusCode as _OrderIsReleasedByMESCode    on  _OrderIsReleasedByMESCode.StatusCode    = 'I0172'
                                                                     and _OrderIsReleasedByMESCode.StatusProfile = ''
  association [0..1] to I_StatusCode as _OrderHasPostdGoodsMvtCode   on  _OrderHasPostdGoodsMvtCode.StatusCode    = 'I0321'
                                                                     and _OrderHasPostdGoodsMvtCode.StatusProfile = jest.StatusProfile
  association [0..1] to I_StatusCode as _OrderHasGeneratedOpsCode    on  _OrderHasGeneratedOpsCode.StatusCode    = 'I0328'
                                                                     and _OrderHasGeneratedOpsCode.StatusProfile = jest.StatusProfile
  association [0..1] to I_StatusCode as _OrderIsHandledInBatchesCode  on _OrderIsHandledInBatchesCode.StatusCode    = 'I0369'
                                                                     and _OrderIsHandledInBatchesCode.StatusProfile = jest.StatusProfile
  association [0..1] to I_StatusCode as _MatlAvailyIsNotCheckedCode  on  _MatlAvailyIsNotCheckedCode.StatusCode    = 'I0420'
                                                                     and _MatlAvailyIsNotCheckedCode.StatusProfile = jest.StatusProfile
  association [0..1] to I_StatusCode as _OrderHasNoComponentsCode    on  _OrderHasNoComponentsCode.StatusCode    = 'I0485'
                                                                     and _OrderHasNoComponentsCode.StatusProfile = jest.StatusProfile
  association [0..1] to I_StatusCode as _OrderIsShopFloorOrderCode   on  _OrderIsShopFloorOrderCode.StatusCode    = 'I0665'
                                                                     and _OrderIsShopFloorOrderCode.StatusProfile = jest.StatusProfile
  association [0..1] to I_StatusCode as _OrderIsHandedOvrToProdnCode on  _OrderIsHandedOvrToProdnCode.StatusCode    = 'I0666'
                                                                     and _OrderIsHandedOvrToProdnCode.StatusProfile = jest.StatusProfile
  association [0..1] to I_StatusCode as _OrderChangeIsRestrictedCode on  _OrderChangeIsRestrictedCode.StatusCode    = 'I0667'
                                                                     and _OrderChangeIsRestrictedCode.StatusProfile = jest.StatusProfile
{
    // Technical Key

key aufk.ManufacturingOrder,

    aufk.ManufacturingOrderCategory,
    aufk.ManufacturingOrderType,
    aufk.ProductionPlant,
    aufk.ObjectInternalID,
    aufk.ObjectInternalID as ManufacturingObject,

    // Status

    case jest.StatusCode
      when 'I0001' then 'X'
      else ''
    end as OrderIsCreated,
    
    case jest.StatusCode
      when 'I0002' then 'X'
      else ''
    end as OrderIsReleased,

    case jest.StatusCode
      when 'I0004' then 'X'
      else ''
    end as OrderHasMaterialShortage,

    case jest.StatusCode
      when 'I0007' then 'X'
      else ''
    end as OrderIsPrinted,
    
    case jest.StatusCode
      when 'I0008' then 'X'
      else ''
    end as OrderIsPartiallyPrinted,
    
    case jest.StatusCode
      when 'I0009' then 'X'
      else ''
    end as OrderIsConfirmed,
    
     case jest.StatusCode
      when 'I0010' then 'X'
      else ''
    end as OrderIsPartiallyConfirmed,
    
    case jest.StatusCode
      when 'I0012' then 'X'
      else ''
    end as OrderIsDelivered,
    
    case jest.StatusCode
      when 'I0013' then 'X'
      else ''
    end as OrderIsDeleted,

    case jest.StatusCode
      when 'I0014' then 'X'
      else ''
    end as OrderIsProductCosted,

    case jest.StatusCode
      when 'I0016' then 'X'
      else ''
    end as OrderIsPreCosted,
    
    case jest.StatusCode
      when 'I0028' then 'X'
      else ''
    end as SettlementRuleIsCreated,
    
    case jest.StatusCode
      when 'I0042' then 'X'
      else ''
    end as OrderIsPartiallyReleased,
    
    case jest.StatusCode
      when 'I0043' then 'X'
      else ''
    end as OrderIsLocked,
    
    case jest.StatusCode
      when 'I0045' then 'X'
      else ''
    end as OrderIsTechnicallyCompleted,
    
    case jest.StatusCode
      when 'I0046' then 'X'
      else ''
    end as OrderIsClosed,

    case jest.StatusCode
      when 'I0047' then 'X'
      else ''
    end as OrderIsDistributionRelevant,

    case jest.StatusCode
      when 'I0048' then 'X'
      else ''
    end as OrderIsDistributedToMES,

    case jest.StatusCode
      when 'I0055' then 'X'
      else ''
    end as OrderReleaseIsRejected,

    case jest.StatusCode
      when 'I0074' then 'X'
      else ''
    end as OrderIsPartiallyDelivered,
    
    case jest.StatusCode
      when 'I0076' then 'X'
      else ''
    end as OrderIsMarkedForDeletion,
    
    case jest.StatusCode
      when 'I0102' then 'X'
      else ''
    end as SettlementRuleIsCrtedManually,

    case jest.StatusCode
      when 'I0115' then 'X'
      else ''
    end as OrderHasCostCalculationError,

    case jest.StatusCode
      when 'I0117' then 'X'
      else ''
    end as OrderIsScheduled,

    case jest.StatusCode
      when 'I0168' then 'X'
      else ''
    end as DistributionToMESIsCompleted,
    
    case jest.StatusCode
      when 'I0169' then 'X'
      else ''
    end as OrderIsDiscardedByMES,

    case jest.StatusCode
      when 'I0172' then 'X'
      else ''
    end as OrderIsReleasedByMES,

    case jest.StatusCode
      when 'I0321' then 'X'
      else ''
    end as OrderHasPostedGoodsMovements,
    
    case jest.StatusCode
      when 'I0328' then 'X'
      else ''
    end as OrderHasGeneratedOperations,
    
    case jest.StatusCode
      when 'I0369' then 'X'
      else ''
    end as OrderIsToBeHandledInBatches,
    
    case jest.StatusCode
      when 'I0420' then 'X'
      else ''
    end as MaterialAvailyIsNotChecked,
    
    case jest.StatusCode
      when 'I0485' then 'X'
      else ''
    end as OrderHasNoMaterialComponents,
    
    case jest.StatusCode
      when 'I0665' then 'X'
      else ''
    end as OrderIsShopFloorOrder,
    
    case jest.StatusCode
      when 'I0666' then 'X'
      else ''
    end as OrderIsHandedOverToProduction,
    
    case jest.StatusCode
      when 'I0667' then 'X'
      else ''
    end as OrderChangeIsRestricted,

    jest.StatusObject,
    jest.StatusCode,
    jest.StatusProfile,

    // Associations

    jest._StatusObject,
    jest._StatusCode,
    jest._StatusProfile,
    _OrderIsCreatedCode,
    _OrderIsReleasedCode,
    _OrderHasMatlShortageCode,
    _OrderIsPrintedCode,
    _OrderIsPrtlyPrintedCode, 
    _OrderIsConfirmedCode, 
    _OrderIsPrtlyConfirmedCode,
    _OrderIsDeliveredCode, 
    _OrderIsDeletedCode, 
    _OrderIsPreCostedCode,
    _OrderIsProductCostedCode,
    _SettlmtRuleIsCreatedCode, 
    _OrderIsPrtlyReleasedCode, 
    _OrderIsLockedCode,
    _OrderIsTechlyCmpltdCode,
    _OrderIsClosedCode,
    _OrderIsDistributionRlvtCode,
    _OrderIsDistrdToMESCode,
    _OrderReleaseIsRejectedCode,
    _OrderIsPrtlyDeliveredCode,
    _OrderIsMrkdForDeletionCode,
    _SettlmtRuleIsCrtedMnllyCode,
    _OrderHasCostCalcErrorCode,
    _OrderIsScheduledCode,
    _DistributionToMESCmpltdCode,
    _OrderIsDiscardedByMESCode,
    _OrderIsReleasedByMESCode,
    _OrderHasPostdGoodsMvtCode,
    _OrderHasGeneratedOpsCode,
    _OrderIsHandledInBatchesCode,
    _MatlAvailyIsNotCheckedCode,
    _OrderHasNoComponentsCode,
    _OrderIsShopFloorOrderCode,
    _OrderIsHandedOvrToProdnCode,
    _OrderChangeIsRestrictedCode
}
where
  (     jest.StatusCode = 'I0001'
    or  jest.StatusCode = 'I0002'
    or  jest.StatusCode = 'I0004'
    or  jest.StatusCode = 'I0007'
    or  jest.StatusCode = 'I0008'
    or  jest.StatusCode = 'I0009'
    or  jest.StatusCode = 'I0010'
    or  jest.StatusCode = 'I0012'
    or  jest.StatusCode = 'I0013'
    or  jest.StatusCode = 'I0014'
    or  jest.StatusCode = 'I0016'
    or  jest.StatusCode = 'I0028'
    or  jest.StatusCode = 'I0042'
    or  jest.StatusCode = 'I0043'
    or  jest.StatusCode = 'I0045'
    or  jest.StatusCode = 'I0046'
    or  jest.StatusCode = 'I0047'
    or  jest.StatusCode = 'I0048'
    or  jest.StatusCode = 'I0055'
    or  jest.StatusCode = 'I0074'
    or  jest.StatusCode = 'I0076'
    or  jest.StatusCode = 'I0102'
    or  jest.StatusCode = 'I0115'
    or  jest.StatusCode = 'I0117'
    or  jest.StatusCode = 'I0168'
    or  jest.StatusCode = 'I0169'
    or  jest.StatusCode = 'I0172'
    or  jest.StatusCode = 'I0321'
    or  jest.StatusCode = 'I0328'
    or  jest.StatusCode = 'I0369'
    or  jest.StatusCode = 'I0420'
    or  jest.StatusCode = 'I0485'
    or  jest.StatusCode = 'I0665'
    or  jest.StatusCode = 'I0666'
    or  jest.StatusCode = 'I0667'
  ) and jest.StatusObject like 'OR%';