Lookups

Transactional Business Intelligence lookups are implemented using the Physical lookups. See the Oracle Fusion Middleware Developer's Guide for Oracle Business Intelligence Enterprise Edition for more information. The following is an example:

LOOKUP( SPARSE "oracle.apps.fscm.model.analytics.applicationModule.FscmTopModelAM_FscmTopModelAMLocal"."".""."FscmTopModelAM.AnalyticsServiceAM.LookupValuesTLPVO"."Meaning", "oracle.apps.fscm.model.analytics.applicationModule.FscmTopModelAM_FscmTopModelAMLocal"."".""."FscmTopModelAM.EgpItemsPublicModelAM.Item"."ItemBasePEOAllowExpressDeliveryFlag", VALUEOF(NQ_SESSION."USER_LANGUAGE_CODE"), "oracle.apps.fscm.model.analytics.applicationModule.FscmTopModelAM_FscmTopModelAMLocal"."".""."FscmTopModelAM.EgpItemsPublicModelAM.Item"."ItemBasePEOAllowExpressDeliveryFlag", 'EGP_CATALOG_YES_NO', 0, 0)