AR_GL_SEGMENTS_REF_V

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name
AR_GL_CODE_COMBINATION_ID AR_GL_BALACING_SEGMENT_VALUE AR_GL_NATURAL_SEGMENT_VALUE

Query

SQL_Statement
SELECT gcc.code_combination_id AR_GL_CODE_COMBINATION_ID, arp_xla_extract_main_pkg.the_segment_value(gcc.chart_of_accounts_id, 'GL_BALANCING',gcc.code_combination_id) AR_GL_BALACING_SEGMENT_VALUE, arp_xla_extract_main_pkg.the_segment_value(gcc.chart_of_accounts_id, 'GL_ACCOUNT',gcc.code_combination_id) AR_GL_NATURAL_SEGMENT_VALUE FROM gl_code_combinations gcc