View: AR_CORRECT_GL_ACCOUNTS_V

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.AR_CORRECT_GL_ACCOUNTS_V

View Text

SELECT DISTINCT ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING( DECODE(ACC.DISTRIBUTION_TYPE
, 'REC'
, 'DISTRIBUTION_SOURCE_TYPE'
, DECODE(ACC.SOURCE_TABLE
, 'GLD'
, 'AUTOGL_TYPE'
, 'DISTRIBUTION_SOURCE_TYPE'))
, ACC.DISTRIBUTION_TYPE)
, ACC.DISTRIBUTION_TYPE DISTRIBUTION_TYPE
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING( DECODE(ACC.SOURCE_TABLE
, 'GLD'
, 'INV/CM/ADJ'
, 'ARRGTA_CATEGORIES')
, ACC.CATEGORY_TYPE)
, ACC.CATEGORY_TYPE CATEGORY_TYPE
, ACC.CODE_COMBINATION_ID CODE_COMBINATION_ID
, ACC.NEW_CODE_COMBINATION_ID NEW_CODE_COMBINATION_ID
FROM AR_CCID_CORRECTIONS ACC
WHERE SUBMISSION_ID IS NULL

Columns