Oracle EBS 获取付款界面类型SQL

OracleEBS 获取付款界面类型SQL

SELECT displayed_field
      ,lookup_code
  FROM ap_lookup_codes
 WHERE lookup_type = 'PAYMENT TYPE'
   AND lookup_code NOT IN ('A'
                          ,'N') 
order BY upper(displayed_field)

--- 人工、快速、退款

-- 刘轶鹤