P_MfgOperAORList

@AccessControl.authorizationCheck: #NOT_REQUIRED
//@EndUserText.label: 'Operations matching the assigned AORs'

@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #MIXED}
@VDM.viewType:  #COMPOSITE
@VDM.private: true
@Metadata.ignorePropagatedAnnotations: true
define view entity P_MfgOperAORList as  
  select from I_OrderOperationBasic as list 
  left outer to one join I_LogisticsOrderBasic as ordAfko on ordAfko.OrderInternalID = list.OrderInternalID
  
  inner join I_OrderBasic          as ordAufk on ordAufk.OrderID = ordAfko.OrderID and ordAufk.OrderCategory = '10'
      
  left outer to one join I_PPAreaOfResponsibility as _AORPlant                on list.Plant = _AORPlant.Plant 
                                                                                and _AORPlant.ProductionSupervisor is initial 
                                                                                and _AORPlant.WorkCenterInternalID is initial 
                                                                                and ordAfko.ProductionSupervisor is initial
  left outer to one join I_PPAreaOfResponsibility as _AORSupervisor           on list.Plant                 = _AORSupervisor.Plant  
                                                                                and ordAfko.ProductionSupervisor = _AORSupervisor.ProductionSupervisor
                                                                                and _AORSupervisor.ProductionSupervisor is not initial 
                                                                                and ordAfko.ProductionSupervisor is not initial 
                                                                                and _AORSupervisor.WorkCenterInternalID is initial 
  left outer to one join I_PPAreaOfResponsibility as _AORWorkcenter           on list.Plant                = _AORWorkcenter.Plant  
                                                                                and list.WorkCenterInternalID = _AORWorkcenter.WorkCenterInternalID 
                                                                                and _AORWorkcenter.ProductionSupervisor is initial                                     
                                                                                and _AORWorkcenter.WorkCenterInternalID is not initial
                                                                                and list.WorkCenterInternalID is not initial 
{
     key list.OrderInternalID,
     key list.OrderOperationInternalID
     // AOR

//      case when _AORPlant.UserID            is not null then 'X' end as AORPlant,

//      case when _AORSupervisor.UserID       is not null then 'X' end as AORSupervisor,

//      case when _AORWorkcenter.UserID       is not null then 'X' end as AORWorkcenter

}
where ( _AORPlant.UserID is not null
 or _AORSupervisor.UserID is not null
 or _AORWorkcenter.UserID is not null ) 
// and ordAufk.OrderCategory = '10'