Search Results po_purcha

Overview

ECE_POCO_LINES_V is a private APPS-owned view within the Oracle E-Business Suite e-Commerce Gateway (EC) module. It is the line-level extraction view that supplies data for the outbound Purchase Order Change transaction, commonly identified by the ANSI X12 document number 860 or the UN/EDIFACT message ORDCHG. For Oracle EBS 12.1.1 and 12.2.2, this view serves as the row source from which the e-Commerce Gateway constructs outbound line segments of the change message, allowing purchasers to communicate amendments to previously transmitted purchase orders to suppliers.

The object is registered in ETRM with a lifecycle status of active and a scope of private, meaning it is an internal implementation artifact not intended for customer modification. Its display name is "Purchase Order Change Line View," and it is categorized under the business entity PO_PURCHA. Because the view flattens procurement attributes, supplier identifiers, hazardous material details, and descriptive flexfield columns into a single row per purchase order line, it is useful both to the delivered 860 extraction process and to reporting or troubleshooting exercises conducted by technical consultants.

Underlying Base Objects

The view is defined over a set of documented synonyms that resolve to core purchasing and inventory tables. The principal source is PO_LINES_ALL (aliased POL), which provides line number, quantity, unit of measure, item identifiers, pricing, cancellation attributes, and the descriptive flexfield columns exposed as POL_ATTRIBUTE1 through POL_ATTRIBUTE15. PO_LINE_LOCATIONS supplies the order type lookup value used to convey the line transaction context. PO_HEADERS_ALL (aliases PH1 and PH2) contributes the purchase order number via PH2.SEGMENT1 and the vendor quote number from PH1.QUOTE_VENDOR_QUOTE_NUMBER. PO_HEADERS and PO_RELEASES are listed among the referenced base objects and support header and release-level resolution within the extraction. MTL_SYSTEM_ITEMS_B provides the item organization context and the MTL_ATTRIBUTE set linked to the inventory item definition. PO_HAZARD_CLASSES_B and PO_HAZARD_CLASSES_TL supply hazard class information, while PO_UN_NUMBERS_B and PO_UN_NUMBERS_TL contribute United Nations number and description values for hazardous materials. FINANCIALS_SYSTEM_PARAMETERS and PO_LINE_TYPES are also referenced as supporting objects, typically for currency or organizational defaulting and line type derivation.

Key Columns

• LINE_NUM — the purchase order line number, the primary sequencing attribute of the outbound line segment.
• QUANTITY — the ordered line quantity used for the standard quantity segment.
• QUANTITY_COMMITTED — the quantity committed against the line, exposed to support change comparisons and reconciliation logic during outbound 860 processing.
• COMMITTED_AMOUNT — the corresponding committed monetary value for the line.
• UOM_CODE — derived from POL.UNIT_MEAS_LOOKUP_CODE; the unit of measure applied to the ordered quantity.
• ITEM_ID and ITEM_REVISION — internal item key and revision identifier for the changed line.
• VENDOR_PRODUCT_NUMBER — the supplier's part number as recorded on the line.
• UNIT_PRICE, LIST_PRICE_PER_UNIT, MARKET_PRICE, NOT_TO_EXCEED_PRICE — the pricing columns transmitted in the change message.
• CANCEL_FLAG and CANCEL_DATE — indicators supporting cancellation segments in the outbound document.
• PO_NUMBER and VENDOR_QUOTE_NUMBER — header-level identifiers qualifying the line.
• ORDER_TYPE_LOOKUP_CODE — derived from PO_LINE_LOCATIONS; classifies the order context of the line.
• HAZARD_CLASS, UN_NUMBER, UN_DESCRIPTION — hazardous material descriptors for regulated shipments.
• TRANSACTION_REASON_CODE, TAXABLE_FLAG, TYPE_1099, NEGOTIATED_BY_PREPARER_FLAG — transactional and tax classification attributes.
• NOTE_TO_VENDOR — free-text instructions carried at line level.
• POL_ATTRIBUTE1 through POL_ATTRIBUTE15 and POL_ATTRIBUTE_CATEGORY — line-level descriptive flexfields available for mapping into outbound segments.
• MTL_ORGANIZATION_ID, LP_ATTRIBUTE_CATEGORY, LP_ATTRIBUTE1 — organization and inventory item flexfield context joined from MTL_SYSTEM_ITEMS_B.

Common Use Cases and Queries

Consultants query this view to verify which changed lines will be extracted for the 860 transaction, to reconcile quantity and commitment values against PO_LINES_ALL, or to diagnose outbound interface gaps. A typical query filters by purchase order number and selects the line-level change attributes:

SELECT line_num, quantity, quantity_committed, committed_amount, uom_code, unit_price, cancel_flag, item_id FROM apps.ece_poco_lines_v WHERE po_number = :p_po_number ORDER BY line_num;

A second common pattern isolates the user's search term, quantity_committed, to audit commitments distributed against changed lines relative to ordered quantity:

SELECT po_number, line_num, quantity, quantity_committed, (quantity - quantity_committed) uncommitted_qty FROM apps.ece_poco_lines_v WHERE quantity_committed IS NOT NULL AND po_number = :p_po_number;

Because the view is private, it should be referenced read-only. Customizations requiring additional columns should be handled through a custom view or a copy rather than modification of ECE_POCO_LINES_V, preserving supportability across 12.1.1 and 12.2.2 upgrades.