VIEW: APPS.GL_RECURRING_BATCHES_V

Source

View Text - Preformatted

SELECT b.last_executed_period_name LE_PERIOD_NAME, b.last_executed_date LE_DATE, b.name AB_NAME, b.last_executed_period_name AB_LE_PERIOD_NAME, b.last_exec_journal_date AB_LE_JE_DATE, b.last_exec_calculation_date AB_LE_CE_DATE, v.budget_name AB_LE_BUDGET, l.name LEDGER_NAME, b.rowid ROW_ID, b.recurring_batch_id RECURRING_BATCH_ID, b.last_update_date LAST_UPDATE_DATE, b.last_updated_by LAST_UPDATED_BY, b.ledger_id LEDGER_ID, b.security_flag SECURITY_FLAG, decode(security_flag, 'Y', decode(budget_flag, 'N', decode(fnd_data_security.check_function(1.0, 'GL_DAS_RECURRING_JOURNAL_V', '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_V', 'GL_DAS_BUDGET_FORMULA', to_char(recurring_batch_id), null, null, null, null, fnd_global.user_name), 'T', 'Y', 'N')), 'Y') view_privilege, 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, decode(security_flag, 'Y', decode(budget_flag, 'N', decode(fnd_data_security.check_function(1.0, 'GL_DAS_RECURRING_JOURNAL_M', '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_M', 'GL_DAS_BUDGET_FORMULA', to_char(recurring_batch_id), null, null, null, null, fnd_global.user_name), 'T', 'Y', 'N')), 'Y') modify_privilege, b.recurring_batch_type RECURRING_BATCH_TYPE, b.chart_of_accounts_id CHART_OF_ACCOUNTS_ID, b.period_set_name PERIOD_SET_NAME, b.accounted_period_type ACCOUNTED_PERIOD_TYPE, b.name NAME, b.budget_flag BUDGET_FLAG, b.allocation_flag ALLOCATION_FLAG, b.creation_date CREATION_DATE, b.created_by CREATED_BY, b.last_update_login LAST_UPDATE_LOGIN, b.budget_in_formula_flag BUDGET_IN_FORMULA_FLAG, b.description DESCRIPTION, b.period_type PERIOD_TYPE, b.last_executed_period_name LAST_EXECUTED_PERIOD_NAME, b.last_executed_date LAST_EXECUTED_DATE, b.last_exec_journal_date LAST_EXEC_JOURNAL_DATE, b.last_exec_calculation_date LAST_EXEC_CALCULATION_DATE, b.last_exec_budget_version_id LAST_EXEC_BUDGET_VERSION_ID, b.ATTRIBUTE1 ATTRIBUTE1, b.ATTRIBUTE2 ATTRIBUTE2, b.ATTRIBUTE3 ATTRIBUTE3, b.ATTRIBUTE4 ATTRIBUTE4, b.ATTRIBUTE5 ATTRIBUTE5, b.ATTRIBUTE6 ATTRIBUTE6, b.ATTRIBUTE7 ATTRIBUTE7, b.ATTRIBUTE8 ATTRIBUTE8, b.ATTRIBUTE9 ATTRIBUTE9, b.ATTRIBUTE10 ATTRIBUTE10, b.CONTEXT CONTEXT FROM gl_recurring_batches b, gl_budget_versions v, gl_ledgers l WHERE b.ledger_id = l.ledger_id(+) AND b.last_exec_budget_version_id = v.budget_version_id (+)

View Text - HTML Formatted

SELECT B.LAST_EXECUTED_PERIOD_NAME LE_PERIOD_NAME
, B.LAST_EXECUTED_DATE LE_DATE
, B.NAME AB_NAME
, B.LAST_EXECUTED_PERIOD_NAME AB_LE_PERIOD_NAME
, B.LAST_EXEC_JOURNAL_DATE AB_LE_JE_DATE
, B.LAST_EXEC_CALCULATION_DATE AB_LE_CE_DATE
, V.BUDGET_NAME AB_LE_BUDGET
, L.NAME LEDGER_NAME
, B.ROWID ROW_ID
, B.RECURRING_BATCH_ID RECURRING_BATCH_ID
, B.LAST_UPDATE_DATE LAST_UPDATE_DATE
, B.LAST_UPDATED_BY LAST_UPDATED_BY
, B.LEDGER_ID LEDGER_ID
, B.SECURITY_FLAG SECURITY_FLAG
, DECODE(SECURITY_FLAG
, 'Y'
, DECODE(BUDGET_FLAG
, 'N'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_RECURRING_JOURNAL_V'
, '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_V'
, 'GL_DAS_BUDGET_FORMULA'
, TO_CHAR(RECURRING_BATCH_ID)
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N'))
, 'Y') VIEW_PRIVILEGE
, 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
, DECODE(SECURITY_FLAG
, 'Y'
, DECODE(BUDGET_FLAG
, 'N'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_RECURRING_JOURNAL_M'
, '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_M'
, 'GL_DAS_BUDGET_FORMULA'
, TO_CHAR(RECURRING_BATCH_ID)
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N'))
, 'Y') MODIFY_PRIVILEGE
, B.RECURRING_BATCH_TYPE RECURRING_BATCH_TYPE
, B.CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID
, B.PERIOD_SET_NAME PERIOD_SET_NAME
, B.ACCOUNTED_PERIOD_TYPE ACCOUNTED_PERIOD_TYPE
, B.NAME NAME
, B.BUDGET_FLAG BUDGET_FLAG
, B.ALLOCATION_FLAG ALLOCATION_FLAG
, B.CREATION_DATE CREATION_DATE
, B.CREATED_BY CREATED_BY
, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, B.BUDGET_IN_FORMULA_FLAG BUDGET_IN_FORMULA_FLAG
, B.DESCRIPTION DESCRIPTION
, B.PERIOD_TYPE PERIOD_TYPE
, B.LAST_EXECUTED_PERIOD_NAME LAST_EXECUTED_PERIOD_NAME
, B.LAST_EXECUTED_DATE LAST_EXECUTED_DATE
, B.LAST_EXEC_JOURNAL_DATE LAST_EXEC_JOURNAL_DATE
, B.LAST_EXEC_CALCULATION_DATE LAST_EXEC_CALCULATION_DATE
, B.LAST_EXEC_BUDGET_VERSION_ID LAST_EXEC_BUDGET_VERSION_ID
, B.ATTRIBUTE1 ATTRIBUTE1
, B.ATTRIBUTE2 ATTRIBUTE2
, B.ATTRIBUTE3 ATTRIBUTE3
, B.ATTRIBUTE4 ATTRIBUTE4
, B.ATTRIBUTE5 ATTRIBUTE5
, B.ATTRIBUTE6 ATTRIBUTE6
, B.ATTRIBUTE7 ATTRIBUTE7
, B.ATTRIBUTE8 ATTRIBUTE8
, B.ATTRIBUTE9 ATTRIBUTE9
, B.ATTRIBUTE10 ATTRIBUTE10
, B.CONTEXT CONTEXT
FROM GL_RECURRING_BATCHES B
, GL_BUDGET_VERSIONS V
, GL_LEDGERS L
WHERE B.LEDGER_ID = L.LEDGER_ID(+)
AND B.LAST_EXEC_BUDGET_VERSION_ID = V.BUDGET_VERSION_ID (+)