PA Non-Labor Resources By Organization

➜ Back to Library
Description
Categories: BI Publisher
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 NameSQL textValidation
Organization
 
LOV Oracle
Expenditure Category
 
LOV Oracle
Expenditure Type
 
LOV Oracle
Download
Related Blitz Reports
ECC Project Manufacturing, Expenditures ECC Projects, Projects Costing: PSI Summary ECC Projects, Projects Costing: Transactions, SQL1 PA Transaction Upload PA Project Expenditure Adjustment Activity PA Capital Project Summary with Asset Detail PA Task Upload PA Revenue, Cost, Budgets by Resources PA Project Budget
Blitz Report™