VIEW: APPS.HR_FR_COMPANIES_V

Source

View Text - Preformatted

SELECT OU1.ORGANIZATION_ID , OU1.BUSINESS_GROUP_ID , OUT1.NAME , OU1.DATE_FROM , OU1.DATE_TO , OU1.INTERNAL_ADDRESS_LINE , OU1.LOCATION_ID , OL.LOCATION_CODE , OU1.COMMENTS , OI1.ORG_INFORMATION1 , OI1.ORG_INFORMATION2 , OI1.ORG_INFORMATION3 , OUT2.NAME , OI1.ORG_INFORMATION4 , OUT3.NAME , OI1.ORG_INFORMATION5 , OUT4.NAME , OI2.ORG_INFORMATION1 , OI2.ORG_INFORMATION2 , OI2.ORG_INFORMATION3 , OI2.ORG_INFORMATION4 , OI2.ORG_INFORMATION5 , OI3.ORG_INFORMATION2 FROM HR_LOCATIONS OL , HR_ALL_ORGANIZATION_UNITS OU4 , HR_ALL_ORGANIZATION_UNITS OU3 , HR_ALL_ORGANIZATION_UNITS OU2 , HR_ALL_ORGANIZATION_UNITS_TL OUT4, HR_ALL_ORGANIZATION_UNITS_TL OUT3, HR_ALL_ORGANIZATION_UNITS_TL OUT2, HR_ORGANIZATION_INFORMATION OI3 , HR_ORGANIZATION_INFORMATION OI2 , HR_ORGANIZATION_INFORMATION OI1 , HR_ALL_ORGANIZATION_UNITS OU1 , HR_ALL_ORGANIZATION_UNITS_TL OUT1 WHERE OU1.ORGANIZATION_ID = OI1.ORGANIZATION_ID (+) AND OU1.ORGANIZATION_ID = OI2.ORGANIZATION_ID (+) AND OU1.ORGANIZATION_ID = OI3.ORGANIZATION_ID AND OU1.ORGANIZATION_ID = OUT1.ORGANIZATION_ID AND USERENV('LANG') = OUT1.LANGUAGE AND OI1.ORG_INFORMATION_CONTEXT (+) ||'' = 'FR_COMP_INFO' AND OI2.ORG_INFORMATION_CONTEXT (+) ||'' = 'FR_COMP_PREV_INFO' AND OI3.ORG_INFORMATION_CONTEXT ||'' = 'CLASS' AND OI3.ORG_INFORMATION1 = 'FR_SOCIETE' AND OI3.ORG_INFORMATION2 = 'Y' AND OI1.ORG_INFORMATION3 = OU2.ORGANIZATION_ID (+) AND OU2.ORGANIZATION_ID = OUT2.ORGANIZATION_ID (+) AND USERENV('LANG') = OUT2.LANGUAGE (+) AND OI1.ORG_INFORMATION4 = OU3.ORGANIZATION_ID (+) AND OU3.ORGANIZATION_ID = OUT3.ORGANIZATION_ID (+) AND USERENV('LANG') = OUT3.LANGUAGE (+) AND OI1.ORG_INFORMATION5 = OU4.ORGANIZATION_ID (+) AND OU4.ORGANIZATION_ID = OUT4.ORGANIZATION_ID (+) AND USERENV('LANG') = OUT4.LANGUAGE (+) AND OL.LOCATION_ID (+) = OU1.LOCATION_ID

View Text - HTML Formatted

SELECT OU1.ORGANIZATION_ID
, OU1.BUSINESS_GROUP_ID
, OUT1.NAME
, OU1.DATE_FROM
, OU1.DATE_TO
, OU1.INTERNAL_ADDRESS_LINE
, OU1.LOCATION_ID
, OL.LOCATION_CODE
, OU1.COMMENTS
, OI1.ORG_INFORMATION1
, OI1.ORG_INFORMATION2
, OI1.ORG_INFORMATION3
, OUT2.NAME
, OI1.ORG_INFORMATION4
, OUT3.NAME
, OI1.ORG_INFORMATION5
, OUT4.NAME
, OI2.ORG_INFORMATION1
, OI2.ORG_INFORMATION2
, OI2.ORG_INFORMATION3
, OI2.ORG_INFORMATION4
, OI2.ORG_INFORMATION5
, OI3.ORG_INFORMATION2
FROM HR_LOCATIONS OL
, HR_ALL_ORGANIZATION_UNITS OU4
, HR_ALL_ORGANIZATION_UNITS OU3
, HR_ALL_ORGANIZATION_UNITS OU2
, HR_ALL_ORGANIZATION_UNITS_TL OUT4
, HR_ALL_ORGANIZATION_UNITS_TL OUT3
, HR_ALL_ORGANIZATION_UNITS_TL OUT2
, HR_ORGANIZATION_INFORMATION OI3
, HR_ORGANIZATION_INFORMATION OI2
, HR_ORGANIZATION_INFORMATION OI1
, HR_ALL_ORGANIZATION_UNITS OU1
, HR_ALL_ORGANIZATION_UNITS_TL OUT1
WHERE OU1.ORGANIZATION_ID = OI1.ORGANIZATION_ID (+)
AND OU1.ORGANIZATION_ID = OI2.ORGANIZATION_ID (+)
AND OU1.ORGANIZATION_ID = OI3.ORGANIZATION_ID
AND OU1.ORGANIZATION_ID = OUT1.ORGANIZATION_ID
AND USERENV('LANG') = OUT1.LANGUAGE
AND OI1.ORG_INFORMATION_CONTEXT (+) ||'' = 'FR_COMP_INFO'
AND OI2.ORG_INFORMATION_CONTEXT (+) ||'' = 'FR_COMP_PREV_INFO'
AND OI3.ORG_INFORMATION_CONTEXT ||'' = 'CLASS'
AND OI3.ORG_INFORMATION1 = 'FR_SOCIETE'
AND OI3.ORG_INFORMATION2 = 'Y'
AND OI1.ORG_INFORMATION3 = OU2.ORGANIZATION_ID (+)
AND OU2.ORGANIZATION_ID = OUT2.ORGANIZATION_ID (+)
AND USERENV('LANG') = OUT2.LANGUAGE (+)
AND OI1.ORG_INFORMATION4 = OU3.ORGANIZATION_ID (+)
AND OU3.ORGANIZATION_ID = OUT3.ORGANIZATION_ID (+)
AND USERENV('LANG') = OUT3.LANGUAGE (+)
AND OI1.ORG_INFORMATION5 = OU4.ORGANIZATION_ID (+)
AND OU4.ORGANIZATION_ID = OUT4.ORGANIZATION_ID (+)
AND USERENV('LANG') = OUT4.LANGUAGE (+)
AND OL.LOCATION_ID (+) = OU1.LOCATION_ID