Results for “pv_pg_invite_headers_vl”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PV_PG_INVITE_HEADERS_VL is a Partner Management (PV) view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes invitation header information used by the partner program invitation feature, where a partner or channel manager invites another party to participate in a program, price list, or promotional arrangement. The view is a "VL" (view with language) construct: it joins a base table to its translation table and filters the translation rows by the session language, so consumers see translated descriptive content alongside the language-independent business attributes. Because it is a view, it carries no storage of its own; it is a read-only projection intended for reporting, concurrent program logic, and integration extracts rather than for direct DML. Its status is documented as VALID in ETRM 12.2.2.

Underlying Base Objects

The view is defined over two documented base objects:

• PV_PG_INVITE_HEADERS_B — the base ("B") table holding language-independent invitation header data. Aliased as B in the view text.
• PV_PG_INVITE_HEADERS_TL — the translation ("TL") table holding language-dependent content. Aliased as T.

The join predicate is B.INVITE_HEADER_ID = T.INVITE_HEADER_ID, combined with T.LANGUAGE = USERENV('LANG'). USERENV('LANG') returns the language code for the current session, so the view returns exactly one translation row per invitation header, matching the session's language setting. The view also projects B.ROWID as ROW_ID, which provides a row identifier for the base table row. Both referenced objects appear in the metadata as SYNONYM entries in APPS, redirecting to the underlying PV tables.

Key Columns

• ROW_ID — the base table ROWID from PV_PG_INVITE_HEADERS_B; useful for uniquely identifying a header row in the base table.
• INVITE_HEADER_ID — primary key of the invitation header; the join key between the B and TL tables.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the application's OAF/ADF layers to detect concurrent updates.
• QP_LIST_HEADER_ID — reference to the associated Oracle Advanced Pricing (QP) list header, linking the invitation to a price list context.
• INVITE_TYPE_CODE — code classifying the invitation type.
• INVITE_FOR_PROGRAM_ID — identifier of the program for which the invitation was created. This is the column most relevant to the user's search term invite_for_program_id, and it associates each invitation header with its target program.
• INVITED_BY_PARTNER_ID — the partner who issued the invitation.
• EMAIL_CONTENT — language-dependent email body text drawn from the TL table.
• TRXN_EXTENSION_ID — reference to an extension record, typically used for additional transactional attributes.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns.

Common Use Cases and Queries

Typical scenarios include listing invitations for a given program, auditing who invited whom, and extracting email content for notification processing. Because the view already applies USERENV('LANG'), callers generally do not need to add their own language filter.

Invitations for a specific program:

• SELECT invite_header_id, invite_for_program_id, invited_by_partner_id, invite_type_code, creation_date
• FROM apps.pv_pg_invite_headers_vl
• WHERE invite_for_program_id = :p_program_id
• ORDER BY creation_date DESC;

Retrieving email content and price list context for a header:

• SELECT v.invite_header_id, v.qp_list_header_id, v.email_content
• FROM apps.pv_pg_invite_headers_vl v
• WHERE v.invite_header_id = :p_invite_header_id;

Because the definition filters on USERENV('LANG'), a row may be absent if no translation exists for the session language; join back to PV_PG_INVITE_HEADERS_TL directly when multi-language reporting is required.