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)
--- 人工、快速、退款
-- 刘轶鹤
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)
--- 人工、快速、退款
-- 刘轶鹤