View: GL_RECURRING_BATCHES_V

Product:	GL - General Ledger
Description:	10SC ONLY
Implementation/DBA Data:	APPS.GL_RECURRING_BATCHES_V

View Text

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 (+)

Columns