View: GL_ALLOC_BATCHES_V

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

View Text

SELECT ROWID ROW_ID
, ALLOCATION_BATCH_ID ALLOCATION_BATCH_ID
, NAME NAME
, CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID
, ACTUAL_FLAG ACTUAL_FLAG
, SECURITY_FLAG SECURITY_FLAG
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, DESCRIPTION DESCRIPTION
, DECODE(SECURITY_FLAG
, 'Y'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, DECODE(ACTUAL_FLAG
, 'B'
, 'GL_DAS_MASSBUDGET_V'
, 'GL_DAS_MASSALLOCATION_V')
, DECODE(ACTUAL_FLAG
, 'B'
, 'GL_DAS_MASSBUDGET'
, 'GL_DAS_MASSALLOCATION')
, TO_CHAR(ALLOCATION_BATCH_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
, DECODE(ACTUAL_FLAG
, 'B'
, 'GL_DAS_MASSBUDGET_U'
, 'GL_DAS_MASSALLOCATION_U')
, DECODE(ACTUAL_FLAG
, 'B'
, 'GL_DAS_MASSBUDGET'
, 'GL_DAS_MASSALLOCATION')
, TO_CHAR(ALLOCATION_BATCH_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
, DECODE(ACTUAL_FLAG
, 'B'
, 'GL_DAS_MASSBUDGET_M'
, 'GL_DAS_MASSALLOCATION_M')
, DECODE(ACTUAL_FLAG
, 'B'
, 'GL_DAS_MASSBUDGET'
, 'GL_DAS_MASSALLOCATION')
, TO_CHAR(ALLOCATION_BATCH_ID)
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y') MODIFY_PRIVILEGE
FROM GL_ALLOC_BATCHES

Columns