Search Results firm_status_lookup_code




Overview
Explore in AI Chat

Overview

The view ICX_PO_RFQ_LINE_LOC_V belongs to the Oracle iProcurement (ICX) product family and is documented in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. Its ETRM description is recorded simply as Obsolete, and the implementation metadata states that it is not implemented in the database. This means the object is a vestigial definition retained in the data model documentation but no longer compiled or deployed in a standard installation. Historically, the view served to expose RFQ (Request for Quotation) shipment and line-location information — quantity, pricing, discount, lead time, ship-to details, and terms — to iProcurement sourcing and requisitioning screens. Because it is obsolete, no supported reporting or integration path should depend on it in 12.1.1 or 12.2.2; it is retained here primarily for impact analysis and migration awareness.

Underlying Base Objects

Although the ETRM "Referenced base objects" field is blank, the documented view text shows the view is defined over the following base tables:

The view performs no filtering beyond the RFQ document-type restriction in PO_HEADERS, and exposes the full set of line-location columns.

Key Columns

The projection mirrors the PO_LINE_LOCATIONS structure. Relevant columns include:

Common Use Cases and Queries

In legacy customizations this view was queried for RFQ shipment pricing and discount data. Because it is obsolete and not implemented, equivalent logic should now be sourced directly from PO_LINE_LOCATIONS joined to PO_HEADERS, HR_LOCATIONS, ORG_ORGANIZATION_DEFINITIONS, AP_TERMS, and AP_TAX_CODES. A typical historical query pattern was:

SELECT h.segment1, pll.price_discount, pll.quantity
FROM   po_headers h, po_line_locations pll
WHERE  h.po_header_id = pll.po_header_id
AND    h.type_lookup_code = 'RFQ';

Such queries should be redirected to the base tables for supported behavior. Any existing report or interface referencing ICX_PO_RFQ_LINE_LOC_V should be reviewed during upgrade or assessment to remove the obsolete dependency.