Search Results pv_referrals_tl




Overview
Explore in AI Chat

Overview

The PV_REFERRALS_TL table is a core data object within the Oracle E-Business Suite (EBS) Partner Management (PV) module. It functions as the translated table for the PV_REFERRALS_B base table, enabling the storage of multilingual data for referral records. Its primary role is to support the global deployment of the Partner Management module by allowing descriptive information, such as comments or notes associated with a referral, to be maintained in multiple languages. This table is essential for any implementation requiring localized user interfaces and reports for partner referral tracking across different geographic regions.

Key Information Stored

As a translation table, PV_REFERRALS_TL stores language-specific versions of textual attributes linked to a referral's primary key. The central column is the REFERRAL_ID, which serves as the foreign key to the base table and part of the primary key for this table. The other critical component of the primary key is the LANGUAGE column, which identifies the language code (e.g., 'US' for American English) for the translated row. The table typically contains columns like REFERRAL_COMMENTS or similar descriptive fields that hold the translated text. The SOURCE_LANG column is also commonly present in EBS translation tables to record the original language in which the data was entered.

Common Use Cases and Queries

The primary use case is retrieving referral information in a user's session language for forms, reports, and partner portals. A standard query involves joining this table with PV_REFERRALS_B while filtering for the current language. For example, to generate a multilingual referral report, one might use a query pattern such as:
SELECT b.referral_number, tl.referral_comments, tl.language
FROM pv_referrals_b b, pv_referrals_tl tl
WHERE b.referral_id = tl.referral_id
AND tl.language = USERENV('LANG');
Another common scenario is data migration or initialization, where translated seed data for standard referral types or reasons is loaded into this table. Developers also interact with this table when customizing the Partner Management module to add new translatable attributes to the referral entity.

Related Objects

The table has a direct and critical relationship with its base table, as documented in the provided metadata. The sole foreign key relationship for PV_REFERRALS_TL is a reference to the PV_REFERRALS_B table. The join is performed on the REFERRAL_ID column, which is the primary key of PV_REFERRALS_B and a foreign key in PV_REFERRALS_TL. This structure is a standard EBS architecture for supporting multilingual functionality. Consequently, any application form, concurrent program, or API that accesses translated referral data will reference this table in conjunction with PV_REFERRALS_B. The PV_REFERRALS_VL view (if it exists) would typically be a pre-joined view combining these two tables for simplified reporting.