VIEW: APPS.AR_CORRECT_GL_ACCOUNTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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