P_MfgOrderAORList

@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Orders 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_MfgOrderAORList as
   select from I_PPAreaOfResponsibility as _AOR  // I_MfgOrderOperationCompCube

   inner join I_LogisticsOrder as _OrderBasic on _OrderBasic.Plant = _AOR.Plant
                                             and _OrderBasic.ProductionSupervisor = ''
                                             and _OrderBasic.OrderCategory = '10'
   {
        key _OrderBasic.OrderID    // _OrderBasic.ObjectInternalID

   }
   where _AOR.ProductionSupervisor is initial and _AOR.WorkCenterInternalID is initial

union

   select from I_PPAreaOfResponsibility as _AOR
   inner join I_LogisticsOrder as _Orders on _Orders.Plant = _AOR.Plant
                                         and _Orders.ProductionSupervisor = _AOR.ProductionSupervisor
                                         and _Orders.OrderCategory = '10'

   {
       key _Orders.OrderID    //  _Orders.ObjectInternalID

   }
   where _AOR.ProductionSupervisor is not initial and _AOR.WorkCenterInternalID is initial

union

   select from I_PPAreaOfResponsibility as _AOR
   inner join I_OrderOperationBasic as _OrderOperBasic on _OrderOperBasic.WorkCenterInternalID = _AOR.WorkCenterInternalID
                                                      and _OrderOperBasic.BillOfOperationsType <> 'R' and _OrderOperBasic.BillOfOperationsType <> '3'
   inner join I_LogisticsOrder      as _OrdersBasic    on _OrdersBasic.OrderInternalBillOfOperations = _OrderOperBasic.OrderInternalID
                                                      and _OrdersBasic.Plant = _AOR.Plant
                                                      and _OrdersBasic.OrderCategory = '10'
  {
   key _OrdersBasic.OrderID  //  _OrdersBasic.ObjectInternalID

  }
  where _AOR.ProductionSupervisor is initial and _AOR.WorkCenterInternalID is not initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LOGISTICSORDER",
"I_ORDEROPERATIONBASIC",
"I_PPAREAOFRESPONSIBILITY"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/