--Oracle Financials 11i > Set of Books Query--

SELECT  NAME                                

  ,SHORT_NAME  

  ,DESCRIPTION                        

  ,CHART_OF_ACCOUNTS_ID               

  ,CURRENCY_CODE                      

  ,PERIOD_SET_NAME                    

  ,ACCOUNTED_PERIOD_TYPE              

  ,(select CONCATENATED_SEGMENTS

from APPS.gl_code_combinations_kfv

where code_combination_id=a.RET_EARN_CODE_COMBINATION_ID                 ) RET_EARN_CODE_COMBINATION

  ,(select CONCATENATED_SEGMENTS

from APPS.gl_code_combinations_kfv

where code_combination_id=a.CUM_TRANS_CODE_COMBINATION_ID                 ) CUM_TRANS_CODE_COMBINATION

  ,SUSPENSE_ALLOWED_FLAG              

  ,ALLOW_INTERCOMPANY_POST_FLAG  

  ,TRACK_ROUNDING_IMBALANCE_FLAG

  ,ENABLE_AVERAGE_BALANCES_FLAG  

  ,ENABLE_BUDGETARY_CONTROL_FLAG

  ,REQUIRE_BUDGET_JOURNALS_FLAG  

  ,ENABLE_JE_APPROVAL_FLAG            

  ,ENABLE_AUTOMATIC_TAX_FLAG          

  ,CONSOLIDATION_SOB_FLAG             

  ,TRANSLATE_EOD_FLAG                 

  ,TRANSLATE_QATD_FLAG                

  ,TRANSLATE_YATD_FLAG                

  ,MRC_SOB_TYPE_CODE                  

  ,ALLOW_POSTING_WARNING_FLAG         

  ,LAST_UPDATE_DATE                   

  ,(select user_name from apps.fnd_user where user_id=A.LAST_UPDATED_BY) LAST_UPDATED_BY                    

  ,CREATION_DATE                      

  ,(select user_name from apps.fnd_user where user_id=A.created_by) created_by                         

  ,LAST_UPDATE_LOGIN                  

  ,FUTURE_ENTERABLE_PERIODS_LIMIT

  ,LATEST_OPENED_PERIOD_NAME          

  ,LATEST_ENCUMBRANCE_YEAR            

  ,(select CONCATENATED_SEGMENTS

from APPS.gl_code_combinations_kfv

where code_combination_id=a.RES_ENCUMB_CODE_COMBINATION_ID                 ) RES_ENCUMB_CODE_COMBINATION

  ,(select CONCATENATED_SEGMENTS

from APPS.gl_code_combinations_kfv

where code_combination_id=a.NET_INCOME_CODE_COMBINATION_ID                 ) NET_INCOME_CODE_COMBINATION

  ,(select CONCATENATED_SEGMENTS

from APPS.gl_code_combinations_kfv

where code_combination_id=a.ROUNDING_CODE_COMBINATION_ID                 ) ROUNDING_CODE_COMBINATION  

  ,TRANSACTION_CALENDAR_ID            

  ,DAILY_TRANSLATION_RATE_TYPE        

  ,EARLIEST_UNTRANS_PERIOD_NAME  

,  TRACK_ENTERED_FUNC_CURR_FLAG  

,  ENABLE_SECONDARY_TRACK_FLAG        

,  ENABLE_REVAL_SS_TRACK_FLAG

,instance_name         

FROM APPS.GL_SETS_OF_BOOKS A

,v$instance

ORDER BY CREATION_DATE DESC