VIEW: APPS.GL_ALLOC_BATCHES_V

Source

View Text - Preformatted

SELECT ab.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, ab.last_update_date LAST_UPDATE_DATE, ab.last_updated_by LAST_UPDATED_BY, ab.creation_date CREATION_DATE, ab.created_by CREATED_BY, ab.last_update_login LAST_UPDATE_LOGIN, ab.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, l.meaning show_validation_status, ab.validation_request_id validation_request_id, ab.validation_status validation_status FROM gl_alloc_batches ab, gl_lookups l WHERE l.lookup_type(+) = 'VALIDATION_STATUS' AND l.lookup_code(+) = ab.validation_status

View Text - HTML Formatted

SELECT AB.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
, AB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AB.LAST_UPDATED_BY LAST_UPDATED_BY
, AB.CREATION_DATE CREATION_DATE
, AB.CREATED_BY CREATED_BY
, AB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, AB.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
, L.MEANING SHOW_VALIDATION_STATUS
, AB.VALIDATION_REQUEST_ID VALIDATION_REQUEST_ID
, AB.VALIDATION_STATUS VALIDATION_STATUS
FROM GL_ALLOC_BATCHES AB
, GL_LOOKUPS L
WHERE L.LOOKUP_TYPE(+) = 'VALIDATION_STATUS'
AND L.LOOKUP_CODE(+) = AB.VALIDATION_STATUS