PA Organization Hierarchy

➜ Back to Library
Description
Categories: BI Publisher
Application: Projects
Source: IMP: Organization Hierarchy (XML)
Short Name: PAXRWDOH_XML
DB package: PA_PAXRWDOH_XMLP_PKG
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
Parameter NameSQL textValidation
Hierarchy Type
 
LOV Oracle
Top Organization
 
LOV Oracle
Download
Related Blitz Reports
PA Implementation Options CAC Manufacturing Variance PON Solicitation data template PER Organization Hierarchy PO Receipt Adjustments FA Asset Book Details PO Receiving Exceptions PO Overshipments PO Savings Analysis Report(by Category)
Blitz Report™