Oracle EBS 查询PO审批状态SQL

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    预审批
 

-- 刘轶鹤