ENT : Query 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;