VIEW: APPS.PER_ORGANIZATION_UNITS

Source

View Text - Preformatted

SELECT O.ORGANIZATION_ID , O.BUSINESS_GROUP_ID , O.NAME , O.DATE_FROM , O.DATE_TO , O.INTERNAL_ADDRESS_LINE , O.COMMENTS , O2.ORG_INFORMATION1 , O2.ORG_INFORMATION2 , O2.ORG_INFORMATION3 , O2.ORG_INFORMATION4 , O.INTERNAL_EXTERNAL_FLAG , O.TYPE , O.LOCATION_ID , O.COST_ALLOCATION_KEYFLEX_ID , O.SOFT_CODING_KEYFLEX_ID ,O4.ORG_INFORMATION1 FROM HR_ORGANIZATION_UNITS O , HR_ORGANIZATION_INFORMATION O2 , HR_ORGANIZATION_INFORMATION O3, HR_ORGANIZATION_INFORMATION O4 WHERE O.ORGANIZATION_ID = O2.ORGANIZATION_ID (+) AND O.ORGANIZATION_ID = O4.ORGANIZATION_ID (+) AND O.ORGANIZATION_ID = O3.ORGANIZATION_ID AND O2.ORG_INFORMATION_CONTEXT (+) || '' = 'Work Day Information' AND O3.ORG_INFORMATION_CONTEXT || '' = 'CLASS' AND O3.ORG_INFORMATION1 = 'HR_ORG' AND O3.ORG_INFORMATION2 = 'Y' AND O4.ORG_INFORMATION_CONTEXT (+) || '' = 'Exp Organization Defaults'

View Text - HTML Formatted

SELECT O.ORGANIZATION_ID
, O.BUSINESS_GROUP_ID
, O.NAME
, O.DATE_FROM
, O.DATE_TO
, O.INTERNAL_ADDRESS_LINE
, O.COMMENTS
, O2.ORG_INFORMATION1
, O2.ORG_INFORMATION2
, O2.ORG_INFORMATION3
, O2.ORG_INFORMATION4
, O.INTERNAL_EXTERNAL_FLAG
, O.TYPE
, O.LOCATION_ID
, O.COST_ALLOCATION_KEYFLEX_ID
, O.SOFT_CODING_KEYFLEX_ID
, O4.ORG_INFORMATION1
FROM HR_ORGANIZATION_UNITS O
, HR_ORGANIZATION_INFORMATION O2
, HR_ORGANIZATION_INFORMATION O3
, HR_ORGANIZATION_INFORMATION O4
WHERE O.ORGANIZATION_ID = O2.ORGANIZATION_ID (+)
AND O.ORGANIZATION_ID = O4.ORGANIZATION_ID (+)
AND O.ORGANIZATION_ID = O3.ORGANIZATION_ID
AND O2.ORG_INFORMATION_CONTEXT (+) || '' = 'WORK DAY INFORMATION'
AND O3.ORG_INFORMATION_CONTEXT || '' = 'CLASS'
AND O3.ORG_INFORMATION1 = 'HR_ORG'
AND O3.ORG_INFORMATION2 = 'Y'
AND O4.ORG_INFORMATION_CONTEXT (+) || '' = 'EXP ORGANIZATION DEFAULTS'