Transactional Business Intelligence supports multiple languages by providing view objects that join the _B base tables and _TL translation tables in the query. The filter on the language is provided by an LTS filter using the session variable USER_LANGUAGE_CODE:
"oracle.apps.fscm.model.analytics.applicationModule.FscmTopModelAM_FscmTopModelAMLocal"."".""."FscmTopModelAM.EgpItemsPublicModelAM.Item"."OrganizationUnitTLPEOLanguage" = VALUEOF(NQ_SESSION."USER_LANGUAGE_CODE")