View: GL_CONS_MAP_SET_V

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

View Text

SELECT GCS.ROWID ROW_ID
, GCS.CONSOLIDATION_SET_ID CONSOLIDATION_SET_ID
, GCS.TO_LEDGER_ID PARENT_LEDGER_ID
, GCS.NAME CONSOLIDATION_SET_NAME
, LEDGER.NAME PARENT_LEDGER_NAME
, GCS.CREATION_DATE CREATION_DATE
, GCS.CREATED_BY CREATED_BY
, GCS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, GCS.LAST_UPDATED_BY LAST_UPDATED_BY
, GCS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, GCS.DESCRIPTION DESCRIPTION
, GCS.CONTEXT CONTEXT
, NVL(GCS.METHOD
, 'B') METHOD
, NVL(GCS.RUN_JOURNAL_IMPORT_FLAG
, 'N') RUN_JOURNAL_IMPORT_FLAG
, 'N' RUN_POSTING_FLAG
, NVL(GCS.AUDIT_MODE_FLAG
, 'N') AUDIT_MODE_FLAG
, DECODE(GCS.RUN_JOURNAL_IMPORT_FLAG
, 'N'
, 'N'
, NVL(GCS.SUMMARIZE_LINES_FLAG
, 'N')) SUMMARIZE_LINES_FLAG
, GCS.ATTRIBUTE1 ATTRIBUTE1
, GCS.ATTRIBUTE2 ATTRIBUTE2
, GCS.ATTRIBUTE3 ATTRIBUTE3
, GCS.ATTRIBUTE4 ATTRIBUTE4
, GCS.ATTRIBUTE5 ATTRIBUTE5
, GCS.ATTRIBUTE6 ATTRIBUTE6
, GCS.ATTRIBUTE7 ATTRIBUTE7
, GCS.ATTRIBUTE8 ATTRIBUTE8
, GCS.ATTRIBUTE9 ATTRIBUTE9
, GCS.ATTRIBUTE10 ATTRIBUTE10
, GCS.ATTRIBUTE11 ATTRIBUTE11
, GCS.ATTRIBUTE12 ATTRIBUTE12
, GCS.ATTRIBUTE13 ATTRIBUTE13
, GCS.ATTRIBUTE14 ATTRIBUTE14
, GCS.ATTRIBUTE15 ATTRIBUTE15
, GCS.SECURITY_FLAG SECURITY_FLAG
, DECODE(GCS.SECURITY_FLAG
, 'Y'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_CONSOLIDATION_SET_V'
, 'GL_DAS_CONSOLIDATION_SET'
, TO_CHAR(GCS.CONSOLIDATION_SET_ID)
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y') VIEW_PRIVILEGE
, DECODE(GCS.SECURITY_FLAG
, 'Y'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_CONSOLIDATION_SET_U'
, 'GL_DAS_CONSOLIDATION_SET'
, TO_CHAR(GCS.CONSOLIDATION_SET_ID)
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y') USE_PRIVILEGE
, DECODE(GCS.SECURITY_FLAG
, 'Y'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_CONSOLIDATION_SET_M'
, 'GL_DAS_CONSOLIDATION_SET'
, TO_CHAR(GCS.CONSOLIDATION_SET_ID)
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y') MODIFY_PRIVILEGE FROM GL_LEDGERS LEDGER
, GL_CONSOLIDATION_SETS GCS
WHERE GCS.TO_LEDGER_ID = LEDGER.LEDGER_ID

Columns