Search Results program_end_date

Overview

PV_PARTNER_PROGRAM_VL is a seeded, language-enabled view in the APPS schema that belongs to the PV (Partner Management) product family in Oracle E-Business Suite. It presents partner program definitions, combining the transactional attributes of the partner program base table with the language-dependent descriptive columns. As a "_VL" (view language) object it returns translated content for the session language, resolving name, description, and questionnaire text per the user's language environment. The view is therefore the primary read interface for reporting, forms, and integration extracts concerning partner programs and, in particular, the optional inventory item and inventory organization attributed to a program. The presence of the INVENTORY_ITEM_ORG_ID column makes this view directly relevant to users searching for inventory organization context within Partner Management.

Underlying Base Objects

The view is defined over two documented base objects: PV_PARTNER_PROGRAM_B, the base (non-translated) table holding program attributes, and PV_PARTNER_PROGRAM_TL, the translation table holding language-dependent character data. Both are referenced in the ETRM metadata as synonyms within the APPS schema. The join condition relates the two tables on PROGRAM_ID, with the translation side filtered by PVATL.LANGUAGE = USERENV('LANG'). The B table supplies all functional columns, including PROGRAM_STATUS_CODE, ENABLED_FLAG, the program date range, membership parameters, and the inventory item and inventory organization references. The TL table contributes PROGRAM_NAME, PROGRAM_DESCRIPTION, QSNR_TITLE, QSNR_HEADER, and QSNR_FOOTER. A ROW_ID column is exposed from the B table ROWID, preserving row identifier semantics for tools that depend on it.

Key Columns

• PROGRAM_ID — primary identifier of the partner program record; the join key to related PV entities and the translation row.
• INVENTORY_ITEM_ID — identifier of the inventory item associated with the program, where the program is item-linked.
• INVENTORY_ITEM_ORG_ID — identifier of the inventory organization in which the associated item is defined; the column most relevant to inventory organization lookups.
• PROGRAM_LEVEL_CODE, PROGRAM_TYPE_ID, PROGRAM_PARENT_ID, PROGRAM_OWNER_RESOURCE_ID — classify the program and establish its hierarchy and ownership.
• PROGRAM_STATUS_CODE, ENABLED_FLAG, PROGRAM_START_DATE, PROGRAM_END_DATE, USER_STATUS_ID — control the lifecycle and validity window of the program.
• MEMBERSHIP_PERIOD_UNIT, MEMBERSHIP_VALID_PERIOD, SUBMIT_CHILD_NODES, GLOBAL_MMBR_REQD_FLAG — define membership duration and enrollment behavior.
• PROCESS_RULE_ID, PREREQ_PROCESS_RULE_ID, CITEM_VERSION_ID, CUSTOM_SETUP_ID — link the program to processing rules, prerequisites, and custom configuration.
• NO_FEE_FLAG, WAIVE_SUBSIDIARY_FEE_FLAG — fee-handling indicators.
• PROGRAM_NAME, PROGRAM_DESCRIPTION, QSNR_TITLE, QSNR_HEADER, QSNR_FOOTER — translated descriptive content sourced from the TL table.
• OBJECT_VERSION_NUMBER and the standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) — concurrency and audit tracking.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the descriptive flexfield (DFF) segment columns.

Common Use Cases and Queries

Typical scenarios include reporting on program membership terms, extracting translated program metadata, and reconciling item-linked partner programs against inventory definitions using INVENTORY_ITEM_ID and INVENTORY_ITEM_ORG_ID. Because the view is language-filtered, no additional language predicate is normally required.

All programs and their associated item/org context:

• SELECT program_id, program_name, program_status_code, enabled_flag, program_start_date, program_end_date, inventory_item_id, inventory_item_org_id FROM apps.pv_partner_program_vl ORDER BY program_name;

Item-linked programs in a specific inventory organization:

• SELECT t.program_id, t.program_name, t.inventory_item_id, t.inventory_item_org_id FROM apps.pv_partner_program_vl t WHERE t.inventory_item_org_id = :org_id AND t.inventory_item_id IS NOT NULL AND t.enabled_flag = 'Y';

Active programs within a date window:

• SELECT t.program_id, t.program_name, t.program_status_code FROM apps.pv_partner_program_vl t WHERE t.enabled_flag = 'Y' AND SYSDATE BETWEEN t.program_start_date AND NVL(t.program_end_date, SYSDATE + 1);

Program data is frequently joined to inventory item and organization views on INVENTORY_ITEM_ID and INVENTORY_ITEM_ORG_ID to return item numbers, organization codes, and UOM context in downstream reporting extracts.