(GL Accounts) GL_Code_Combinations Segment Wise Values & Description - Oracle EBS R12

http://generalledger-gl.blogspot.com/2016/10/glcodecombinations-segment-wise-values.html

(GL Accounts) GL_Code_Combinations Segment Wise Values & Description 

CREATE OR REPLACE VIEW GL_COA AS

SELECT

GCC.CODE_COMBINATION_ID,

GCC.SEGMENT1,

FS1.DESCRIPTION DESCRIPTION1,

GCC.SEGMENT2,

FS2.DESCRIPTION DESCRIPTION2,

GCC.SEGMENT3,

FS3.DESCRIPTION DESCRIPTION3,

GCC.SEGMENT4,

FS4.DESCRIPTION DESCRIPTION4,

GCC.SEGMENT5,

FS5.DESCRIPTION DESCRIPTION5,

GCC.SEGMENT6,

FS6.DESCRIPTION DESCRIPTION6,

GCC.SEGMENT7,

FS7.DESCRIPTION DESCRIPTION7,

GCC.SEGMENT8,

FS8.DESCRIPTION DESCRIPTION8

FROM

GL_CODE_COMBINATIONS GCC,

fnd_flex_values_vl  FS1,

fnd_flex_values_vl  FS2,

fnd_flex_values_vl  FS3,

fnd_flex_values_vl  FS4,

fnd_flex_values_vl  FS5,

fnd_flex_values_vl  FS6,

fnd_flex_values_vl  FS7,

fnd_flex_values_vl  FS8

WHERE ( GCC.CHART_OF_ACCOUNTS_ID=311254  )

AND   ( FS8.FLEX_VALUE=GCC.SEGMENT8  )

AND   ( FS7.FLEX_VALUE=GCC.SEGMENT7  )

AND   ( FS6.FLEX_VALUE=GCC.SEGMENT6  )

AND   ( FS5.FLEX_VALUE=GCC.SEGMENT5  )

AND   ( FS4.FLEX_VALUE=GCC.SEGMENT4  )

AND   ( FS3.FLEX_VALUE=GCC.SEGMENT3  )

AND   ( FS2.FLEX_VALUE=GCC.SEGMENT2  )

AND   ( FS1.FLEX_VALUE=GCC.SEGMENT1  )

AND   ( FS1.FLEX_VALUE_SET_ID  = 9214 AND FS1.SUMMARY_FLAG = 'N')

AND   ( FS2.FLEX_VALUE_SET_ID  = 9215 AND FS2.SUMMARY_FLAG = 'N')

AND   ( FS3.FLEX_VALUE_SET_ID  = 9216 AND FS3.SUMMARY_FLAG = 'N')

AND   ( FS4.FLEX_VALUE_SET_ID  = 9217 AND FS4.SUMMARY_FLAG = 'N')

AND   ( FS5.FLEX_VALUE_SET_ID  = 9218 AND FS5.SUMMARY_FLAG = 'N')

AND   ( FS6.FLEX_VALUE_SET_ID  = 9219 AND FS6.SUMMARY_FLAG = 'N')

AND   ( FS7.FLEX_VALUE_SET_ID  = 9220 AND FS7.SUMMARY_FLAG = 'N')

AND   ( FS8.FLEX_VALUE_SET_ID  = 9221 AND FS8.SUMMARY_FLAG = 'N')