eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PA_PROJ_ORG_STRUCTURES_V

Source

View Text - Preformatted


SELECT imp.org_id , imp.business_group_id , peos.organization_id_child , peos.organization_id_parent , org1.name , org2t.name , peos.org_structure_version_id , 'Y' from hr_organization_units org1, hr_org_units_no_join org2, hr_all_organization_units_tl org2t, pa_implementations imp, per_org_structure_elements peos where peos.org_structure_version_id = imp.proj_org_structure_version_id and peos.organization_id_child = org1.organization_id and peos.organization_id_parent = org2.organization_id (+) and org2.organization_id = org2t.organization_id (+) and decode(org2t.organization_id,null,'1',org2t.language) = decode(org2t.organization_id,null,'1',userenv('lang')) and exists (select 'X' from hr_organization_information info where org1.organization_id = info.organization_id and info.org_information1 = 'PA_PROJECT_ORG' and info.org_information_context||'' = 'CLASS' and info.org_information2 = 'Y') and peos.organization_id_child in /*In PROJECT ORG HIERARCHY */ (select se.organization_id_child from per_org_structure_elements se where org_structure_version_id = imp.proj_org_structure_version_id connect by prior se.organization_id_child = se.organization_id_parent and org_structure_version_id = imp.proj_org_structure_version_id start with se.organization_id_parent = imp.proj_start_org_id and org_structure_version_id = imp.proj_org_structure_version_id union select imp.proj_start_org_id from sys.duaL )

View Text - HTML Formatted

SELECT IMP.ORG_ID
, IMP.BUSINESS_GROUP_ID
, PEOS.ORGANIZATION_ID_CHILD
, PEOS.ORGANIZATION_ID_PARENT
, ORG1.NAME
, ORG2T.NAME
, PEOS.ORG_STRUCTURE_VERSION_ID
, 'Y'
FROM HR_ORGANIZATION_UNITS ORG1
, HR_ORG_UNITS_NO_JOIN ORG2
, HR_ALL_ORGANIZATION_UNITS_TL ORG2T
, PA_IMPLEMENTATIONS IMP
, PER_ORG_STRUCTURE_ELEMENTS PEOS
WHERE PEOS.ORG_STRUCTURE_VERSION_ID = IMP.PROJ_ORG_STRUCTURE_VERSION_ID
AND PEOS.ORGANIZATION_ID_CHILD = ORG1.ORGANIZATION_ID
AND PEOS.ORGANIZATION_ID_PARENT = ORG2.ORGANIZATION_ID (+)
AND ORG2.ORGANIZATION_ID = ORG2T.ORGANIZATION_ID (+)
AND DECODE(ORG2T.ORGANIZATION_ID
, NULL
, '1'
, ORG2T.LANGUAGE) = DECODE(ORG2T.ORGANIZATION_ID
, NULL
, '1'
, USERENV('LANG'))
AND EXISTS (SELECT 'X'
FROM HR_ORGANIZATION_INFORMATION INFO
WHERE ORG1.ORGANIZATION_ID = INFO.ORGANIZATION_ID
AND INFO.ORG_INFORMATION1 = 'PA_PROJECT_ORG'
AND INFO.ORG_INFORMATION_CONTEXT||'' = 'CLASS'
AND INFO.ORG_INFORMATION2 = 'Y')
AND PEOS.ORGANIZATION_ID_CHILD IN /*IN PROJECT ORG HIERARCHY */ (SELECT SE.ORGANIZATION_ID_CHILD
FROM PER_ORG_STRUCTURE_ELEMENTS SE
WHERE ORG_STRUCTURE_VERSION_ID = IMP.PROJ_ORG_STRUCTURE_VERSION_ID CONNECT BY PRIOR SE.ORGANIZATION_ID_CHILD = SE.ORGANIZATION_ID_PARENT
AND ORG_STRUCTURE_VERSION_ID = IMP.PROJ_ORG_STRUCTURE_VERSION_ID START WITH SE.ORGANIZATION_ID_PARENT = IMP.PROJ_START_ORG_ID
AND ORG_STRUCTURE_VERSION_ID = IMP.PROJ_ORG_STRUCTURE_VERSION_ID UNION SELECT IMP.PROJ_START_ORG_ID
FROM SYS.DUAL )