View: FND_MO_REPORTING_ENTITIES_V

Product:	FND - Application Object Library
Description:
Implementation/DBA Data:	APPS.FND_MO_REPORTING_ENTITIES_V

View Text

SELECT '1000' REPORTING_LEVEL
, GL.NAME ENTITY_NAME
, GL.LEDGER_ID ENTITY_ID
, -9999 OPERATING_UNIT_ID
, -9999 LEGAL_ENTITY_ID
, GL.LEDGER_ID LEDGER_ID
, GL.CURRENCY_CODE CURRENCY_CODE
, GL.LEDGER_CATEGORY_CODE LEDGER_CATEGORY_CODE
, LC.COMPLETION_STATUS_CODE COMPLETION_STATUS_CODE
FROM GL_LEDGERS_PUBLIC_ALL_V GL
, GL_LEDGERS LG
, GL_LEDGER_CONFIGURATIONS LC
WHERE GL.LEDGER_ID = LG.LEDGER_ID
AND LG.CONFIGURATION_ID = LC.CONFIGURATION_ID
AND 0 IN ( SELECT DECODE(MO_GLOBAL.CHECK_ACCESS(OI1.ORGANIZATION_ID)
, 'Y'
, 0
, 1)
FROM HR_ORGANIZATION_INFORMATION OI1
, HR_ORGANIZATION_INFORMATION OI2
WHERE OI1.ORG_INFORMATION_CONTEXT = 'CLASS'
AND OI1.ORG_INFORMATION1 = 'OPERATING_UNIT'
AND OI1.ORG_INFORMATION2 = 'Y'
AND OI1.ORGANIZATION_ID = OI2.ORGANIZATION_ID
AND OI2.ORG_INFORMATION_CONTEXT = 'OPERATING UNIT INFORMATION'
AND OI2.ORG_INFORMATION3 = TO_CHAR(GL.LEDGER_ID)) UNION ALL /* ALC
AND SECONDARY LEDGERS */ SELECT '1000' REPORTING_LEVEL
, GL.NAME ENTITY_NAME
, GL.LEDGER_ID ENTITY_ID
, -9999 OPERATING_UNIT_ID
, -9999 LEGAL_ENTITY_ID
, GL.LEDGER_ID LEDGER_ID
, GL.CURRENCY_CODE CURRENCY_CODE
, GL.LEDGER_CATEGORY_CODE LEDGER_CATEGORY_CODE
, LC.COMPLETION_STATUS_CODE COMPLETION_STATUS_CODE
FROM GL_LEDGERS_PUBLIC_ALL_V GL
, GL_LEDGER_CONFIGURATIONS LC
WHERE GL.CONFIGURATION_ID = LC.CONFIGURATION_ID
AND GL.LEDGER_ID IN ( SELECT LR.TARGET_LEDGER_ID
FROM GL_LEDGER_RELATIONSHIPS LR
WHERE LR.TARGET_LEDGER_CATEGORY_CODE IN ('ALC'
, 'SECONDARY')
AND LR.RELATIONSHIP_ENABLED_FLAG = 'Y'
AND LR.RELATIONSHIP_TYPE_CODE = 'SUBLEDGER'
AND 0 IN ( SELECT DECODE(MO_GLOBAL.CHECK_ACCESS(OI1.ORGANIZATION_ID)
, 'Y'
, 0
, 1)
FROM HR_ORGANIZATION_INFORMATION OI1
, HR_ORGANIZATION_INFORMATION OI2
WHERE OI1.ORG_INFORMATION_CONTEXT = 'CLASS'
AND OI1.ORG_INFORMATION1 = 'OPERATING_UNIT'
AND OI1.ORG_INFORMATION2 = 'Y'
AND OI1.ORGANIZATION_ID = OI2.ORGANIZATION_ID
AND OI2.ORG_INFORMATION_CONTEXT = 'OPERATING UNIT INFORMATION'
AND TO_NUMBER(OI2.ORG_INFORMATION3) = LR.PRIMARY_LEDGER_ID)) UNION ALL /* ADDED ON JAN 13
, 06 FOR LEGAL ENTITY */ SELECT '2000' REPORTING_LEVEL
, LEP.NAME ENTITY_NAME
, LEP.LEGAL_ENTITY_ID ENTITY_ID
, -9999 OPERATING_UNIT_ID
, LEP.LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, -9999 LEDGER_ID
, NULL CURRENCY_CODE
, NULL LEDGER_CATEGORY_CODE
, NULL COMPLETION_STATUS_CODE
FROM XLE_ENTITY_PROFILES LEP
WHERE TRANSACTING_ENTITY_FLAG = 'Y' UNION ALL /* LEDGER BY SECURITY PROFILE */ SELECT '2500' REPORTING_LEVEL
, GL.NAME ENTITY_NAME
, GL.LEDGER_ID ENTITY_ID
, -9999 OPERATING_UNIT_ID
, -9999 LEGAL_ENTITY_ID
, GL.LEDGER_ID LEDGER_ID
, GL.CURRENCY_CODE CURRENCY_CODE
, GL.LEDGER_CATEGORY_CODE LEDGER_CATEGORY_CODE
, LC.COMPLETION_STATUS_CODE COMPLETION_STATUS_CODE
FROM GL_LEDGERS_PUBLIC_ALL_V GL
, GL_LEDGER_CONFIGURATIONS LC
WHERE GL.CONFIGURATION_ID = LC.CONFIGURATION_ID UNION ALL /* OPERATING UNITS */ SELECT '3000' REPORTING_LEVEL
, O.NAME ENTITY_NAME
, O.ORGANIZATION_ID ENTITY_ID
, O.ORGANIZATION_ID OPERATING_UNIT_ID
, -9999 LEGAL_ENTITY_ID
, TO_NUMBER(O.SET_OF_BOOKS_ID) LEDGER_ID
, NULL CURRENCY_CODE
, NULL LEDGER_CATEGORY_CODE
, NULL COMPLETION_STATUS_CODE
FROM HR_OPERATING_UNITS O
WHERE MO_GLOBAL.CHECK_ACCESS(O.ORGANIZATION_ID) = 'Y'