Search Results consigned_flag




Overview
Explore in AI Chat

Overview

PO_LINE_LOCATIONS_PRINT is an APPS-owned view in the Oracle E-Business Suite Purchasing (PO) module, documented in ETRM as a retrofitted object. It presents shipment- and distribution-level purchasing data drawn from the line locations table, joined to the corresponding purchasing document header. In Oracle EBS 12.1.1 and 12.2.2 the view functions as a print and reporting interface rather than a transactional entity: it denormalizes shipment attributes — scheduling, pricing, cancellation, taxability, descriptive flexfields, and consignment status — into a single queryable structure suitable for purchase order printing, BI Publisher extracts, ad hoc reporting, and integration feeds.

The view is significant for users searching the CONSIGNED_FLAG attribute, because it is one of the few published, supported objects that surface consignment information at the shipment level alongside the parent document context.

Underlying Base Objects

Per the documented metadata, the view is defined over two referenced base objects:

  • PO_LINE_LOCATIONS_ALL (SYNONYM) (aliased PLL) — the primary source, supplying all shipment-level columns including CONSIGNED_FLAG, quantities, dates, amounts, and the sequential descriptive flexfield attributes.
  • PO_HEADERS (SYNONYM) (aliased PH) — joined on PLL.PO_HEADER_ID = PH.PO_HEADER_ID to anchor each shipment row to its purchasing document header.

All columns originate from PO_LINE_LOCATIONS_ALL except the header identifier used for the join; no columns from PO_HEADERS are projected in the select list. The _ALL suffix on the line locations table indicates that the view is multi-organization aware, and the document organization is exposed through ORG_ID, derived from the shipment record.

Key Columns

Common Use Cases and Queries

Typical applications include consigned inventory reporting, open shipment extracts, and purchase order print programs. A query to identify consigned shipments is:

SELECT pllp.shipment_num, pllp.po_header_id, pllp.po_line_id, pllp.line_location_id, pllp.quantity_ordered, pllp.due_date, pllp.shipment_type, pllp.org_id FROM apps.po_line_locations_print pllp WHERE pllp.consigned_flag = 'Y' AND pllp.cancel_flag = 'N' AND pllp.org_id = :p_org_id;

Users may further constrain by SHIPMENT_TYPE = 'STANDARD' or filter on DUE_DATE ranges for scheduling analysis, and join PO_HEADER_ID and PO_LINE_ID to the transactional purchasing tables for supplier and item detail.