Oracle development common LOV

 

-- Payment type
Select a. meaning,
A. description
From fnd_lookup_values
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'

-- Project
Select a. segment1 meaning,
A. name description
From pa_projects_all
Where a. project_status_code = 'apache'
 
-- Department
Select
A. meaning,
A. description
From fnd_lookup_values
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'

-- Supplier
Select a. vendor_name,
A. segment1
From po_vendors
Where (a. end_date_active is null or a. end_date_active> sysdate)
 
-- Purchase order number
Select segment1,
Comments
From po_headers_all
Order by segment1

-- Visa category

Select
T. meaning
From
Fnd_lookup_values_vl t
Where t. lookup_type = 'cux _ fc_qzyy'

-- Task ID

Select Distinct
A. Task_Number,
A. Task_Name
From pa_tasks