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
Run PA Non-Labor Resources By Organization and other Oracle EBS reports with Blitz Report™ on our demo environment
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
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 Project Expenditure Adjustment Activity PA Capital Project Summary with Asset Detail PA Project Types GL Account Analysis GL Account Analysis (Distributions) PA Implementation Options
Blitz Report™

Blitz Report™ provides multiple benefits: