PA Organization Hierarchy

➜ Back to Library

Description
Categories: BI Publisher, Financials Application: Projects Source: IMP: Organization Hierarchy (XML) Short Name: PAXRWDOH_XML DB package: PA_PAXRWDOH_XMLP_PKG more less

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

Parameter Name

SQL text

Validation

Top Organization

LOV Oracle

Hierarchy Type

LOV Oracle

Download

Related Blitz Reports
PA Implementation Options PON Solicitation data template PO Receipt Adjustments PER COBRA Payments INV Organization Hierarchy Exceptions PER COBRA Coverage PO Savings Analysis Report(by Category) PO Receiving Exceptions PO Overshipments