Pending transaction error info
来源:互联网 发布:淘宝卖假货会不会坐牢 编辑:程序博客网 时间:2024/05/21 22:27
忘了是在哪里的看到的了,不是自己写的,留作参考
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';
- Pending transaction error info
- pending transaction
- Pending
- pending
- error BK1506 Browser Info
- @@ERROR 与ROLLBACK TRANSACTION
- Transaction Check Error错误
- Transaction check error:
- Transaction check error:
- Debug info warn error fatal
- install-info error during update
- Debug、Info、Warn、Error、Fatal
- Android MediaPlayer Error/Info Code
- yum install Transaction Check Error
- Error while commiting the transaction
- 解决cpsid_82829s1: "A restart is pending," bootstrapper error has occurred.
- loadrunner Error -27257: Pending web_reg_save_param/reg_find/create_html_param[_ex]
- sQLite问题:Error cannot start a transaction within a transaction
- go 0x30008000之后遇到的问题
- 一天一天学 windows phone 引言 + 大概认知 之 导航3事件(三)
- Java Tutorial: How to Create RESTful Java Client using Apache HttpClient – Example
- 【Android 开发】:数据存储之 SQLite 数据库操作(三)
- C++内存分配秘籍 -- new,malloc,GlobalAlloc详解
- Pending transaction error info
- 导入安卓工程时出现红色叹号的几种解决办法。
- 委托的基本用法
- FLIPPED
- 二路归并
- 麦迪也退役了
- IOS开发之关于NSTimer使用
- 2010-09-25 13:39 浅谈内存分配malloc,calloc,realloc
- 花生壳动态解析