VIEW: APPS.PA_EXP_START_ORGS_V

Source

View Text - Preformatted

SELECT distinct haou.name, haou.organization_id, posv.org_structure_version_id, pos.name FROM per_organization_structures pos, per_org_structure_versions posv, hr_all_organization_units_tl haou WHERE posv.organization_structure_id = pos.organization_structure_id AND haou.language = USERENV('LANG') and exists ( select '1' from pa_org_hierarchy_denorm ohd where ohd.org_hierarchy_version_id = posv.org_structure_version_id AND ohd.pa_org_use_type ='EXPENDITURES' AND ohd.parent_organization_id = haou.organization_id )

View Text - HTML Formatted

SELECT DISTINCT HAOU.NAME
, HAOU.ORGANIZATION_ID
, POSV.ORG_STRUCTURE_VERSION_ID
, POS.NAME
FROM PER_ORGANIZATION_STRUCTURES POS
, PER_ORG_STRUCTURE_VERSIONS POSV
, HR_ALL_ORGANIZATION_UNITS_TL HAOU
WHERE POSV.ORGANIZATION_STRUCTURE_ID = POS.ORGANIZATION_STRUCTURE_ID
AND HAOU.LANGUAGE = USERENV('LANG')
AND EXISTS ( SELECT '1'
FROM PA_ORG_HIERARCHY_DENORM OHD
WHERE OHD.ORG_HIERARCHY_VERSION_ID = POSV.ORG_STRUCTURE_VERSION_ID
AND OHD.PA_ORG_USE_TYPE ='EXPENDITURES'
AND OHD.PARENT_ORGANIZATION_ID = HAOU.ORGANIZATION_ID )