View: GL_ACCESS_SETS_V

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

View Text

SELECT GA.ROWID ROW_ID
, GA.ACCESS_SET_ID ACCESS_SET_ID
, GA.NAME NAME
, GA.SECURITY_SEGMENT_CODE SECURITY_SEGMENT_CODE
, GA.ENABLED_FLAG ENABLED_FLAG
, GA.CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID
, FS.ID_FLEX_STRUCTURE_NAME CHART_OF_ACCOUNTS_NAME
, GA.PERIOD_SET_NAME PERIOD_SET_NAME
, GPT.USER_PERIOD_TYPE USER_PERIOD_TYPE
, GA.ACCOUNTED_PERIOD_TYPE ACCOUNTED_PERIOD_TYPE
, GA.AUTOMATICALLY_CREATED_FLAG AUTOMATICALLY_CREATED_FLAG
, GA.LAST_UPDATE_DATE LAST_UPDATE_DATE
, GA.LAST_UPDATED_BY LAST_UPDATED_BY
, GA.CREATION_DATE CREATION_DATE
, GA.CREATED_BY CREATED_BY
, GA.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, GA.SECURED_SEG_VALUE_SET_ID SECURED_SEG_VALUE_SET_ID
, GA.DEFAULT_LEDGER_ID DEFAULT_LEDGER_ID
, GLD.NAME DEFAULT_LEDGER_NAME
, GA.DESCRIPTION DESCRIPTION
, GA.CONTEXT CONTEXT
, GA.ATTRIBUTE1 ATTRIBUTE1
, GA.ATTRIBUTE2 ATTRIBUTE2
, GA.ATTRIBUTE3 ATTRIBUTE3
, GA.ATTRIBUTE4 ATTRIBUTE4
, GA.ATTRIBUTE5 ATTRIBUTE5
, GA.ATTRIBUTE6 ATTRIBUTE6
, GA.ATTRIBUTE7 ATTRIBUTE7
, GA.ATTRIBUTE8 ATTRIBUTE8
, GA.ATTRIBUTE9 ATTRIBUTE9
, GA.ATTRIBUTE10 ATTRIBUTE10
, GA.ATTRIBUTE11 ATTRIBUTE11
, GA.ATTRIBUTE12 ATTRIBUTE12
, GA.ATTRIBUTE13 ATTRIBUTE13
, GA.ATTRIBUTE14 ATTRIBUTE14
, GA.ATTRIBUTE15 ATTRIBUTE15
FROM FND_ID_FLEX_STRUCTURES_TL FS
, GL_ACCESS_SETS GA
, GL_PERIOD_TYPES GPT
, GL_LEDGERS GLD
WHERE FS.APPLICATION_ID = 101
AND FS.ID_FLEX_CODE = 'GL#'
AND FS.ID_FLEX_NUM = GA.CHART_OF_ACCOUNTS_ID
AND FS.LANGUAGE = USERENV('LANG')
AND GPT.PERIOD_TYPE = GA.ACCOUNTED_PERIOD_TYPE
AND GLD.LEDGER_ID (+) = GA.DEFAULT_LEDGER_ID

Columns