PA Non-Labor Resources By Organization

Description
Categories: BI Publisher, Financials
Application: Projects
Source: IMP: Non-Labor Resources By Organization (XML)
Short Name: PAXRWNLR_XML
DB package: PA_PAXRWNLR_XMLP_PKG
SELECT	substr(o.name,1,60)  name
,	nlr.expenditure_type ex_type
,	et.expenditure_category  ex_category
,	nlr.non_labor_resource
,	nlr.start_date_active
,	nlr.end_date_active
,	nlr.description
FROM	hr_organization_units o
,	pa_expenditure_types et
,	pa_non_labor_resources nlr
,       pa_non_labor_resource_orgs nlro
WHERE	nlro.organization_id = nvl(:p_organization_id, nlro.organization_id)
and     nlr.non_labor_resource = nlro.non_labor_resource
and     nlr.expenditure_type = nvl(:p_expenditure_type, nlr.expenditure_type)
and	nlr.expenditure_type = et.expenditure_type
and	et.expenditure_category = nvl(:p_expenditure_category, et.expenditure_category)
and	nlro.organization_id = o.organization_id
ORDER BY
	o.name
,	et.expenditure_category
,	nlr.expenditure_type
,	nlr.non_labor_resource
,	nlr.start_date_active
,   nlr.end_date_active
,	nlr.description
Parameter Name SQL text Validation
Expenditure Type
 
LOV Oracle
Expenditure Category
 
LOV Oracle
Organization
 
LOV Oracle