VIEW: APPS.QPR_SR_ORG_HIER_V

Source

View Text - Preformatted

SELECT hou.organization_id , hou.name , null, null, null, null, null, decode(hoi2.org_information_context, 'Accounting Information', to_number(hoi2.org_information2), NULL) , decode(decode(hoi2.org_information_context, 'Accounting Information', to_number(hoi2.org_information2), NULL), null, null, (SELECT o.name FROM hr_all_organization_units o, hr_organization_information o2, hr_organization_information o3 WHERE o.organization_id= to_number(hoi2.org_information2) AND o.organization_id = o2.organization_id AND o.organization_id = o3.organization_id(+) AND o2.org_information_context || '' = 'CLASS' AND o3.org_information_context(+) || '' = 'Legal Entity Accounting' AND o2.org_information1 = 'HR_LEGAL' AND o2.org_information2 = 'Y')), null, null, null, null, null, hou.business_group_id, hou1.name, null, null, null, null, null, QPR_SR_UTIL.get_all_org_pk , QPR_SR_UTIL.get_all_org_desc, null, null, null, null, null, qpr_sr_util.get_max_date( qpr_sr_util.get_max_date( qpr_sr_util.get_max_date(trunc(hou.last_update_date, 'dd'), trunc(hou1.last_update_date,'dd')), trunc(hoi1.last_update_date,'dd')), trunc(hoi2.last_update_date, 'dd')) FROM hr_all_organization_units_vl hou, hr_all_organization_units_vl hou1, hr_organization_information hoi1, hr_organization_information hoi2 WHERE hou.organization_id = hoi1.organization_id and hou.organization_id = hou1.organization_id and hoi1.org_information1='OPERATING_UNIT' and (hoi1.org_information_context || '') = 'CLASS' and hoi1.org_information2 = 'Y' and hou.organization_id = hoi2.organization_id and (hoi2.org_information_context || '') = 'Accounting Information' order by hou.organization_id

View Text - HTML Formatted

SELECT HOU.ORGANIZATION_ID
, HOU.NAME
, NULL
, NULL
, NULL
, NULL
, NULL
, DECODE(HOI2.ORG_INFORMATION_CONTEXT
, 'ACCOUNTING INFORMATION'
, TO_NUMBER(HOI2.ORG_INFORMATION2)
, NULL)
, DECODE(DECODE(HOI2.ORG_INFORMATION_CONTEXT
, 'ACCOUNTING INFORMATION'
, TO_NUMBER(HOI2.ORG_INFORMATION2)
, NULL)
, NULL
, NULL
, (SELECT O.NAME
FROM HR_ALL_ORGANIZATION_UNITS O
, HR_ORGANIZATION_INFORMATION O2
, HR_ORGANIZATION_INFORMATION O3
WHERE O.ORGANIZATION_ID= TO_NUMBER(HOI2.ORG_INFORMATION2)
AND O.ORGANIZATION_ID = O2.ORGANIZATION_ID
AND O.ORGANIZATION_ID = O3.ORGANIZATION_ID(+)
AND O2.ORG_INFORMATION_CONTEXT || '' = 'CLASS'
AND O3.ORG_INFORMATION_CONTEXT(+) || '' = 'LEGAL ENTITY ACCOUNTING'
AND O2.ORG_INFORMATION1 = 'HR_LEGAL'
AND O2.ORG_INFORMATION2 = 'Y'))
, NULL
, NULL
, NULL
, NULL
, NULL
, HOU.BUSINESS_GROUP_ID
, HOU1.NAME
, NULL
, NULL
, NULL
, NULL
, NULL
, QPR_SR_UTIL.GET_ALL_ORG_PK
, QPR_SR_UTIL.GET_ALL_ORG_DESC
, NULL
, NULL
, NULL
, NULL
, NULL
, QPR_SR_UTIL.GET_MAX_DATE( QPR_SR_UTIL.GET_MAX_DATE( QPR_SR_UTIL.GET_MAX_DATE(TRUNC(HOU.LAST_UPDATE_DATE
, 'DD')
, TRUNC(HOU1.LAST_UPDATE_DATE
, 'DD'))
, TRUNC(HOI1.LAST_UPDATE_DATE
, 'DD'))
, TRUNC(HOI2.LAST_UPDATE_DATE
, 'DD'))
FROM HR_ALL_ORGANIZATION_UNITS_VL HOU
, HR_ALL_ORGANIZATION_UNITS_VL HOU1
, HR_ORGANIZATION_INFORMATION HOI1
, HR_ORGANIZATION_INFORMATION HOI2
WHERE HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID
AND HOU.ORGANIZATION_ID = HOU1.ORGANIZATION_ID
AND HOI1.ORG_INFORMATION1='OPERATING_UNIT'
AND (HOI1.ORG_INFORMATION_CONTEXT || '') = 'CLASS'
AND HOI1.ORG_INFORMATION2 = 'Y'
AND HOU.ORGANIZATION_ID = HOI2.ORGANIZATION_ID
AND (HOI2.ORG_INFORMATION_CONTEXT || '') = 'ACCOUNTING INFORMATION' ORDER BY HOU.ORGANIZATION_ID