SELECT gcc.code_combination_id , arp_xla_extract_main_pkg.the_segment_value (gcc.chart_of_accounts_id, 'GL_BALANCING',gcc.code_combination_id) , arp_xla_extract_main_pkg.the_segment_value (gcc.chart_of_accounts_id, 'GL_ACCOUNT',gcc.code_combination_id) FROM gl_code_combinations gcc
SELECT GCC.CODE_COMBINATION_ID
, ARP_XLA_EXTRACT_MAIN_PKG.THE_SEGMENT_VALUE (GCC.CHART_OF_ACCOUNTS_ID
, 'GL_BALANCING'
, GCC.CODE_COMBINATION_ID)
, ARP_XLA_EXTRACT_MAIN_PKG.THE_SEGMENT_VALUE (GCC.CHART_OF_ACCOUNTS_ID
, 'GL_ACCOUNT'
, GCC.CODE_COMBINATION_ID)
FROM GL_CODE_COMBINATIONS GCC
|
|
|