PA Organization Hierarchy

Description

Categories: BI Publisher, Financials

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

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

Ask a question

Download

Related Blitz Reports

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