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_REP_ALL_REP_ORG_V

Source

View Text - Preformatted


SELECT pohd.parent_organization_id ,hr1.name ,pohd.child_organization_id ,hr2.name FROM pa_org_hierarchy_denorm pohd ,pa_implementations imp ,hr_all_organization_units_tl hr1 ,hr_all_organization_units_tl hr2 WHERE pohd.pa_org_use_type = 'REPORTING' AND pohd.org_id = imp.org_id AND pohd.org_hierarchy_version_id = imp.org_structure_version_id AND pohd.parent_organization_id = hr1.organization_id AND hr1.language = userenv('LANG') AND pohd.child_organization_id = hr2.organization_id AND hr2.language = userenv('LANG')

View Text - HTML Formatted

SELECT POHD.PARENT_ORGANIZATION_ID
, HR1.NAME
, POHD.CHILD_ORGANIZATION_ID
, HR2.NAME
FROM PA_ORG_HIERARCHY_DENORM POHD
, PA_IMPLEMENTATIONS IMP
, HR_ALL_ORGANIZATION_UNITS_TL HR1
, HR_ALL_ORGANIZATION_UNITS_TL HR2
WHERE POHD.PA_ORG_USE_TYPE = 'REPORTING'
AND POHD.ORG_ID = IMP.ORG_ID
AND POHD.ORG_HIERARCHY_VERSION_ID = IMP.ORG_STRUCTURE_VERSION_ID
AND POHD.PARENT_ORGANIZATION_ID = HR1.ORGANIZATION_ID
AND HR1.LANGUAGE = USERENV('LANG')
AND POHD.CHILD_ORGANIZATION_ID = HR2.ORGANIZATION_ID
AND HR2.LANGUAGE = USERENV('LANG')