Search Results tprt_fk_key




Overview
Explore in AI Chat

Overview

ISC_OPI_TOP_ORD_QTD_S is a seeded APPS-schema view belonging to the ISC – Supply Chain Intelligence product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It functions as a surrogate or "star" style reporting view that exposes a ranked, quarter-to-date set of top sales orders. In the ETRM metadata it is registered as a VIEW with STATUS = VALID, owned by APPS. The purpose of the object is to present a condensed, pre-filtered slice of order and fulfillment data suitable for embedding in Oracle Business Intelligence / Supply Chain Intelligence dashboards, Discoverer workbooks, or custom analytics that require a "Top N orders" presentation without writing complex ranking logic inside the reporting layer.

Underlying Base Objects

The documented view definition is a single-layer projection over ISC_OPI_TOP_ORD_QTD_BASE_V. All nineteen columns are selected verbatim from that base view, and the only transformation applied is a row-level predicate: WHERE RANK < 101. This restricts the result set to the top 100 ranked orders (ranking is produced upstream in the base view). The ETRM metadata lists no additional referenced base objects, meaning the join and aggregation logic—including how the rank is computed—resides in ISC_OPI_TOP_ORD_QTD_BASE_V and any further underlying tables beneath it. The naming convention confirms the "_S" suffix denotes a secured or summary view, while "_B_" generally indicates the corresponding base view in the ISC OPI (Operational Performance Intelligence) schema family.

Key Columns

The columns fall into three logical groups. The first group consists of foreign-key surrogate keys used for dimensional joins: SOBL_BOOK_FK_KEY (the sales order book / SOB key, which is the term matched by the user's search term sobl_book_fk_key), OPER_UNIT_FK_KEY, CAL_DAY_FK_KEY, EC_PERIOD_FK_KEY, EC_QTR_FK_KEY, and TPRT_FK_KEY. These keys map to the ISC dimensional star schema (operating unit, calendar day, period, quarter, and trading partner).

The second group carries order-level descriptive attributes: ORDER_NUMBER, CUSTOMER_NAME, ORDERED_DATE, BOOKED_DATE, LATEST_SHIP_DATE, FULFILLED_DATE, and HEADER_ID. The third group provides the quantitative measures used in reporting: NET_BOOKED_VALUE, SHIPPED_VALUE, FULFILLED_VALUE, INVOICED_VALUE, and NUM_OF_ORDERS. The RANK column is the ranking key that determines top-order ordering and drives the RANK < 101 filter.

Common Use Cases and Queries

Typical consumption includes "Top 100 orders quarter-to-date" dashboards, fulfillment and shipping value analysis by trading partner, and dimensional drill-down into the ISC star schema. A representative query joining to the sales order book dimension would read:

  • SELECT order_number, customer_name, net_booked_value, shipped_value, fulfilled_value, rank FROM apps.isc_opi_top_ord_qtd_s WHERE sobl_book_fk_key = :book_key ORDER BY rank;
  • SELECT rank, order_number, ordered_date, invoiced_value FROM apps.isc_opi_top_ord_qtd_s WHERE ec_qtr_fk_key = :qtr_key AND oper_unit_fk_key = :ou_key;
  • SELECT sum(net_booked_value), sum(shipped_value) FROM apps.isc_opi_top_ord_qtd_s WHERE tprt_fk_key = :tprt_key;

Because the view is secured to APPS and its ranking is pre-computed, consumers should not attempt to re-rank or aggregate the base data within the view; instead they should filter on the exposed keys. To resolve the surrogate keys to human-readable values, join SOBL_BOOK_FK_KEY and the other _FK_KEY columns to their respective ISC dimension tables or views. The user's search term sobl_book_fk_key is best served by this view coupled with the corresponding sales order book dimension, enabling per-book top-order reporting within the quarter-to-date window.