VIEW: APPS.GL_REC_BATCHES_LOV_V

Source

View Text - Preformatted

SELECT name NAME, description DESCRIPTION, recurring_batch_id RECURRING_BATCH_ID, chart_of_accounts_id CHART_OF_ACCOUNTS_ID, period_set_name PERIOD_SET_NAME, accounted_period_type ACCOUNTED_PERIOD_TYPE, budget_flag BUDGET_FLAG, decode(security_flag, 'Y', decode(budget_flag, 'N', decode(fnd_data_security.check_function(1.0, 'GL_DAS_RECURRING_JOURNAL_U', 'GL_DAS_RECURRING_JOURNAL', to_char(recurring_batch_id), null, null, null, null, fnd_global.user_name), 'T', 'Y','N'), decode(fnd_data_security.check_function(1.0, 'GL_DAS_BUDGET_FORMULA_U', 'GL_DAS_BUDGET_FORMULA', to_char(recurring_batch_id), null, null, null, null, fnd_global.user_name), 'T', 'Y', 'N')), 'Y') USE_PRIVILEGE FROM gl_recurring_batches

View Text - HTML Formatted

SELECT NAME NAME
, DESCRIPTION DESCRIPTION
, RECURRING_BATCH_ID RECURRING_BATCH_ID
, CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID
, PERIOD_SET_NAME PERIOD_SET_NAME
, ACCOUNTED_PERIOD_TYPE ACCOUNTED_PERIOD_TYPE
, BUDGET_FLAG BUDGET_FLAG
, DECODE(SECURITY_FLAG
, 'Y'
, DECODE(BUDGET_FLAG
, 'N'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_RECURRING_JOURNAL_U'
, 'GL_DAS_RECURRING_JOURNAL'
, TO_CHAR(RECURRING_BATCH_ID)
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_BUDGET_FORMULA_U'
, 'GL_DAS_BUDGET_FORMULA'
, TO_CHAR(RECURRING_BATCH_ID)
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N'))
, 'Y') USE_PRIVILEGE
FROM GL_RECURRING_BATCHES