View: GL_SRS_JI_LEDGERS_V

Product:	GL - General Ledger
Description:
Implementation/DBA Data:	APPS.GL_SRS_JI_LEDGERS_V

View Text

SELECT ACC.ACCESS_SET_ID
, SRC.JE_SOURCE_NAME
, LGR.LEDGER_ID
, LGR.NAME LEDGER_NAME
FROM GL_JE_SOURCES SRC
, GL_ACCESS_SET_LEDGERS ACC
, GL_LEDGERS LGR
WHERE ACC.ACCESS_PRIVILEGE_CODE IN ('B'
, 'F')
AND LGR.LEDGER_ID = ACC.LEDGER_ID
AND EXISTS (SELECT 'HAS DATA'
FROM GL_INTERFACE INT
WHERE ( INT.USER_JE_SOURCE_NAME = DECODE(ACC.LEDGER_ID
, NULL
, NULL
, DECODE(SRC.IMPORT_USING_KEY_FLAG
, 'Y'
, SRC.JE_SOURCE_KEY
, SRC.USER_JE_SOURCE_NAME))
AND INT.LEDGER_ID = -1
AND INT.SET_OF_BOOKS_ID = ACC.LEDGER_ID) OR ( INT.USER_JE_SOURCE_NAME = DECODE(ACC.LEDGER_ID
, NULL
, NULL
, DECODE(SRC.IMPORT_USING_KEY_FLAG
, 'Y'
, SRC.JE_SOURCE_KEY
, SRC.USER_JE_SOURCE_NAME))
AND INT.SET_OF_BOOKS_ID IN (-1
, ACC.LEDGER_ID)
AND INT.LEDGER_ID = ACC.LEDGER_ID)) UNION SELECT ACC.ACCESS_SET_ID
, IC.JE_SOURCE_NAME
, IC.SET_OF_BOOKS_ID LEDGER_ID
, LGR.NAME LEDGER_NAME
FROM GL_INTERFACE_CONTROL IC
, GL_ACCESS_SET_LEDGERS ACC
, GL_LEDGERS LGR
WHERE IC.GROUP_ID IS NOT NULL
AND NVL(UPPER(IC.INTERFACE_TABLE_NAME)
, 'GL_INTERFACE') <> 'GL_INTERFACE'
AND ACC.ACCESS_PRIVILEGE_CODE IN ('B'
, 'F')
AND ACC.LEDGER_ID = IC.SET_OF_BOOKS_ID
AND LGR.LEDGER_ID = ACC.LEDGER_ID GROUP BY ACC.ACCESS_SET_ID
, LGR.LEDGER_ID
, LGR.NAME
, IC.JE_SOURCE_NAME
, IC.SET_OF_BOOKS_ID

Columns