--
支付类别
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 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