Search Results end_active_date




Overview
Explore in AI Chat

Overview

EDW_TPRT_P3_TPARTNER_LCV is an Oracle EBS reporting view owned by the APPS schema and registered under the PO - Purchasing product family. The name follows the enterprise data warehouse (EDW) naming convention, where the "LCV" suffix denotes a "logical/lean column view" — a denormalized, presentation-layer projection built specifically for downstream extraction, reporting, and analytical consumption rather than for transactional processing. The view exposes a curated set of trading-partner (vendor/supplier) attributes and nulls out the standard descriptive flexfield columns, which indicates that it was deliberately designed to feed an external data warehouse, business intelligence tool, or interface staging area.

The object carries a status of VALID in the ETRM catalog and is available in both Oracle EBS 12.1.1 and 12.2.2. It is relevant to the end_active_date search because the view projects the supplier lifecycle column END_ACTIVE_DATE directly from its underlying base view, making it a common source for supplier-activation-window reporting.

Underlying Base Objects

Per the documented view text, EDW_TPRT_P3_TPARTNER_LCV is defined over a single underlying object: EDWBV_TPRT_P3_TPARTNER_LCV, a base ("BV" = base view) enterprise data warehouse view. No additional base tables are documented for this object. The EDW layer typically sits above the transactional EBS trading-partner tables (for example, PO_VENDORS / AP_SUPPLIERS and their associated sites), but the metadata records only the immediate dependency on the EDWBV view. Because EDW_TPRT_P3_TPARTNER_LCV is a thin projection, any change to the base view's column list or datatypes propagates directly, so invalidating and validating this view should be handled after any EDW-layer upgrade or patch.

Key Columns

Common Use Cases and Queries

Typical uses include supplier master extracts, data warehouse loads, and active-vendor reporting. Because DFF columns are nulled, the view is best suited to standardized supplier attributes.

  • List suppliers whose active period has closed.
  • Report current (open-ended) suppliers.
  • Join to purchasing or receiving facts on VENDOR_ID.

SELECT TPARTNER_PK, NAME, VENDOR_NUMBER, START_ACTIVE_DATE, END_ACTIVE_DATE
FROM APPS.EDW_TPRT_P3_TPARTNER_LCV
WHERE END_ACTIVE_DATE IS NOT NULL
AND END_ACTIVE_DATE < SYSDATE;

SELECT TPARTNER_PK, NAME, VENDOR_NUMBER
FROM APPS.EDW_TPRT_P3_TPARTNER_LCV
WHERE (END_ACTIVE_DATE IS NULL OR END_ACTIVE_DATE > SYSDATE)
AND NVL(HOLD_FLAG,'N') = 'N';