SCM 9

 SQL For SCM: OM: SQL Query To Find All Orders In ErroR in Oracle Cloud Fusion R13

 SQL For Errors reported for Orders entered from UI in Oracle Cloud Fusion R13

SELECT DISTINCT dha.creation_date,

        dha.source_order_number  ,

        DMT.message_text         ,

        DMB.message_type

FROM    fusion.doo_headers_all dha     ,

        FUSION.DOO_MESSAGE_ENTITIES DME,

        fusion.DOO_MESSAGES_B DMB      ,

        fusion.DOO_MESSAGES_TL DMT     ,

        fusion.DOO_MESSAGE_requests dmr

WHERE   dha.header_id          = DME.entity_id

        AND DME.entity_name    = 'ORDER'

        AND DMB.msg_request_id = DME.msg_request_id

        AND DMT.message_id     = DMB.message_id

        AND dmr.MSG_REQUEST_ID = DMB.MSG_REQUEST_ID

        AND dmr.ACTIVE_FLAG    = 'Y'

ORDER BY dha.creation_date DESC