VIEW: APPS.HR_FR_ESTAB_DADS_FILES_V

Source

View Text - Preformatted

SELECT OI1.ORG_INFORMATION1 DADS_FILES_NUMBER, OU1.BUSINESS_GROUP_ID BUSINESS_GROUP_ID, OU1.ORGANIZATION_ID , OUT1.NAME FROM HR_ORGANIZATION_INFORMATION OI1 , HR_ALL_ORGANIZATION_UNITS OU1 , HR_ORGANIZATION_INFORMATION OI2 , HR_ALL_ORGANIZATION_UNITS_TL OUT1 WHERE OI2.ORG_INFORMATION_CONTEXT || '' = 'CLASS' AND OI2.ORG_INFORMATION1 = 'FR_ETABLISSEMENT' AND OI2.ORG_INFORMATION2 = 'Y' AND OU1.ORGANIZATION_ID = OI2.ORGANIZATION_ID AND OU1.ORGANIZATION_ID = OUT1.ORGANIZATION_ID AND userenv('LANG') = OUT1.LANGUAGE AND OU1.ORGANIZATION_ID = OI1.ORGANIZATION_ID (+) AND OI1.ORG_INFORMATION_CONTEXT (+) || '' = 'FR_ESTAB_DADS_FILES'

View Text - HTML Formatted

SELECT OI1.ORG_INFORMATION1 DADS_FILES_NUMBER
, OU1.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, OU1.ORGANIZATION_ID
, OUT1.NAME
FROM HR_ORGANIZATION_INFORMATION OI1
, HR_ALL_ORGANIZATION_UNITS OU1
, HR_ORGANIZATION_INFORMATION OI2
, HR_ALL_ORGANIZATION_UNITS_TL OUT1
WHERE OI2.ORG_INFORMATION_CONTEXT || '' = 'CLASS'
AND OI2.ORG_INFORMATION1 = 'FR_ETABLISSEMENT'
AND OI2.ORG_INFORMATION2 = 'Y'
AND OU1.ORGANIZATION_ID = OI2.ORGANIZATION_ID
AND OU1.ORGANIZATION_ID = OUT1.ORGANIZATION_ID
AND USERENV('LANG') = OUT1.LANGUAGE
AND OU1.ORGANIZATION_ID = OI1.ORGANIZATION_ID (+)
AND OI1.ORG_INFORMATION_CONTEXT (+) || '' = 'FR_ESTAB_DADS_FILES'