采购接收事务处理接口表错误信息查询

SELECT HOU.ORGANIZATION_CODE  NAME
      ,PV.SEGMENT1            VENDOR_NUMBER
      ,RHA.INVOICE_NUM
      ,PHA.SEGMENT1           PO_NUMBER
      ,PLA.LINE_NUM
      ,PLLA.SHIPMENT_NUM
      ,RTI.QUANTITY
      ,PIE.ERROR_MESSAGE_NAME
      ,PIE.ERROR_MESSAGE
  FROM RCV_HEADERS_INTERFACE        RHA
      ,RCV_TRANSACTIONS_INTERFACE   RTI
      ,PO_INTERFACE_ERRORS          PIE
      ,PO_HEADERS_ALL               PHA
      ,PO_LINES_ALL                 PLA
      ,PO_LINE_LOCATIONS_ALL        PLLA
      ,PO_VENDORS                   PV
      ,ORG_ORGANIZATION_DEFINITIONS HOU
 WHERE RHA.HEADER_INTERFACE_ID = RTI.HEADER_INTERFACE_ID

   AND RTI.PROCESSING_STATUS_CODE = 'ERROR'
   AND RTI.INTERFACE_TRANSACTION_ID = PIE.INTERFACE_LINE_ID(+)
   AND RTI.PO_HEADER_ID = PHA.PO_HEADER_ID
   AND PHA.ORG_ID = HOU.OPERATING_UNIT
   AND PHA.VENDOR_ID = PV.VENDOR_ID
   AND RTI.PO_LINE_ID = PLA.PO_LINE_ID
   AND RTI.PO_LINE_LOCATION_ID = PLLA.LINE_LOCATION_ID
   AND RTI.GROUP_ID = 3106539