View: GL_CONS_SET_NAMES_V

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

View Text

SELECT CONS.CONSOLIDATION_SET_ID CONSOLIDATION_SET_ID
, CONS.NAME CONS_SET_NAME
, CONS.DESCRIPTION DESCRIPTION
, CONS.TO_LEDGER_ID TO_LEDGER_ID
, NVL(CONS.RUN_JOURNAL_IMPORT_FLAG
, 'Y') JOURNAL_IMPORT_FLAG
, NVL(CONS.RUN_POSTING_FLAG
, 'N') RUN_POSTING_FLAG
, NVL(CONS.SUMMARIZE_LINES_FLAG
, 'Y') SUMMARIZE_LINES_FLAG
, NVL(CONS.AUDIT_MODE_FLAG
, 'N') AUDIT_MODE_FLAG
, CONS.METHOD METHOD_CODE
, L.MEANING METHOD_MEANING
, LGR.CURRENCY_CODE CURRENCY_CODE
, LGR.CONSOLIDATION_LEDGER_FLAG CONS_LEDGER_FLAG
, LGR.ENABLE_AVERAGE_BALANCES_FLAG ADB_FLAG
, LGR.PERIOD_SET_NAME CALENDAR
, LGR.ACCOUNTED_PERIOD_TYPE PERIOD_TYPE
, LGR.SHORT_NAME TO_SHORT_NAME
, LGR.NAME TO_LEDGER_NAME
, LGR.DESCRIPTION TO_LEDGER_DESC
, DECODE(CONS.SECURITY_FLAG
, 'Y'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_CONSOLIDATION_SET_V'
, 'GL_DAS_CONSOLIDATION_SET'
, TO_CHAR(CONS.CONSOLIDATION_SET_ID)
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y') VIEW_PRIVILEGE
, DECODE(CONS.SECURITY_FLAG
, 'Y'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_CONSOLIDATION_SET_U'
, 'GL_DAS_CONSOLIDATION_SET'
, TO_CHAR(CONS.CONSOLIDATION_SET_ID)
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y') USE_PRIVILEGE
, DECODE(CONS.SECURITY_FLAG
, 'Y'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_CONSOLIDATION_SET_M'
, 'GL_DAS_CONSOLIDATION_SET'
, TO_CHAR(CONS.CONSOLIDATION_SET_ID)
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y') MODIFY_PRIVILEGE
FROM GL_LOOKUPS L
, GL_LEDGERS LGR
, GL_CONSOLIDATION_SETS CONS
WHERE CONS.TO_LEDGER_ID = LGR.LEDGER_ID
AND L.LOOKUP_TYPE = 'CONSOLIDATION_METHOD'
AND L.LOOKUP_CODE = CONS.METHOD

Columns