GL Chart of Accounts Structure

This is used when implementing multiple charts of accounts to ensure consistent setup across countries and between environments.

Where clause can be added or commented out to just look at specific countries.

SELECT  FST.ID_FLEX_STRUCTURE_NAME

--,    FST.DESCRIPTION

--,    FST.ID_FLEX_NUM

--,    FST.ID_FLEX_STRUCTURE_CODE

,      FST.CROSS_SEGMENT_VALIDATION_FLAG"X-VAL"

,      FST.FREEZE_STRUCTURED_HIER_FLAG"FZ-HIER"

,      FST.FREEZE_FLEX_DEFINITION_FLAG"FZ-DEFN"

,      FSEG.SEGMENT_NUM "SEG#"

,      FSEG.SEGMENT_NAME "SEG NAME"

,      VS.FLEX_VALUE_SET_NAME "VALUE SET"

,      FSEG.FLEX_VALUE_SET_ID"VAL_SET_ID"

,      FSEG.DEFAULT_TYPE"DEF TYPE"

,      FSEG.DEFAULT_VALUE"DEF. VALUE"

,      FSEG.ENABLED_FLAG"ENBLD"

,      FSEG.REQUIRED_FLAG"REQD"

FROM FND_ID_FLEX_STRUCTURES_VL FST, FND_ID_FLEX_SEGMENTS FSEG, FND_FLEX_VALUE_SETS VS

WHERE FST.ID_FLEX_NUM = FSEG.ID_FLEX_NUM

AND FSEG.FLEX_VALUE_SET_ID = VS.FLEX_VALUE_SET_ID

--AND SUBSTR(FST.ID_FLEX_STRUCTURE_CODE,1,2) IN ('BE','LU','ES','IT','HU','CZ','PL','RU')

AND FST.APPLICATION_ID = 101

AND FST.ID_FLEX_CODE = 'GL#'

ORDER BY 1, FSEG.SEGMENT_NUM