Search Results quantity_financed




Overview
Explore in AI Chat

Overview

PO_SGD_DISTRIBUTIONS_V is an APPS-owned database view in the Oracle E-Business Suite Purchasing (PO) module. Its name reflects its role in the "SGD" (Structured Generic Data / supplemental detail) pattern used by Oracle's earlier procurement architecture, in which change document and distribution attributes are stored as name–value pairs rather than as discrete typed columns. Rather than presenting one row per distribution, the view pivots each attribute of a purchase order distribution into a separate row consisting of a key tuple, a column name (COL_NAME), and the corresponding value (COL_VALUE), plus a descriptive (COL_DESC) translation of coded values back into user-facing meanings. The view exists to support the Purchasing change document and distribution display components, and it is queried by EBS forms, OAF pages, and reporting extracts that need a generic, self-describing representation of distribution data. Because it exposes the QUANTITY_ORDERED, QUANTITY_DELIVERED, QUANTITY_BILLED, QUANTITY_CANCELLED and related quantity attributes as named rows, it is frequently encountered when users search on terms such as "quantity_financed" or other quantity-based distribution columns.

Underlying Base Objects

The view's inline query selects from PO_DISTRIBUTIONS_ALL, with a draft counterpart in PO_DISTRIBUTIONS_DRAFT_ALL referenced via the DRAFT_ID key (defaulted to -1 with NVL when absent). The ETRM metadata documents the following referenced objects: PO_DISTRIBUTIONS_ALL (SYNONYM), PO_DISTRIBUTIONS_DRAFT_ALL (SYNONYM), PO_GEN_DIFF_PKG (PACKAGE), FND_LOOKUP_VALUES (SYNONYM), GL_CODE_COMBINATIONS_KFV (VIEW), HR_ALL_ORGANIZATION_UNITS (SYNONYM), HR_LOCATIONS_ALL (SYNONYM), OKC_K_LINES_B (SYNONYM), PA_PROJECTS_ALL (SYNONYM), PA_TASKS (SYNONYM), and PER_ALL_PEOPLE_F (SYNONYM). The PO_GEN_DIFF_PKG package provides the generic-difference logic that supports the change-document comparison of distributions. Lookup descriptions are resolved through FND_LOOKUP_VALUES, accounting flexfields through GL_CODE_COMBINATIONS_KFV, project and task context through PA_PROJECTS_ALL and PA_TASKS, contract line context through OKC_K_LINES_B, and organizational and personnel descriptions through HR_ALL_ORGANIZATION_UNITS and PER_ALL_PEOPLE_F. The view therefore behaves as a denormalized, decoded projection layered over the distribution base tables.

Key Columns

The structural key columns are PO_HEADER_ID (PK1_VALUE), DRAFT_ID (PK2_VALUE), PO_LINE_ID (PK3_VALUE), LINE_LOCATION_ID (PK4_VALUE), and PO_DISTRIBUTION_ID (PK5_VALUE), which together identify the owning document hierarchy and the specific distribution. The attribute columns are COL_NAME, which carries the name of the underlying distribution column (for example DISTRIBUTION_NUM, QUANTITY_ORDERED, QUANTITY_DELIVERED, QUANTITY_BILLED, QUANTITY_CANCELLED), COL_VALUE, which carries the value as a character string via TO_CHAR, and COL_DESC, which supplies a decoded meaning. DECODE logic maps CLM_DEFENCE_FUNDING and DESTINATION_TYPE_CODE through FND_LOOKUP_VALUES, DELIVER_TO_LOCATION_ID through HR_LOCATIONS_ALL, DELIVER_TO_PERSON_ID through PER_ALL_PEOPLE_F, CODE_COMBINATION_ID, ACCRUAL_ACCOUNT_ID and VARIANCE_ACCOUNT_ID through GL_CODE_COMBINATIONS_KFV, PROJECT_ID and TASK_ID through PA_PROJECTS_ALL and PA_TASKS, EXPENDITURE_ORGANIZATION_ID through HR_ALL_ORGANIZATION_UNITS, and OKE_CONTRACT_LINE_ID through OKC_K_LINES_B. Because quantities and identifiers are converted to character values, consumers must cast COL_VALUE when performing numeric comparison or aggregation.

Common Use Cases and Queries

The view is used to retrieve distribution quantities for a purchase order line without joining each quantity column explicitly, and to present decoded attribute values in change-document and audit contexts. A representative query filtering on the quantity attribute is:

  • SELECT PK1_VALUE, PK3_VALUE, PK4_VALUE, PK5_VALUE, COL_NAME, COL_VALUE FROM APPS.PO_SGD_DISTRIBUTIONS_V WHERE COL_NAME IN ('QUANTITY_ORDERED','QUANTITY_DELIVERED','QUANTITY_BILLED') AND PK1_VALUE = :p_po_header_id;
  • SELECT COL_NAME, COL_VALUE, COL_DESC FROM APPS.PO_SGD_DISTRIBUTIONS_V WHERE PO_DISTRIBUTION_ID = :p_distribution_id ORDER BY COL_NAME;
  • SELECT PK3_VALUE, PK4_VALUE, COL_VALUE FROM APPS.PO_SGD_DISTRIBUTIONS_V WHERE PO_LINE_ID = :p_line_id AND COL_NAME = 'QUANTITY_BILLED';

Typical scenarios include reconciliation of ordered, delivered, billed and cancelled quantities per distribution, population of custom procurement reports, and supporting the generic difference engine in PO_GEN_DIFF_PKG. Because the view returns character values, aggregation should use TO_NUMBER(COL_VALUE), and queries should be constrained by the appropriate key columns to avoid full scans of the distribution base tables.