[Home] [Help]
View: AR_GL_SEGMENTS_REF_V
Product: | AR - Receivables |
Description: | This is a reference view to return Balancing segment and Natural Account sources |
Implementation/DBA Data: |
APPS.AR_GL_SEGMENTS_REF_V
|
View Text
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
Columns
Name |
AR_GL_CODE_COMBINATION_ID |
AR_GL_BALACING_SEGMENT_VALUE |
AR_GL_NATURAL_SEGMENT_VALUE |