Results for “auction_display_number”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
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.
-
APPS.PO_REQ_LINES_IN_POOL_SEC_V·↳ PO_REQUISITION_HEADERS_ALL·↳ PO_REQUISITION_LINES·Explore PO module →
-
Requisition reschedule interface table
-
This view is used for the Awarded Bids Detail report. It contains data for both Standard Purchase Orders and Blanket Purchase Agreements.
APPS.PON_MI_AUCTIONSUMMARY_V·↳ PON_MI_AUC_BUYERAUC_V·Explore PON module →
-
APPS.PO_REQ_LINES_IN_POOL_SEC_V·↳ PO_REQUISITION_HEADERS_ALL·↳ PO_REQUISITION_LINES·Explore PO module →
-
View: PON_MI_RFQSUMMARY_V 12.1.1
This view is used by the Accepted Quotations Detail report. It contains summarized data for all Accepted Quotations.
APPS.PON_MI_RFQSUMMARY_V·↳ PON_MI_AUC_RFQ_V·Explore PON module →
-
View: PON_MI_RFQSUMMARY_V 12.2.2
This view is used by the Accepted Quotations Detail report. It contains summarized data for all Accepted Quotations.
APPS.PON_MI_RFQSUMMARY_V·↳ PON_MI_AUC_RFQ_V·Explore PON module →
-
Requisition reschedule interface table
-
View: PON_MI_AUC_RFQ_V 12.2.2
This view is used by the Buyer's Activity Summary report. It contains data for all Accepted Quotations.
APPS.PON_MI_AUC_RFQ_V·↳ PON_AUCTION_HEADERS·↳ PON_AUC_DOCTYPES·↳ PON_BID_HEADERS·Explore PON module →
-
View: PON_MI_AUC_BUYERAUC_V 12.2.2
This view is used by the Buyer's Activity Summary report. It contains data for all Awarded Auctions.
APPS.PON_MI_AUC_BUYERAUC_V·↳ PON_AUCTION_HEADERS·↳ PON_AUC_DOCTYPES·↳ PON_BID_HEADERS·Explore PON module →
-
View: PON_MI_AUC_RFQ_V 12.1.1
This view is used by the Buyer's Activity Summary report. It contains data for all Accepted Quotations.
APPS.PON_MI_AUC_RFQ_V·↳ PON_AUCTION_HEADERS·↳ PON_AUC_DOCTYPES·↳ PON_BID_HEADERS·Explore PON module →
-
This view is used for the Awarded Bids Detail report. It contains data for both Standard Purchase Orders and Blanket Purchase Agreements.
APPS.PON_MI_AUCTIONSUMMARY_V·↳ PON_MI_AUC_BUYERAUC_V·Explore PON module →
-
View: PON_MI_AUC_BUYERAUC_V 12.1.1
This view is used by the Buyer's Activity Summary report. It contains data for all Awarded Auctions.
APPS.PON_MI_AUC_BUYERAUC_V·↳ PON_AUCTION_HEADERS·↳ PON_AUC_DOCTYPES·↳ PON_BID_HEADERS·Explore PON module →
-
View: POBV_STD_PO_LINES 12.1.1
- Retrofitted
APPS.POBV_STD_PO_LINES·↳ HR_ALL_ORGANIZATION_UNITS·↳ PO_HEADERS_ALL·↳ PO_LINES_ALL·Explore PO module →
-
View: POBV_PO_LINES 12.1.1
- Retrofitted
APPS.POBV_PO_LINES·↳ HR_ALL_ORGANIZATION_UNITS·↳ PO_HEADERS_ALL·↳ PO_LINES_ALL·Explore PO module →
-
View: PO_LINES_TRX_V 12.2.2
View on po_lines table.
APPS.PO_LINES_TRX_V·↳ PO_DISTRIBUTIONS_ALL·↳ PO_LINES·Explore PO module →
-
View: PO_LINES_ARCHIVE_XML 12.1.1
APPS.PO_LINES_ARCHIVE_XML·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ MTL_SYSTEM_ITEMS_KFV·↳ MTL_UNITS_OF_MEASURE_TL·Explore PO module →
-
View: POBV_STD_PO_LINES 12.2.2
- Retrofitted
APPS.POBV_STD_PO_LINES·↳ HR_ALL_ORGANIZATION_UNITS·↳ PO_HEADERS_ALL·↳ PO_LINES_ALL·Explore PO module →
-
View: POBV_PO_LINES 12.2.2
- Retrofitted
APPS.POBV_PO_LINES·↳ HR_ALL_ORGANIZATION_UNITS·↳ PO_HEADERS_ALL·↳ PO_LINES_ALL·Explore PO module →
-
View: POBV_REQUISITION_LINES 12.1.1
- Retrofitted
APPS.POBV_REQUISITION_LINES·↳ HR_ALL_ORGANIZATION_UNITS·↳ PO_LINE_TYPES·↳ PO_REQUISITION_HEADERS_ALL·Explore PO module →
-
View: POBV_BKT_PO_LINES 12.2.2
- Retrofitted
APPS.POBV_BKT_PO_LINES·↳ HR_ALL_ORGANIZATION_UNITS·↳ PO_HEADERS_ALL·↳ PO_LINES_ALL·Explore PO module →
-
View: POBV_BKT_PO_LINES 12.1.1
- Retrofitted
APPS.POBV_BKT_PO_LINES·↳ HR_ALL_ORGANIZATION_UNITS·↳ PO_HEADERS_ALL·↳ PO_LINES_ALL·Explore PO module →
-
View: PO_LINES_INQ_V 12.1.1
- Retrofitted
APPS.PO_LINES_INQ_V·↳ AP_TERMS·↳ GL_DAILY_CONVERSION_TYPES·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore PO module →
-
- Retrofitted
APPS.PO_REQUISITION_LINES_INQ_V·↳ BOM_RESOURCES·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ GL_DAILY_CONVERSION_TYPES·Explore PO module →
-
View: POFV_BKT_PO_LINES 12.1.1
APPS.POFV_BKT_PO_LINES·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_GENERAL·Explore PO module →
-
View: POFV_STD_PO_LINES 12.1.1
Referenced Contract Number
APPS.POFV_STD_PO_LINES·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_GENERAL·Explore PO module →
-
View: POFV_PO_LINES 12.2.2
APPS.POFV_PO_LINES·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_GENERAL·Explore PO module →
-
For Internal Use Only: This table is global temporary table based on po_requisition_lines_all table. It is used for internal processing of data for PO Approval Submission Checks.
-
View: POBV_REQUISITION_LINES 12.2.2
- Retrofitted
APPS.POBV_REQUISITION_LINES·↳ HR_ALL_ORGANIZATION_UNITS·↳ PO_LINE_TYPES·↳ PO_REQUISITION_HEADERS_ALL·Explore PO module →
-
For Internal Use Only: This table is global temporary table based on po_lines_all table. It is used for internal processing of data for PO Approval Submission Checks.
-
View: PO_LINES_V 12.2.2
10SC ONLY
APPS.PO_LINES_V·↳ FND_GLOBAL·↳ MTL_SYSTEM_ITEMS·↳ MTL_UNITS_OF_MEASURE·Explore PO module →
-
Archived purchase order lines
-
View: POFV_STD_PO_LINES 12.2.2
Referenced Contract Number
APPS.POFV_STD_PO_LINES·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_GENERAL·Explore PO module →
-
View: POFV_BKT_PO_LINES 12.2.2
APPS.POFV_BKT_PO_LINES·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_GENERAL·Explore PO module →
-
View: POFV_REQUISITION_LINES 12.2.2
- Retrofitted
APPS.POFV_REQUISITION_LINES·↳ BOM_RESOURCES·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ FND_CURRENCIES_VL·Explore PO module →
-
View: POFV_PO_LINES 12.1.1
APPS.POFV_PO_LINES·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_GENERAL·Explore PO module →
-
View: PO_REQ_LINES_TRX_V 12.2.2
Requisition Lines View.
APPS.PO_REQ_LINES_TRX_V·↳ PO_CLM_INTG_GRP·↳ PO_REQUISITION_LINES·Explore PO module →
-
View: PO_REQUISITION_LINES_V 12.1.1
10SC ONLY - Retrofitted
APPS.PO_REQUISITION_LINES_V·↳ FND_GLOBAL·↳ GL_DAILY_CONVERSION_TYPES·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore PO module →
-
View: PO_LINES_ARCHIVE_XML 12.2.2
APPS.PO_LINES_ARCHIVE_XML·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ MTL_SYSTEM_ITEMS_KFV·↳ MTL_UNITS_OF_MEASURE_TL·Explore PO module →
-
View: PO_LINES_V 12.1.1
10SC ONLY
APPS.PO_LINES_V·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ FND_GLOBAL·↳ MTL_SYSTEM_ITEMS·Explore PO module →
-
View: PO_LINES_XML 12.2.2
APPS.PO_LINES_XML·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ MTL_SYSTEM_ITEMS_B·↳ MTL_SYSTEM_ITEMS_TL·Explore PO module →
-
Requisition lines
-
View: POFV_REQUISITION_LINES 12.1.1
- Retrofitted
APPS.POFV_REQUISITION_LINES·↳ BOM_RESOURCES·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ FND_CURRENCIES_VL·Explore PO module →
-
Purchase document lines (for purchase orders, purchase agreements, quotations, RFQs)
-
View: PO_REQUISITION_LINES_V 12.2.2
10SC ONLY - Retrofitted
APPS.PO_REQUISITION_LINES_V·↳ FND_GLOBAL·↳ GL_DAILY_CONVERSION_TYPES·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore PO module →
-
View: PO_LINES_XML 12.1.1
APPS.PO_LINES_XML·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ MTL_SYSTEM_ITEMS_KFV·↳ MTL_UNITS_OF_MEASURE_TL·Explore PO module →
-
View: PO_LINES_INQ_V 12.2.2
- Retrofitted
APPS.PO_LINES_INQ_V·↳ AP_TERMS·↳ FND_GLOBAL·↳ GL_DAILY_CONVERSION_TYPES·Explore PO module →
-
- Retrofitted
APPS.PO_REQUISITION_LINES_INQ_V·↳ BOM_RESOURCES·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ GL_DAILY_CONVERSION_TYPES·Explore PO module →
-
View: PO_LINES_MERGE_V 12.1.1
APPS.PO_LINES_MERGE_V·↳ PO_DRAFTS·↳ PO_GLOBAL·↳ PO_LINES_ALL·Explore PO module →
-
View: PO_LINES_MERGE_V 12.2.2
APPS.PO_LINES_MERGE_V·↳ PO_DRAFTS·↳ PO_LINES_ALL·↳ PO_LINES_DRAFT_ALL·Explore PO module →
-
Purchase document lines (for purchase orders, purchase agreements, quotations, RFQs)