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 |