Search Results purchasing_agent_id




Overview
Explore in AI Chat

Overview

PO_OWNED_REQUISITION_LINES is a security-enabled view owned by the APPS schema in Oracle E-Business Suite, catalogued under the PO — Purchasing product family. Its documented purpose is to expose requisition line information only for those requisitions that the querying user is authorized to access, effectively serving as an ownership-filtered projection of the base requisition line data. It is validated and available in both EBS 12.1.1 and 12.2.2.

Because requisition data frequently passes through Oracle Purchasing workflows and is surfaced into downstream reporting, this view plays a central role wherever row-level security on requisitions is required. It is the recommended access point for reports, concurrent programs, and integration extracts that must respect the requisition ownership model rather than bypassing it by reading the underlying synonym directly.

Underlying Base Objects

Per the ETRM 12.2.2 metadata, PO_OWNED_REQUISITION_LINES is defined over two referenced base objects:

The view text joins PORL to PORH on the requisition header identifier, so each returned row represents a single requisition line enriched with its header’s preparer. No aggregation, grouping, or analytical transformation is applied; the view is a straight-line projection with an ownership constraint applied by the security model.

Key Columns

The view exposes the complete operational surface of a requisition line. Columns of particular note include:

Common Use Cases and Queries

Typical scenarios include secured requisition reporting, identifying lines generated from a parent line, and building buyer workload extracts. A representative query returning lines that descend from a given parent requisition line is:

  • SELECT requisition_line_id, requisition_header_id, parent_req_line_id, line_num, quantity, preparer_id FROM po_owned_requisition_lines WHERE parent_req_line_id = :p_parent_req_line_id;

To list all currently open, uncancelled lines for a preparer:

  • SELECT requisition_header_id, requisition_line_id, line_num, item_description, quantity FROM po_owned_requisition_lines WHERE preparer_id = :p_preparer_id AND cancel_flag = 'N' ORDER BY requisition_header_id, line_num;

Because the view enforces ownership, results are automatically restricted to requisitions the session user may access, making it suitable for embedded LOVs, BI Publisher datasets, and custom concurrent programs without additional row-level predicates.