|
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?? ?预审批
?
-- 刘轶鹤
|