Search Results quotation_line




Overview
Explore in AI Chat

Overview

APPS.PO_LINES_PRINT is a reporting and printing view in Oracle Purchasing that presents a denormalized, presentation-ready projection of purchase order line data. It is defined in the APPS schema and is used primarily by Oracle Purchasing's standard purchase order print program and related document-generation flows, where line-level information must be assembled together with header attributes, line type semantics, unit-of-measure translations, and United Nations (UN) hazard information. Unlike the transactional base table PO_LINES_ALL, this view applies business logic — such as decoding order type and header type to suppress or compute quantity, unit price, and amount depending on whether the line is quantity-based, amount-based, rate-based, or fixed price. The view is available in both Oracle EBS 12.1.1 and 12.2.2 and retains its APPS owner designation in the ETRM 12.2.2 metadata.

Underlying Base Objects

The view is constructed from a set of joined synonyms that resolve to the purchasing and inventory base tables. The ETRM metadata documents the following referenced objects: MTL_UNITS_OF_MEASURE, PO_HAZARD_CLASSES, PO_HEADERS_ALL, PO_LINES, PO_LINES_ALL, PO_LINE_LOCATIONS_ALL, PO_LINE_TYPES, PO_RELEASES_ALL, and PO_UN_NUMBERS. In the view text, PO_LINES (aliased PL1) supplies the primary line attributes, joined to PO_HEADERS_ALL (PH1) on PO_HEADER_ID to obtain header type lookup and type codes, and to PO_LINE_TYPES (PLT) on LINE_TYPE_ID to obtain ORDER_TYPE_LOOKUP_CODE. Additional header aliases PH2 and CONTRACT provide quote vendor quote number, contract segment, and global agreement flag. PO_LINES_ALL (PL2) is joined to resolve the related line number, MTL_UNITS_OF_MEASURE (MUM) provides the translated unit of measure, and PO_UN_NUMBERS (PUN) and PO_HAZARD_CLASSES (PHC) supply UN number and hazard classification for hazardous materials. The metadata also lists PO_LINE_LOCATIONS_ALL and PO_RELEASES_ALL as referenced objects, reflecting shipment and release context used in the broader print logic.

Key Columns

  • PO_HEADER_ID — the foreign key linking the line to its purchase order header; the column most commonly used to filter lines for a specific order.
  • PO_LINE_ID — the unique line identifier within PO_LINES / PO_LINES_ALL.
  • LINE_NUM — the user-visible line number on the purchase order.
  • ITEM_ID, ITEM_DESCRIPTION, ITEM_REVISION — item identity and descriptive attributes.
  • UNIT_PRICE, QUANTITY, QUANTITY_COMMITTED — commercial terms; the view conditionally nulls quantity or price based on ORDER_TYPE_LOOKUP_CODE and header TYPE_LOOKUP_CODE (STANDARD, PLANNED).
  • ORDER_TYPE_LOOKUP_CODE — derived from PO_LINE_TYPES; values such as AMOUNT, QUANTITY, RATE, and FIXED PRICE drive the decode logic.
  • CANCEL_FLAG, CANCEL_DATE, CANCEL_REASON — cancellation state of the line.
  • VENDOR_PRODUCT_NUM, NOTE_TO_VENDOR — supplier-facing references.
  • UNIT_MEAS_LOOKUP_CODE — the UOM, defaulted from MTL_UNITS_OF_MEASURE translation with fallback to the base lookup code.
  • UN_NUMBER and HAZARD_CLASS — concatenated UN number/description and hazard classification for regulated goods.
  • FROM_HEADER_ID, FROM_LINE_ID — sourcing references for the line.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 — descriptive flexfield context and segments.
  • ORG_ID — the operating unit that owns the purchasing document.

Common Use Cases and Queries

The view is typically queried to reproduce or extend the purchase order print output, to extract line detail for a specific order, or to feed downstream integration and reporting. Because the PO_HEADER_ID column is exposed directly, filtering by it is the standard access pattern.

  • Retrieve all printed lines for a given purchase order:
    SELECT line_num, item_description, unit_price, quantity, unit_meas_lookup_code FROM apps.po_lines_print WHERE po_header_id = :p_po_header_id ORDER BY line_num;
  • List hazardous material lines with UN numbers:
    SELECT po_header_id, line_num, un_number, hazard_class FROM apps.po_lines_print WHERE un_number IS NOT NULL;
  • Extract cancellations for audit:
    SELECT po_header_id, line_num, cancel_flag, cancel_date, cancel_reason FROM apps.po_lines_print WHERE cancel_flag = 'Y';
  • Report amount-based versus quantity-based lines using the order type:
    SELECT order_type_lookup_code, COUNT(*) FROM apps.po_lines_print GROUP BY order_type_lookup_code;

Because the view joins multiple purchasing tables and applies decode logic, it is best used for read-only reporting rather than as a target for DML; transactional updates must be performed against PO_LINES_ALL and its related base tables.