VIEW: APPS.GL_AUTOMATIC_POSTING_SETS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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