VIEW: APPS.HR_ESTAB_COLL_AGRS_V

Source

View Text - Preformatted

SELECT TO_CHAR(C.COLLECTIVE_AGREEMENT_ID) ,C.BUSINESS_GROUP_ID ,C.NAME ,OU1.ORGANIZATION_ID ,OUT1.NAME ,C.START_DATE ,C.END_DATE FROM HR_ORGANIZATION_INFORMATION OI1 ,PER_COLLECTIVE_AGREEMENTS C ,HR_ALL_ORGANIZATION_UNITS OU1 ,HR_ALL_ORGANIZATION_UNITS_TL OUT1 ,HR_ORGANIZATION_INFORMATION OI2 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 = OI1.ORGANIZATION_ID (+) AND OI1.ORG_INFORMATION_CONTEXT (+) || '' = 'FR_ESTAB_COLL_AGRS' AND to_number(OI1.ORG_INFORMATION1) = C.COLLECTIVE_AGREEMENT_ID AND OU1.ORGANIZATION_ID = OUT1.ORGANIZATION_ID AND userenv('LANG') = OUT1.LANGUAGE

View Text - HTML Formatted

SELECT TO_CHAR(C.COLLECTIVE_AGREEMENT_ID)
, C.BUSINESS_GROUP_ID
, C.NAME
, OU1.ORGANIZATION_ID
, OUT1.NAME
, C.START_DATE
, C.END_DATE
FROM HR_ORGANIZATION_INFORMATION OI1
, PER_COLLECTIVE_AGREEMENTS C
, HR_ALL_ORGANIZATION_UNITS OU1
, HR_ALL_ORGANIZATION_UNITS_TL OUT1
, HR_ORGANIZATION_INFORMATION OI2
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 = OI1.ORGANIZATION_ID (+)
AND OI1.ORG_INFORMATION_CONTEXT (+) || '' = 'FR_ESTAB_COLL_AGRS'
AND TO_NUMBER(OI1.ORG_INFORMATION1) = C.COLLECTIVE_AGREEMENT_ID
AND OU1.ORGANIZATION_ID = OUT1.ORGANIZATION_ID
AND USERENV('LANG') = OUT1.LANGUAGE