Search Results dest_organization




Overview
Explore in AI Chat

Overview

APPS.ICX_PO_REQUISITION_OPEN_V is a PL/SQL-based view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It is registered in FND Design Data as ICX.ICX_PO_REQUISITION_OPEN_V and holds a VALID status. The view exposes open purchasing requisition lines for self-service procurement and iProcurement shopping flows, presenting a flattened, presentation-ready record set rather than raw transactional rows. Because its definitions invoke packages such as ICX_GET, ICX_UTIL, PO_INQ_SV, HR_GENERAL, HR_SECURITY, and FND_GLOBAL, the view performs runtime derivations—currency conversion, security filtering, and requester resolution—rather than simple joins.

Oracle classifies this object as Internal Use Only. Oracle Corporation does not support direct access to application data through this view except from standard Oracle Applications programs. Customers who reference it in custom reports or interfaces do so at their own risk, since its definition may change without notice in patches or upgrades.

Underlying Base Objects

The view is defined over a documented set of base objects spanning purchasing, inventory, HR, and general ledger:

This object was specifically retrieved as a match for the search term dest_organization, which is one of its exposed columns.

Key Columns

Primary keys and identifiers include REQUISITION_HEADER_ID, REQUISITION_LINE_ID, LINE_NUM, LINE_TYPE, LINE_TYPE_ID, ITEM_ID, and CATEGORY_ID. Quantity and status columns include QUANTITY, QUANTITY_RECEIVED, QUANTITY_DELIVERED, QUANTITY_CANCELLED, CANCEL_FLAG, and MODIFIED_BY_AGENT_FLAG.

Pricing is exposed through UNIT_PRICE (numeric) and DISPLAY_UNIT_PRICE (VARCHAR2 of 4000 characters, carrying currency-formatted output). Supplier and delivery context is represented by SUGGESTED_VENDOR_NAME, SUGGESTED_VENDOR_LOCATION, SUGGESTED_VENDOR_CONTACT, SUGGESTED_VENDOR_PHONE, DEST_ORGANIZATION, DELIVER_TO_LOCATION, DELIVER_TO_LOCATION_ID, DEST_SUBINVENTORY, and SOURCE_SUBINVENTORY.

Descriptive and audit fields include ITEM_DESCRIPTION, NOTE_TO_AGENT, NOTE_TO_RECEIVER, JUSTIFICATION, REFERENCE_NUM, NEED_BY_DATE, REQUESTOR, TO_PERSON_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY, plus ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 for DFF support.

Common Use Cases and Queries

The view supports self-service requisition reporting, open-commitment analysis, and destination-based sourcing reviews. A typical query filtering on the searched column follows:

SELECT requisition_header_id, requisition_line_id, line_num, item_description, quantity, dest_organization, deliver_to_location, need_by_date, requestor
FROM apps.icx_po_requisition_open_v
WHERE dest_organization = 'M1 – Seattle Manufacturing';

Analysts also aggregate open demand by destination or category:

SELECT dest_organization, category_id, SUM(quantity) total_qty
FROM apps.icx_po_requisition_open_v
WHERE cancel_flag = 'N'
GROUP BY dest_organization, category_id;

Because underlying logic uses HR security packages, results are filtered by the responsibility and user context in which the session runs. Access should be treated as unsupported unless invoked from standard Oracle application code.