PA Organization Hierarchy
Description
- Categories
- BI Publisher
- Application
- Projects
- Source
- IMP: Organization Hierarchy (XML)
- Short Name
- PAXRWDOH_XML
- DB package
- PA_PAXRWDOH_XMLP_PKG
SQL 27 lines
SELECT distinct p.org_structure_version_id org_structure_version_id , pos1.name Organization_hierarchy ,posv.version_number version_number , decode(:aa_start_org_id,'',&p_parent_org_id,:aa_start_org_id) ORG_ID_PARENT ,substr(org.name,1,60) name2 ,&p_parent_org_id FROM per_org_structure_elements p ,hr_organization_units org , pa_implementations pi ,per_organization_structures pos1 ,&P_From_Clause WHERE decode(null,'', p.organization_id_parent, -999) not in (select d.organization_id_child from per_org_structure_elements d where d.org_structure_version_id = &P_Decode_Column ) and p.org_structure_version_id = &P_Decode_Column &p_version_id &p_structure_id &p_where_clause1 &p_where_clause &p_org_hr &p_burden order by 5 |
Parameters 2
| Parameter | Type | List of values SQL |
|---|---|---|
| Hierarchy Type | LOV Oracle | |
| Top Organization | LOV Oracle |