FND Design Data [Home] [Help]

View: GL_AUTOMATIC_POSTING_SETS_V

Product: GL - General Ledger
Description:
Implementation/DBA Data: ViewAPPS.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

Name
ROW_ID
AUTOPOST_SET_ID
AUTOPOST_SET_NAME
CHART_OF_ACCOUNTS_ID
PERIOD_SET_NAME
ACCOUNTED_PERIOD_TYPE
ENABLED_FLAG
SECURITY_FLAG
SUBMIT_ALL_PRIORITIES_FLAG
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
DESCRIPTION
NUM_OF_PRIORITY_OPTIONS
EFFECTIVE_DAYS_BEFORE
EFFECTIVE_DAYS_AFTER
CONTEXT
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
VIEW_PRIVILEGE
USE_PRIVILEGE
MODIFY_PRIVILEGE