Search Results po_req_lines_in_pool_sec_v




Overview
Explore in AI Chat

Overview

PO_REQ_LINES_IN_POOL_SEC_V is a Purchasing (PO) module view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes purchase requisition lines that are eligible to appear in the sourcing "pool" — that is, approved, open, unassigned requisition lines that have been flagged for inclusion in the buyer's pooled sourcing workbench (for example, the Autocreate or Sourcing screens used to generate RFQs and auctions). The view joins requisition headers to requisition lines and filters out cancelled, finally closed, unapproved, and location-assigned records, while also restricting rows to vendor-sourced lines.

Its defining characteristic is the inclusion of the AUCTION_DISPLAY_NUMBER column, which is the field most frequently searched against this object. This column presents a human-readable auction identifier so that buyers and reporting tools can associate a pooled requisition line with the auction it will feed, without joining directly to the auction tables. The view is therefore a convenience and security layer used in reporting, personalizations, and integration extracts where a curated set of pool-eligible lines is required.

Underlying Base Objects

The view is documented as being defined over two base objects:

  • PO_REQUISITION_HEADERS_ALL (referenced through a SYNONYM) — the requisition header table supplying ORG_ID, REQUISITION_HEADER_ID, SEGMENT1 (requisition number), and the header-level status and cancel flags.
  • PO_REQUISITION_LINES (referenced through a SYNONYM) — the requisition line table supplying line identifiers, vendor information, auction and blanket agreement references, and line-level flag columns.

The view text joins the two on REQUISITION_HEADER_ID. It applies header filters requiring CANCEL_FLAG of 'N', CLOSED_CODE other than 'FINALLY CLOSED', and AUTHORIZATION_STATUS of 'APPROVED', and line filters requiring LINE_LOCATION_ID to be null (-999 sentinel), REQS_IN_POOL_FLAG of 'Y', CANCEL_FLAG of 'N', CLOSED_CODE other than 'FINALLY CLOSED', MODIFIED_BY_AGENT_FLAG of 'N', and SOURCE_TYPE_CODE of 'VENDOR'.

The view name carries the "_SEC_" suffix, confirming that row-level organization security is enforced. The ORG_ID predicate either passes all rows in a single-org instance or restricts to organizations returned by PER_ORGANIZATION_LIST for the security profile held in the XLA_MO_SECURITY_PROFILE_LEVEL profile option.

Key Columns

  • ORG_ID — operating unit that owns the requisition header; drives the security filter.
  • REQUISITION_HEADER_ID / REQUISITION_LINE_ID — primary and foreign key identifiers linking to the requisition header and line tables.
  • REQUISITION_NUM — the header's SEGMENT1 requisition number for user-facing display.
  • LINE_NUM — requisition line number.
  • SUGGESTED_VENDOR_NAME / SUGGESTED_VENDOR_LOCATION — suggested supplier and location text carried on the line.
  • VENDOR_ID / VENDOR_SITE_ID — surrogate keys for the suggested supplier and supplier site.
  • AUCTION_DISPLAY_NUMBER — the readable auction number associated with the line; the primary search target for this view.
  • AUCTION_HEADER_ID — the auction header key linked to that display number.
  • BLANKET_PO_HEADER_ID — blanket purchase agreement header, if the line references one.

Common Use Cases and Queries

Typical uses include building custom sourcing reports, validating which requisition lines will enter the pool, and extracting auction linkage for downstream integration. A representative query filtering on the searched field is shown below.

  • Identify pooled lines by auction display number:
    SELECT requisition_num, line_num, auction_display_number, auction_header_id FROM apps.po_req_lines_in_pool_sec_v WHERE auction_display_number = 'AUCTION-1234';
  • List all pool-eligible lines for an operating unit:
    SELECT requisition_num, line_num, suggested_vendor_name FROM apps.po_req_lines_in_pool_sec_v WHERE org_id = :org_id;
  • Find lines tied to a blanket purchase agreement:
    SELECT requisition_num, line_num, blanket_po_header_id FROM apps.po_req_lines_in_pool_sec_v WHERE blanket_po_header_id IS NOT NULL;

Because organization security is embedded in the view definition, queries automatically return only the operating units permitted by the caller's security profile.