Oracle ERP 开发中经常使用的LOV

-- 支付类别
Select a.meaning,
       a.description
  from fnd_lookup_values a
 where a.lookup_type = 'CUX_YDZJJH_LB'
   and a.language = USERENV('LANG')
   and (a.end_date_active is null
       or a.end_date_active>sysdate)
   and a.enabled_flag='Y'
  
--项目
Select a.segment1 meaning,
       a.name description
  from pa_projects_all a
 where a.project_status_code = 'APPROVED'
 
--部门
Select
       a.meaning,
       a.description
  from fnd_lookup_values a
 where a.lookup_type = 'CUX_FC_CBBM'
   and a.language = USERENV('LANG')
   and (a.end_date_active is null
       or a.end_date_active>sysdate)
   and a.enabled_flag='Y'

-- 供应商
Select a.vendor_name,
       a.segment1
  from po_vendors a
 where (a.end_date_active is null or a.end_date_active>sysdate)
 
-- 采购订单号
select segment1,
       comments
from po_headers_all
order by segment1