SELECT FV.FLEX_VALUE ID , FV.FLEX_VALUE VALUE , FM.STRUCTURE_NUM CHART_OF_ACCOUNTS_ID , FV.FLEX_VALUE FLEX_VALUE , FV.DESCRIPTION DESCRIPTION , TO_CHAR(SOB.SET_OF_BOOKS_ID) SET_OF_BOOKS_ID FROM GL_SETS_OF_BOOKS SOB , BIS_FLEX_MAPPINGS_V FM , FND_FLEX_VALUES_VL FV WHERE FM.STRUCTURE_NUM = SOB.CHART_OF_ACCOUNTS_ID AND FM.LEVEL_SHORT_NAME = 'GL COMPANY' AND FM.APPLICATION_ID = 101 AND FM.ID_FLEX_CODE = 'GL#' AND FV.FLEX_VALUE_SET_ID = FM.VALUE_SET_ID AND FV.ENABLED_FLAG = 'Y' AND FV.SUMMARY_FLAG = 'N' AND TRUNC(SYSDATE) BETWEEN NVL(FV.START_DATE_ACTIVE , TRUNC(SYSDATE)) AND NVL(FV.END_DATE_ACTIVE , TRUNC(SYSDATE))