Pending transaction error info

忘了是在哪里的看到的了,不是自己写的,留作参考

alter session set current_schema=apps;
SELECT SUBSTR(poh.segment1, 1, 10) "PO Number",
       por.release_num "Release Num",
       pol.line_num "Line Num",
       rti.interface_transaction_id "Intf Trx Id",
       rti.creation_date "Creation Date",
       rti.transaction_date "Trx Date",
       rti.processing_mode_code "Proc Mode",
       rti.transaction_status_code "Trx Status",
       rti.processing_status_code "Proc Status",
       SUBSTR(pie.error_message, 1, 75) "Error Message",
       poh.org_id "Op Unit Id",
       rti.po_header_id "PO Hdr Id",
       rti.po_release_id "Rel Id",
       rti.po_line_id "PO Line Id",
       rti.po_line_location_id "Line Loc Id",
       rti.quantity "Intf Qty",
       poll.quantity "Order Qty",
       poll.quantity_received "Qty recvd",
       pod.quantity_delivered "Qty Delv",
       NVL(poll.closed_code, 'OPEN') "Closed Code",
       ood.organization_code "To Inv Org",
       rti.destination_type_code "Dest Type",
       rti.transaction_type "Intf Trx Type",
       NVL(poll.qty_rcv_exception_code, 'NONE') "Qty Exception",
       poll.qty_rcv_tolerance "Qty Tolerance",
       poll.receive_close_tolerance "Receipt Tolerance"
  FROM rcv_transactions_interface   rti,
       po_headers_all               poh,
       po_releases_all              por,
       po_lines_all                 pol,
       po_line_locations_all        poll,
       org_organization_definitions ood,
       po_distributions_all         pod,
       po_interface_errors          pie
 WHERE poh.po_header_id = rti.po_header_id
   AND por.po_release_id(+) = rti.po_release_id
   AND pol.po_line_id = rti.po_line_id
   AND ood.organization_id(+) = rti.to_organization_id
   AND poll.line_location_id = rti.po_line_location_id
   AND pod.line_location_id = poll.line_location_id
   AND rti.interface_transaction_id = pie.interface_line_id(+)
   and poh.segment1='600004768';