1      Validating Ledger Setups with script

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;