View: EDWBV_HR_LEGAL_ENTITIES_LCV

View Text

SELECT TO_CHAR(LE.ORGANIZATION_ID) || '-' || I.INSTANCE_CODE
, TO_CHAR(LEBG.ORGANIZATION_ID) || '-' || I.INSTANCE_CODE
, GREATEST( NVL( LE.LAST_UPDATE_DATE
, TO_DATE( '01/01/2000'
, 'DD/MM/YYYY' ))
, NVL( LEBG.LAST_UPDATE_DATE
, TO_DATE( '01/01/2000'
, 'DD/MM/YYYY' ))
, NVL( OI1.LAST_UPDATE_DATE
, TO_DATE( '01/01/2000'
, 'DD/MM/YYYY' ))
, NVL( OI2.LAST_UPDATE_DATE
, TO_DATE( '01/01/2000'
, 'DD/MM/YYYY' ))
, NVL( SOB.LAST_UPDATE_DATE
, TO_DATE( '01/01/2000'
, 'DD/MM/YYYY' ))
, NVL( MP.LAST_UPDATE_DATE
, TO_DATE( '01/01/2000'
, 'DD/MM/YYYY' )) )
, LE.NAME || ' (' || LEBG.NAME || ')'
, LE.NAME || ' (' || LEBG.NAME || ')'
, SOB.NAME
, LE.DATE_FROM
, LE.DATE_TO
, LE.INTERNAL_EXTERNAL_FLAG
, LE.TYPE
, MP.ORGANIZATION_CODE
, MP.PRIMARY_COST_METHOD
, I.INSTANCE_CODE
, LE.ORGANIZATION_ID
, 'LE'
, '_DF:PER:PER_ORGANIZATION_UNITS:ORG'
, '_DF:PER:HR_ORGANIZATION_INFORMATION:OI'
, '_DF:PER:ORG DEVELOPER DF:OI'
, '_DF:JG:JG_GL_SETS_OF_BOOKS:SOB'
, '_DF:SQLGL:GL_SETS_OF_BOOKS:SOB'
FROM HR_ALL_ORGANIZATION_UNITS LE
, HR_ALL_ORGANIZATION_UNITS LEBG
, HR_ORGANIZATION_INFORMATION OI1
, HR_ORGANIZATION_INFORMATION OI2
, GL_SETS_OF_BOOKS SOB
, MTL_PARAMETERS MP
, EDW_LOCAL_INSTANCE I
WHERE LE.BUSINESS_GROUP_ID = LEBG.ORGANIZATION_ID
AND LE.ORGANIZATION_ID = OI1.ORGANIZATION_ID
AND OI1.ORG_INFORMATION_CONTEXT = 'CLASS'
AND OI1.ORG_INFORMATION1 = 'HR_LEGAL'
AND OI1.ORG_INFORMATION2 = 'Y'
AND LE.ORGANIZATION_ID = OI2.ORGANIZATION_ID (+)
AND OI2.ORG_INFORMATION_CONTEXT (+) = 'LEGAL ENTITY ACCOUNTING'
AND TO_NUMBER(OI2.ORG_INFORMATION1) = SOB.SET_OF_BOOKS_ID (+)
AND LE.ORGANIZATION_ID = MP.ORGANIZATION_ID (+)

Columns