VIEW: APPS.PA_R_HIERARCHIES_V

Source

View Text - Preformatted

SELECT imp.exp_org_structure_id org_structure_id, imp.exp_org_structure_version_id org_structure_version_id, pos.name org_structure_name, posv.version_number version_number, paorg.organization_id, pa_resource_utils.get_organization_name(paorg.organization_id), 'EXPENDITURE' structure_type, imp.business_group_id business_group_id, imp.org_id org_id, pa_resource_utils.get_organization_name(imp.org_id) ou_name from pa_implementations_all imp, per_org_structure_versions posv, per_organization_structures pos, pa_all_organizations paorg WHERE imp.exp_org_structure_version_id = posv.org_structure_version_id and posv.organization_structure_id = pos.organization_structure_id and imp.org_id = paorg.org_id and paorg.pa_org_use_type = 'EXPENDITURES' and paorg.inactive_date is null union select imp.proj_org_structure_id org_structure_id, imp.proj_org_structure_version_id org_structure_version_id, pos.name org_structure_name, posv.version_number version_number, paorg.organization_id, pa_resource_utils.get_organization_name(paorg.organization_id), 'PROJECT' structure_type, imp.business_group_id business_group_id, imp.org_id org_id, pa_resource_utils.get_organization_name(imp.org_id) ou_name from pa_implementations_all imp, per_org_structure_versions posv, per_organization_structures pos, pa_all_organizations paorg where imp.proj_org_structure_version_id = posv.org_structure_version_id and posv.organization_structure_id = pos.organization_structure_id and imp.org_id = paorg.org_id and paorg.pa_org_use_type = 'PROJECTS' and paorg.inactive_date is null

View Text - HTML Formatted

SELECT IMP.EXP_ORG_STRUCTURE_ID ORG_STRUCTURE_ID
, IMP.EXP_ORG_STRUCTURE_VERSION_ID ORG_STRUCTURE_VERSION_ID
, POS.NAME ORG_STRUCTURE_NAME
, POSV.VERSION_NUMBER VERSION_NUMBER
, PAORG.ORGANIZATION_ID
, PA_RESOURCE_UTILS.GET_ORGANIZATION_NAME(PAORG.ORGANIZATION_ID)
, 'EXPENDITURE' STRUCTURE_TYPE
, IMP.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, IMP.ORG_ID ORG_ID
, PA_RESOURCE_UTILS.GET_ORGANIZATION_NAME(IMP.ORG_ID) OU_NAME
FROM PA_IMPLEMENTATIONS_ALL IMP
, PER_ORG_STRUCTURE_VERSIONS POSV
, PER_ORGANIZATION_STRUCTURES POS
, PA_ALL_ORGANIZATIONS PAORG
WHERE IMP.EXP_ORG_STRUCTURE_VERSION_ID = POSV.ORG_STRUCTURE_VERSION_ID
AND POSV.ORGANIZATION_STRUCTURE_ID = POS.ORGANIZATION_STRUCTURE_ID
AND IMP.ORG_ID = PAORG.ORG_ID
AND PAORG.PA_ORG_USE_TYPE = 'EXPENDITURES'
AND PAORG.INACTIVE_DATE IS NULL UNION SELECT IMP.PROJ_ORG_STRUCTURE_ID ORG_STRUCTURE_ID
, IMP.PROJ_ORG_STRUCTURE_VERSION_ID ORG_STRUCTURE_VERSION_ID
, POS.NAME ORG_STRUCTURE_NAME
, POSV.VERSION_NUMBER VERSION_NUMBER
, PAORG.ORGANIZATION_ID
, PA_RESOURCE_UTILS.GET_ORGANIZATION_NAME(PAORG.ORGANIZATION_ID)
, 'PROJECT' STRUCTURE_TYPE
, IMP.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, IMP.ORG_ID ORG_ID
, PA_RESOURCE_UTILS.GET_ORGANIZATION_NAME(IMP.ORG_ID) OU_NAME
FROM PA_IMPLEMENTATIONS_ALL IMP
, PER_ORG_STRUCTURE_VERSIONS POSV
, PER_ORGANIZATION_STRUCTURES POS
, PA_ALL_ORGANIZATIONS PAORG
WHERE IMP.PROJ_ORG_STRUCTURE_VERSION_ID = POSV.ORG_STRUCTURE_VERSION_ID
AND POSV.ORGANIZATION_STRUCTURE_ID = POS.ORGANIZATION_STRUCTURE_ID
AND IMP.ORG_ID = PAORG.ORG_ID
AND PAORG.PA_ORG_USE_TYPE = 'PROJECTS'
AND PAORG.INACTIVE_DATE IS NULL