Product: | IGI - Public Sector Financials International |
---|---|
Description: | Based on IGI_EER_SETUP, FND_ID_FLEX_SEGMENTS and GL_SETS_OF_BOOKS |
Implementation/DBA Data: | APPS.IGI_EER_SETUP_V |
SELECT DISTINCT EER.ROWID ROW_ID
, EER.GL_SET_OF_BOOKS_ID
, SOB.NAME D_SOB_NAME
, SOB.CHART_OF_ACCOUNTS_ID COA_ID
, EER.LEVEL_1
, FND1.SEGMENT_NAME D_NAME_1
, FND1.APPLICATION_COLUMN_NAME LEVEL_1_SEG
, EER.LEVEL_2
, FND2.SEGMENT_NAME D_NAME_2
, FND2.APPLICATION_COLUMN_NAME LEVEL_2_SEG
, EER.LEVEL_3
, FND3.SEGMENT_NAME D_NAME_3
, FND3.APPLICATION_COLUMN_NAME LEVEL_3_SEG
, EER.LEVEL_4
, FND4.SEGMENT_NAME D_NAME_4
, FND4.APPLICATION_COLUMN_NAME LEVEL_4_SEG
, DECODE(EER.LEVEL_5
, NULL
, ''
, EER.LEVEL_5) LEVEL_5
, DECODE(EER.LEVEL_5
, NULL
, ''
, FND5.SEGMENT_NAME) D_NAME_5
, DECODE(EER.LEVEL_5
, NULL
, ''
, FND5.APPLICATION_COLUMN_NAME) LEVEL_5_SEG
, DECODE(EER.LEVEL_6
, NULL
, ''
, EER.LEVEL_6) LEVEL_6
, DECODE(EER.LEVEL_6
, NULL
, ''
, FND6.SEGMENT_NAME) D_NAME_6
, DECODE(EER.LEVEL_6
, NULL
, ''
, FND6.APPLICATION_COLUMN_NAME) LEVEL_6_SEG
, EER.CREATION_DATE
, EER.CREATED_BY
, EER.LAST_UPDATE_LOGIN
, EER.LAST_UPDATE_DATE
, EER.LAST_UPDATED_BY
FROM FND_ID_FLEX_SEGMENTS FND1
, GL_SETS_OF_BOOKS SOB
, IGI_EER_SETUP EER
, FND_ID_FLEX_SEGMENTS FND2
, FND_ID_FLEX_SEGMENTS FND3
, FND_ID_FLEX_SEGMENTS FND4
, FND_ID_FLEX_SEGMENTS FND5
, FND_ID_FLEX_SEGMENTS FND6
WHERE EER.GL_SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
AND FND1.ID_FLEX_NUM = SOB.CHART_OF_ACCOUNTS_ID
AND FND1.ID_FLEX_CODE ='GL#'
AND FND1.SEGMENT_NUM = EER.LEVEL_1
AND FND2.ID_FLEX_NUM = SOB.CHART_OF_ACCOUNTS_ID
AND FND2.ID_FLEX_CODE ='GL#'
AND FND2.SEGMENT_NUM = EER.LEVEL_2
AND FND3.ID_FLEX_NUM = SOB.CHART_OF_ACCOUNTS_ID
AND FND3.ID_FLEX_CODE ='GL#'
AND FND3.SEGMENT_NUM = EER.LEVEL_3
AND FND4.ID_FLEX_NUM = SOB.CHART_OF_ACCOUNTS_ID
AND FND4.ID_FLEX_CODE ='GL#'
AND FND4.SEGMENT_NUM = EER.LEVEL_4
AND FND5.ID_FLEX_NUM = SOB.CHART_OF_ACCOUNTS_ID
AND FND5.ID_FLEX_CODE ='GL#'
AND FND5.SEGMENT_NUM = DECODE(EER.LEVEL_5
, NULL
, FND4.SEGMENT_NUM
, EER.LEVEL_5)
AND FND5.ID_FLEX_NUM = SOB.CHART_OF_ACCOUNTS_ID
AND FND6.ID_FLEX_CODE ='GL#'
AND FND6.SEGMENT_NUM = DECODE(EER.LEVEL_6
, NULL
, FND4.SEGMENT_NUM
, EER.LEVEL_6)
AND FND6.ID_FLEX_NUM = SOB.CHART_OF_ACCOUNTS_ID