P_MfgOperationsList

@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_MfgOperationsList as  
  select from I_OrderOperationBasic as list   
  inner join I_LogisticsOrderBasic as ordAfko on ordAfko.OrderInternalID = list.OrderInternalID 
                                              and ordAfko.ProductionSupervisor = ''
  inner join I_OrderBasic          as ordAufk on ordAufk.OrderID = ordAfko.OrderID and ordAufk.OrderCategory = '10'    
//  inner join P_MfgOrdAorFinalList as orderBasic on orderBasic.OrderInternalBillOfOperations = list.OrderInternalID

//                                                and orderBasic.ProductionSupervisor = '' 

  inner join I_PPAreaOfResponsibility as AOR  on list.Plant = AOR.Plant                                      
                                      and AOR.ProductionSupervisor is initial 
                                      and AOR.WorkCenterInternalID is initial                  
{
     key list.OrderInternalID,
     key list.OrderOperationInternalID,
     AOR.Plant
}

union

//select from P_MfgAorOperList as list

//inner join P_MfgAorOrdList as AOR1  on list.OrderInternalID                 = AOR1.OrderInternalBillOfOperations 

//{

//    key list.OrderInternalID,

//    key list.OrderOperationInternalID

//}

select from I_OrderOperationBasic as list
inner join I_LogisticsOrderBasic as ordAfko on ordAfko.OrderInternalID = list.OrderInternalID 
//inner join P_MfgOrdAorFinalList as orderBasic on orderBasic.OrderInternalBillOfOperations = list.OrderInternalID

inner join I_PPAreaOfResponsibility as AOR1  on list.Plant                 = AOR1.Plant 
                                    and ordAfko.ProductionSupervisor = AOR1.ProductionSupervisor
                                    and AOR1.ProductionSupervisor is not initial 
                                    and ordAfko.ProductionSupervisor is not initial 
                                    and AOR1.WorkCenterInternalID is initial
inner join I_OrderBasic          as ordAufk on ordAufk.OrderID = ordAfko.OrderID and ordAufk.OrderCategory = '10'              
{
    key list.OrderInternalID,
    key list.OrderOperationInternalID,
    AOR1.Plant
//    list.ObjectInternalID

}
--where  AOR1.ProductionSupervisor is not initial and AOR1.WorkCenterInternalID is initial

union

select from I_OrderOperationBasic as list
inner join I_PPAreaOfResponsibility as AOR2   on list.Plant                = AOR2.Plant  
                                    and list.WorkCenterInternalID = AOR2.WorkCenterInternalID 
                                    and AOR2.ProductionSupervisor is initial                                     
                                    and AOR2.WorkCenterInternalID is not initial
                                    and list.WorkCenterInternalID is not initial
inner 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'                                 
{
    key list.OrderInternalID,
    key list.OrderOperationInternalID,
    AOR2.Plant
}