Thursday, November 17, 2011

SET OF BOOKS CONFIGURATION OVERVIEW

/* SET OF BOOKS CONFIGURATION OVERVIEW
This SQL gives an overview of the set of book definitions and can be used when implementing multiple sets of books 
to ensure consistent setup across countries and between environments. 
Where clause can be added or commented out to just look at specific countries. */
SELECT SOB.SET_OF_BOOKS_ID "ID"
,    SOB.NAME
,    SOB.SHORT_NAME 
,    SOB.DESCRIPTION
,    SOB.CHART_OF_ACCOUNTS_ID "COA ID"
,    FST.ID_FLEX_STRUCTURE_CODE "CHART OF ACCOUNTS"
,    SOB.CURRENCY_CODE "CURR"
,    PT.USER_PERIOD_TYPE "PERIOD"
,    SOB.PERIOD_SET_NAME
,    SOB.FUTURE_ENTERABLE_PERIODS_LIMIT "FUT. PER"
,    SOB.LATEST_OPENED_PERIOD_NAME "LATEST OPEN"
,    SOB.ATTRIBUTE1"OPERATIONAL BOOK"
,    SOB.ATTRIBUTE2"PPL ?"
,    SOB.ENABLE_REVAL_SS_TRACK_FLAG||'.'||ENABLE_SECONDARY_TRACK_FLAG"SEC SEG TRACK?"
,    RET.SEGMENT1||'-'||RET.SEGMENT2||'-'||RET.SEGMENT3||'-'||RET.SEGMENT4||'-'||RET.SEGMENT5||'-'||RET.SEGMENT6 "RETAINED EARNINGS"
,    TRAN.SEGMENT1||'-'||TRAN.SEGMENT2||'-'||TRAN.SEGMENT3||'-'||TRAN.SEGMENT4||'-'||TRAN.SEGMENT5||'-'||TRAN.SEGMENT6 "TRAN EARNINGS"
,    '---JOURNALS---'
,    SOB.ALLOW_INTERCOMPANY_POST_FLAG"INTERCO?"
,    SOB.ENABLE_JE_APPROVAL_FLAG"JRNL APP?"
,    SOB.ENABLE_AUTOMATIC_TAX_FLAG"AUTO TAX?"
,    SOB.SUSPENSE_ALLOWED_FLAG"SUSP?"
,    SOB.TRACK_ROUNDING_IMBALANCE_FLAG"TRK RND?"
,    '---AV BAL---'
,    SOB.ENABLE_AVERAGE_BALANCES_FLAG||SOB.CONSOLIDATION_SOB_FLAG||SOB.TRANSACTION_CALENDAR_ID||SOB.NET_INCOME_CODE_COMBINATION_ID
    ||SOB.DAILY_TRANSLATION_RATE_TYPE||SOB.TRANSLATE_EOD_FLAG||SOB.TRANSLATE_QATD_FLAG||SOB.TRANSLATE_YATD_FLAG "NOT USED"
,    '---BUDGET CNTL---'
,    SOB.ENABLE_BUDGETARY_CONTROL_FLAG||SOB.REQUIRE_BUDGET_JOURNALS_FLAG||SOB.RES_ENCUMB_CODE_COMBINATION_ID "NOT USED"
,    '---MRC---'
,    SOB.MRC_SOB_TYPE_CODE "NOT USED"
FROM GL_SETS_OF_BOOKS SOB, FND_ID_FLEX_STRUCTURES FST, GL_CODE_COMBINATIONS TRAN, GL_CODE_COMBINATIONS RET, GL_PERIOD_TYPES PT
WHERE FST.ID_FLEX_NUM = SOB.CHART_OF_ACCOUNTS_ID
AND RET.CODE_COMBINATION_ID(+) =  SOB.RET_EARN_CODE_COMBINATION_ID
AND TRAN.CODE_COMBINATION_ID(+) =  SOB.CUM_TRANS_CODE_COMBINATION_ID
AND PT.PERIOD_TYPE = SOB.ACCOUNTED_PERIOD_TYPE 
--AND SUBSTR(SOB.SHORT_NAME,1,2) IN ('BE','LU','ES','IT','HU','CZ','PL','RU')
ORDER BY 2

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect