Oracle EBS 查询PO审批状态SQL
英文部分
SELECT t.lookup_code
,t.displayed_field
FROM po_lookup_codes t
WHERE t.lookup_type = 'AUTHORIZATION STATUS'
;
ALL All Statuses
APPROVED Approved
CANCELLED Cancelled
IN PROCESS In Process
INCOMPLETE Incomplete
PRE-APPROVED Pre-Approved
REJECTED Rejected
REQUIRES REAPPROVAL Requires Reapproval
RETURNED Returned
-------------
中文部分
ALTER SESSION SET NLS_LANGUAGE='SIMPLIFIED CHINESE';
SELECT t.lookup_code
,t.displayed_field
FROM po_lookup_codes t
WHERE t.lookup_type = 'AUTHORIZATION STATUS'
;
IN PROCESS 处理中
CANCELLED 已取消
REJECTED 已拒绝
RETURNED 已退回
ALL 所有状态
APPROVED 批准
INCOMPLETE 未完成
REQUIRES REAPPROVAL 要求重新审批
PRE-APPROVED 预审批
-- 刘轶鹤