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_PPAreaOfResponsibility as AOR
  inner join I_OrderOperationBasic as _OrderOperBasic1  on _OrderOperBasic1.Plant = AOR.Plant
                                                        and _OrderOperBasic1.BillOfOperationsType <> 'R'
                                                        and _OrderOperBasic1.BillOfOperationsType <> '3'
  inner join I_LogisticsOrder      as _OrderBasic       on _OrderBasic.OrderInternalBillOfOperations = _OrderOperBasic1.OrderInternalID
                                                        and _OrderBasic.ProductionSupervisor = ''
                                                        and _OrderBasic.OrderCategory = '10'
{
     key _OrderOperBasic1.OrderInternalID,
     key _OrderOperBasic1.OrderOperationInternalID
}
where AOR.ProductionSupervisor is initial and AOR.WorkCenterInternalID is initial

union

select from I_PPAreaOfResponsibility as AOR1
inner join I_OrderOperationBasic as _OrderOperBasic2    on _OrderOperBasic2.Plant = AOR1.Plant
                                                        and _OrderOperBasic2.BillOfOperationsType <> 'R'
                                                        and _OrderOperBasic2.BillOfOperationsType <> '3'
inner join I_LogisticsOrder      as _Orders             on ( _Orders.ProductionSupervisor        = AOR1.ProductionSupervisor ) // or AOR1.ProductionSupervisor = '*' )

                                                        and _Orders.OrderInternalBillOfOperations = _OrderOperBasic2.OrderInternalID
                                                        and _Orders.OrderCategory = '10'
{
    key _OrderOperBasic2.OrderInternalID,
    key _OrderOperBasic2.OrderOperationInternalID
}
where  AOR1.ProductionSupervisor is not initial and AOR1.WorkCenterInternalID is initial

union

select from I_PPAreaOfResponsibility as AOR2
inner join I_OrderOperationBasic    as _OrderOperBasic  on _OrderOperBasic.Plant                = AOR2.Plant
                                                        and _OrderOperBasic.WorkCenterInternalID = AOR2.WorkCenterInternalID
                                                        and _OrderOperBasic.BillOfOperationsType <> 'R'
                                                        and _OrderOperBasic.BillOfOperationsType <> '3'
inner join I_LogisticsOrder         as _OrdersBasic     on _OrdersBasic.OrderInternalBillOfOperations = _OrderOperBasic.OrderInternalID
                                                        and _OrdersBasic.OrderCategory = '10'
{
    key _OrderOperBasic.OrderInternalID,
    key _OrderOperBasic.OrderOperationInternalID
}
where AOR2.ProductionSupervisor is initial and AOR2.WorkCenterInternalID is not initial