忘了是在哪里的看到的了,不是自己写的,留作参考
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';