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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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 PA Project Budget Upload GL Account Analysis XXRG GL Account Analysis
Blitz Report™

Blitz Report™ provides multiple benefits: