View: GL_REC_BATCHES_LOV_V

Product:	GL - General Ledger
Description:
Implementation/DBA Data:	APPS.GL_REC_BATCHES_LOV_V

View Text

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

Columns