206: h_chart_of_accounts_id,
207: h_organization_name,
208: h_set_of_books_id
209: FROM FA_BOOK_CONTROLS BC,
210: GL_SETS_OF_BOOKS SOB
211: WHERE BC.BOOK_TYPE_CODE = h_book
212: AND SOB.SET_OF_BOOKS_ID = BC.SET_OF_BOOKS_ID;
213: else
214: SELECT BC.ACCOUNTING_FLEX_STRUCTURE,
223: h_chart_of_accounts_id,
224: h_organization_name,
225: h_set_of_books_id
226: FROM FA_BOOK_CONTROLS_mrc_v BC,
227: GL_SETS_OF_BOOKS SOB
228: WHERE BC.BOOK_TYPE_CODE = h_book
229: AND SOB.SET_OF_BOOKS_ID = BC.SET_OF_BOOKS_ID;
230: END if;
231: