SQL to Verify to Ledger Setups - R12

SELECT GLV.LEDGER_CATEGORY_CODE,
       GLV.NAME,
       GLV.SHORT_NAME,
       GLV.DESCRIPTION,
       GLV.CHART_OF_ACCOUNTS_ID,
       GLV.PERIOD_SET_NAME                ACCOUNTING_CALENDAR,
       GLV.CURRENCY_CODE,
       GLV.SLA_ACCOUNTING_METHOD_CODE,
       GLV.FIRST_LEDGER_PERIOD_NAME,
       GLV.FUTURE_ENTERABLE_PERIODS_LIMIT,
       GLV.SLA_DESCRIPTION_LANGUAGE,
       A.CONCATENATED_SEGMENTS            ENTERED_CURRENCY, --GLV.SLA_ENTERED_CUR_BAL_SUS_CCID,
       B.CONCATENATED_SEGMENTS            RETAINED_EARNING, --GLV.RET_EARN_CODE_COMBINATION_ID,
       C.CONCATENATED_SEGMENTS            ROUNDING_ACCOUNT, -- GLV.ROUNDING_CODE_COMBINATION_ID ,
       GLV.ALLOW_INTERCOMPANY_POST_FLAG,
       GLV.ENABLE_JE_APPROVAL_FLAG,
       GLV.PERIOD_END_RATE_TYPE,
       E.USER_CONVERSION_TYPE, -- GLV.PERIOD_AVERAGE_RATE_TYPE,
       D.CONCATENATED_SEGMENTS            TRANSLATION_ACCOUNT,
       GLV.CUM_TRANS_CODE_COMBINATION_ID
  FROM GL_LEDGERS                GLV,
       GL_CODE_COMBINATIONS_KFV  A,
       GL_CODE_COMBINATIONS_KFV  B,
       GL_CODE_COMBINATIONS_KFV  C,
       GL_CODE_COMBINATIONS_KFV  D,
       GL_DAILY_CONVERSION_TYPES E
 WHERE E.CONVERSION_TYPE = GLV.PERIOD_AVERAGE_RATE_TYPE
   AND GLV.SLA_ENTERED_CUR_BAL_SUS_CCID = A.CODE_COMBINATION_ID
   AND GLV.RET_EARN_CODE_COMBINATION_ID = B.CODE_COMBINATION_ID
   AND GLV.ROUNDING_CODE_COMBINATION_ID = C.CODE_COMBINATION_ID
   AND GLV.CUM_TRANS_CODE_COMBINATION_ID = D.CODE_COMBINATION_ID;