VIEW: APPS.IGI_EER_SETUP_V

Source

View Text - Preformatted

SELECT /*+ORDERED */ 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 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

View Text - HTML Formatted

SELECT /*+ORDERED */ 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 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