PA Non-Labor Resources By Organization
Description
Categories: BI Publisher
Application: Projects
Source: IMP: Non-Labor Resources By Organization (XML)
Short Name: PAXRWNLR_XML
DB package: PA_PAXRWNLR_XMLP_PKG
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 |