Results for “po_lines_v”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PO_LINES_V is an APPS-owned database view in the Oracle E-Business Suite Purchasing (PO) module. In the ETRM metadata it carries the description "10SC ONLY," which indicates that the view is scoped to a specific Oracle release or certification context rather than being a general-purpose interface object. It presents purchase order line information in a denormalized, report-ready form by joining PO_LINES to several supporting reference tables so that consumers receive line attributes together with resolved lookup descriptions and item details.

Its role is that of a read-only presentation layer. Rather than querying PO_LINES directly and performing multiple outer joins against line type, item, hazard class, UN number, and lookup tables, developers and report writers can select from PO_LINES_V and obtain human-readable values in a single statement. The status is recorded as VALID in the APPS schema, confirming the view compiles cleanly in the documented environment.

Underlying Base Objects

The documented referenced base objects are:

• PO_LINES — the primary transactional table supplying line identifiers, quantities, prices, flags, and descriptive flexfield attributes.
• PO_LINE_TYPES_B and PO_LINE_TYPES_TL — line type definitions and their translated names, providing LINE_TYPE and ORDER_TYPE_LOOKUP_CODE.
• MTL_SYSTEM_ITEMS — the item master, supplying SEGMENT1 (item number, truncated to 40 characters) and ALLOW_ITEM_DESC_UPDATE_FLAG.
• MTL_UNITS_OF_MEASURE — unit of measure reference data.
• PO_HAZARD_CLASSES_TL and PO_UN_NUMBERS_TL — hazard class and UN number translations.
• PO_LOOKUP_CODES — a view over the lookup framework, likely used for decoded lookup values.
• FND_GLOBAL — the standard EBS package supplying session context such as ORG_ID and USER_ID.
• PO_LINES_SV4 — a package referenced in the view definition, typically for derived or security-related values.

The join topology is a central PO_LINES row extended by outer joins to the lookup and master tables, which is why the view tolerates lines that lack an item, hazard class, or UN number assignment.

Key Columns

The view exposes the full set of PO_LINES columns plus derived values. Notable groups include:

• Identity and audit: ROWID, PO_LINE_ID, PO_HEADER_ID, LINE_NUM, LINE_TYPE_ID, LINE_TYPE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, REQUEST_ID, PROGRAM_ID.
• Item and category: ITEM_ID, ITEM_REVISION, CATEGORY_ID, ITEM_DESCRIPTION, and a SUBSTR of MTL_SYSTEM_ITEMS.SEGMENT1 limited to 40 characters.
• Pricing and quantity: UNIT_PRICE, LIST_PRICE_PER_UNIT, MARKET_PRICE, NOT_TO_EXCEED_PRICE, QUANTITY, QUANTITY_COMMITTED, COMMITTED_AMOUNT, MIN_ORDER_QUANTITY, MAX_ORDER_QUANTITY, MIN_RELEASE_AMOUNT.
• Status flags: CLOSED_FLAG, CANCEL_FLAG, USER_HOLD_FLAG, UNORDERED_FLAG, TAXABLE_FLAG, CAPITAL_EXPENSE_FLAG, ALLOW_PRICE_OVERRIDE_FLAG.
• Control and cancellation: FIRM_STATUS_LOOKUP_CODE, FIRM_DATE, CLOSED_CODE, CLOSED_DATE, CLOSED_BY, CANCEL_DATE, CANCELLED_BY, CANCEL_REASON.
• Compliance: UN_NUMBER, HAZARD_CLASS, TYPE_1099, GOVERNMENT_CONTEXT, USSGL_TRANSACTION_CODE.
• Flexfields: ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15, plus the reference and vendor-facing text columns NOTE_TO_VENDOR and VENDOR_PRODUCT_NUM.

Common Use Cases and Queries

Typical scenarios include open commitment reporting, price variance analysis, and integration extracts feeding downstream systems that require decoded line types and item numbers.

Listing open lines for a header:

• SELECT line_num, item_description, quantity, unit_price, closed_flag FROM po_lines_v WHERE po_header_id = :header_id AND NVL(closed_flag,'N') = 'N' ORDER BY line_num;

Extracting lines for a specific item across orders:

• SELECT po_header_id, line_num, unit_mea_lookup_code, quantity, unit_price FROM po_lines_v WHERE item_id = :item_id;

Reviewing cancelled or closed lines with reasons:

• SELECT po_header_id, line_num, cancel_reason, closed_code, closed_date FROM po_lines_v WHERE cancel_flag = 'Y' OR closed_flag = 'Y';

Because the "10SC ONLY" designation limits its documented applicability, confirm the view is enabled in the target environment before relying on it in production concurrent programs or interfaces.