I_MaintOrdOpNotification

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Maintenance Order operation notifications'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #XL,
  dataClass: #MIXED
}
define view entity I_MaintOrdOpNotification
  as select from I_MaintOrderOperAndSubOper as OrderOpSubOp
  inner join  I_MaintOrderTechObj as _Order on _Order.MaintenanceOrder = OrderOpSubOp.MaintenanceOrder
  left outer to one join I_MaintOrdObjListDfltNotif as _ObjList1 on _Order.MaintenanceOrderObjectList = _ObjList1.MaintenanceOrderObjectList
                                                             and ( ( _ObjList1.TechnicalObject = OrderOpSubOp.Equipment and OrderOpSubOp.Equipment <> '' ) or
                                                                   ( _ObjList1.TechnicalObject = OrderOpSubOp.FunctionalLocation and OrderOpSubOp.Equipment = '' 
                                                                                                                                 and OrderOpSubOp.FunctionalLocation <> '' ) or
                                                                   ( _ObjList1.TechnicalObject = '' and OrderOpSubOp.FunctionalLocation = '' and OrderOpSubOp.Equipment = '') )
  left outer to one join I_MaintenanceOrderObjectList as _ObjList on _ObjList.MaintenanceOrderObjectList     = _ObjList1.MaintenanceOrderObjectList and
                                                                     _ObjList.MaintenanceOrderObjectListItem = _ObjList1.MaintenanceOrderObjectListItem
  association [0..1] to I_MaintNotificationTechObj as _MaintNotifTechObj on $projection.MaintenanceNotification = _MaintNotifTechObj.MaintenanceNotification
  association [0..1] to I_MaintenanceNotification     as _MaintenanceNotification    on  $projection.MaintenanceNotification = _MaintenanceNotification.MaintenanceNotification
  association [0..1] to I_MaintJobCtrlParamAggregator as _MaintJobControlParameter   on  _Order.MaintenanceOrderType     = _MaintJobControlParameter.MaintenanceOrderType
                                                                                     and _Order.MaintenancePlant         = _MaintJobControlParameter.Plant
//                                                                                   and _MaintJobControlParameter.MaintJobWrkItmCtrlParameter = '4'

{
  key OrderOpSubOp.MaintenanceOrder,
  key OrderOpSubOp.MaintenanceOrderOperation,
  key cast ( OrderOpSubOp.MaintenanceOrderSubOperation as maintenanceordersuboperation preserving type ) as  MaintenanceOrderSubOperation,
  cast( case when OrderOpSubOp.Equipment <> '' then OrderOpSubOp.Equipment
       when OrderOpSubOp.FunctionalLocation <> '' then OrderOpSubOp.FunctionalLocation
       else '' end as eams_tec_obj )as TechnicalObject ,
  _Order.MaintenanceOrderObjectList,
  OrderOpSubOp._MaintOrderOperObjectListLink._MaintenanceObjectListItem.MaintenanceObjectListItem as MaintenanceOrderObjectListItem,
//  _ObjList1.MaintenanceOrderObjectListItem,

  @Semantics.booleanIndicator: true
  _ObjList1.MaintNotifTechObjIsDefault,
//    case when OrderOpSubOp._MaintOrderOperObjectListLink._MaintenanceObjectListItem.MaintenanceNotification is not null //and

////              OrderOpSubOp._MaintOrderOperObjectListLink.MaintOrderRoutingNumber is not null

//    then OrderOpSubOp._MaintOrderOperObjectListLink._MaintenanceObjectListItem.MaintenanceNotification

//    //the below condition is commented since create notification functionality is reverted and header notification will be just displayed now

////    when ( _Order.TechnicalObject = $projection.TechnicalObject or $projection.TechnicalObject = '' ) and _Order.MaintenanceNotification <> ''

//    when _Order.MaintenanceNotification <> ''

//    then _Order.MaintenanceNotification

////    when OrderOpSubOp._MaintOrderOperObjectListLink._MaintenanceObjectListItem.MaintenanceNotification is null then

////    _ObjList.MaintenanceNotification

//    else '' end as MaintenanceNotification,

    
    case when _MaintJobControlParameter.MaintNotifCrtnIsAllowed = 'X'
           then ( case when OrderOpSubOp._MaintOrderOperObjectListLink._MaintenanceObjectListItem.MaintenanceNotification is not null and
                            OrderOpSubOp._MaintOrderOperObjectListLink.MaintOrderRoutingNumber is not null
                       then OrderOpSubOp._MaintOrderOperObjectListLink._MaintenanceObjectListItem.MaintenanceNotification
                       when ( _Order.TechnicalObject = $projection.TechnicalObject or $projection.TechnicalObject = '' ) and _Order.MaintenanceNotification <> ''
                       then _Order.MaintenanceNotification
                       when OrderOpSubOp._MaintOrderOperObjectListLink._MaintenanceObjectListItem.MaintenanceNotification is null then
                            _ObjList.MaintenanceNotification
                  else '' end )
     else _Order.MaintenanceNotification end                                                                                            as MaintenanceNotification,

    @Semantics.booleanIndicator: true
    case when OrderOpSubOp._MaintOrderOperObjectListLink._MaintenanceObjectListItem.MaintenanceNotification <> '' then 'X' else '' end as MaintOrdOpHasNotifAssigned,
    _MaintNotifTechObj,
    _MaintenanceNotification,
    OrderOpSubOp.OperationSupplier,
    OrderOpSubOp._Supplier,
    OrderOpSubOp.OperationPersonResponsible,
    OrderOpSubOp._PersonResponsible,
    OrderOpSubOp._MaintenanceOrder
} where
(
       OrderOpSubOp.MaintOrdOpProcessPhaseCode                                 = '07' //Execution

    or OrderOpSubOp.MaintOrdOpProcessPhaseCode                                 = '08' //Post Execution

    or OrderOpSubOp.MaintOrdOpProcessPhaseCode                                 = ''
  )