View: GL_AUTOMATIC_POSTING_SETS_V

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

View Text

SELECT SETS.ROWID ROW_ID
, SETS.AUTOPOST_SET_ID AUTOPOST_SET_ID
, SETS.AUTOPOST_SET_NAME AUTOPOST_SET_NAME
, SETS.CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID
, SETS.PERIOD_SET_NAME PERIOD_SET_NAME
, SETS.ACCOUNTED_PERIOD_TYPE ACCOUNTED_PERIOD_TYPE
, SETS.ENABLED_FLAG ENABLED_FLAG
, SETS.SECURITY_FLAG SECURITY_FLAG
, SETS.SUBMIT_ALL_PRIORITIES_FLAG SUBMIT_ALL_PRIORITIES_FLAG
, SETS.CREATION_DATE CREATION_DATE
, SETS.CREATED_BY CREATED_BY
, SETS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SETS.LAST_UPDATED_BY LAST_UPDATED_BY
, SETS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SETS.DESCRIPTION DESCRIPTION
, DECODE(SETS.SUBMIT_ALL_PRIORITIES_FLAG
, 'Y'
, NULL
, DECODE(SETS.NUM_OF_PRIORITY_OPTIONS
, NULL
, 1
, SETS.NUM_OF_PRIORITY_OPTIONS)) NUM_OF_PRIORITY_OPTIONS
, SETS.EFFECTIVE_DAYS_BEFORE EFFECTIVE_DAYS_BEFORE
, SETS.EFFECTIVE_DAYS_AFTER EFFECTIVE_DAYS_AFTER
, SETS.CONTEXT CONTEXT
, SETS.ATTRIBUTE1 ATTRIBUTE1
, SETS.ATTRIBUTE2 ATTRIBUTE2
, SETS.ATTRIBUTE3 ATTRIBUTE3
, SETS.ATTRIBUTE4 ATTRIBUTE4
, SETS.ATTRIBUTE5 ATTRIBUTE5
, SETS.ATTRIBUTE6 ATTRIBUTE6
, SETS.ATTRIBUTE7 ATTRIBUTE7
, SETS.ATTRIBUTE8 ATTRIBUTE8
, SETS.ATTRIBUTE9 ATTRIBUTE9
, SETS.ATTRIBUTE10 ATTRIBUTE10
, SETS.ATTRIBUTE11 ATTRIBUTE11
, SETS.ATTRIBUTE12 ATTRIBUTE12
, SETS.ATTRIBUTE13 ATTRIBUTE13
, SETS.ATTRIBUTE14 ATTRIBUTE14
, SETS.ATTRIBUTE15 ATTRIBUTE15
, DECODE(SECURITY_FLAG
, 'Y'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_AUTOPOST_SET_V'
, 'GL_DAS_AUTOPOST_SET'
, TO_CHAR(AUTOPOST_SET_ID)
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y') VIEW_PRIVILEGE
, DECODE(SECURITY_FLAG
, 'Y'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_AUTOPOST_SET_U'
, 'GL_DAS_AUTOPOST_SET'
, TO_CHAR(AUTOPOST_SET_ID)
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y') USE_PRIVILEGE
, DECODE(SECURITY_FLAG
, 'Y'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_AUTOPOST_SET_M'
, 'GL_DAS_AUTOPOST_SET'
, TO_CHAR(AUTOPOST_SET_ID)
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y') MODIFY_PRIVILEGE
FROM GL_AUTOMATIC_POSTING_SETS SETS

Columns