oracle开发常用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

--签证分类

select
       t.meaning
from
     fnd_lookup_values_vl       t
Where t.lookup_type='CUX_FC_QZYY'

-- 任务ID

Select Distinct
      A.Task_Number,
      A.Task_Name
From pa_tasks A