PA Organization Hierarchy

Description

Application: Projects
Source: IMP: Organization Hierarchy (XML)
Short Name: PAXRWDOH_XML
DB package: PA_PAXRWDOH_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Copy

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