Search Results ece_po_distributions_v




Overview
Explore in AI Chat

Overview

APPS.ECE_PO_DISTRIBUTIONS_V is a private, active e-Commerce Gateway (EC) view that extracts purchase order distribution information for outbound Electronic Data Interchange transactions. Its definition is scoped to the Purchasing (PO) product and supports the outbound Purchase Order (850/ORDERS) and Purchase Order Change (860/ORDCHG) transaction sets. The view supplies the distribution-level detail that the e-Commerce Gateway uses when translating Oracle Purchasing documents into outbound EDI messages delivered to trading partners.

Because distribution records carry quantities, billed amounts, delivery addresses, and descriptive flexfield attributes, this view is the primary source for the distribution segment of an 850 or 860 document. The AMOUNT_BILLED column is frequently queried by developers and analysts building reconciliation or reporting logic around Purchasing distributions, since it exposes the invoiced value associated with each distribution line.

Underlying Base Objects

The view is defined over the following documented base objects:

  • PO_DISTRIBUTIONS — the driving table, supplying distribution identifiers, quantities, billed amount, conversion rate and date, destination type, and attribute columns.
  • PO_LINE_LOCATIONS — joined to provide shipment and line location context.
  • PO_RELEASES — referenced for release-level information used in blanket and release transactions.
  • HR_LOCATIONS_ALL — provides the deliver-to address components such as location code, address lines, city, postal code, country, region, and telephone numbers.
  • PER_ALL_PEOPLE_F — supplies the deliver-to contact first and last names.

The view text selects from PO_DISTRIBUTIONS (aliased POD) and joins to HR_LOCATIONS_ALL (HRL) and PER_ALL_PEOPLE_F (PPF) to denormalize delivery address and contact data. Notably, PO_RELEASE_ID is returned as a literal 0, indicating that the view is oriented toward standard purchase orders rather than release-level extraction.

Key Columns

Common Use Cases and Queries

The view is typically consumed by e-Commerce Gateway extraction logic and by custom reporting that requires distribution detail with a deliver-to address. A representative query retrieving billed amounts and delivery data for a purchase order is:

  • SELECT po_header_id, po_line_id, distribution_num, quantity_ordered, quantity_billed, amount_billed, deliver_to_city, deliver_to_country FROM apps.ece_po_distributions_v WHERE po_header_id = :p_header_id ORDER BY po_line_id, distribution_num;

To analyze billed amounts across a set of distributions:

  • SELECT po_header_id, SUM(amount_billed) total_billed FROM apps.ece_po_distributions_v GROUP BY po_header_id HAVING SUM(amount_billed) > 0;

Because the view is marked private and is scoped to the EC product, it should be treated as an internal e-Commerce Gateway object rather than a general-purpose reporting view. Customizations should avoid modifying its definition; instead, replicate the join logic against PO_DISTRIBUTIONS, HR_LOCATIONS_ALL, and PER_ALL_PEOPLE_F when broader or differently filtered results are required.