Search Results pofv_requisitions




Overview
Explore in AI Chat

Overview

POFV_REQUISITIONS is an APPS-owned, read-only view in the Oracle E-Business Suite Purchasing (PO) module. It is documented in ETRM for both 12.1.1 and 12.2.2 with a status of VALID and a description of "Retrofitted", indicating it was carried forward from an earlier release under Oracle Forms-to-OAF or HTML migration (an "F" view). The view presents a flattened, reporting-friendly projection of purchase requisition header data combined with operating unit names, preparer names, and procurement card context, and it attaches Forms-style display attributes (the "_LA:", "_DF:", and "_SEC:" prefixed pseudo-columns) used by the application framework for list-of-values labels, descriptive flexfield references, and organization security.

Because it exposes a stable, denormalized shape over requisition headers, the view serves reporting and integration consumers that need requisition context without joining to HR, AP, and FND lookup tables directly. It is defined WITH READ ONLY, so it is intended strictly for query access.

Underlying Base Objects

The view is defined over four primary sources and depends on several supporting objects. The driving table is PO_REQUISITION_HEADERS_ALL (exposed as a synonym), aliased RH. Operating unit information is supplied by HR_ALL_ORGANIZATION_UNITS (OP), joined on ORG_ID = ORGANIZATION_ID. Preparer name data comes from PER_PEOPLE_F (PP), an outer join on PREPARER_ID = PERSON_ID with effective date constraints against TRUNC(SYSDATE). Procurement card data is joined from AP_CARDS_ALL (AP) via a left outer join on PCARD_ID = CARD_ID. The ETRM 12.2.2 metadata additionally lists HR_GENERAL, HR_PERSON_NAME, and HR_SECURITY packages as referenced objects, reflecting the security and name-formatting predicates embedded in the view text. A final predicate, '_SEC:RH.ORG_ID' IS NOT NULL, enforces operating unit security filtering at runtime.

Key Columns

The user search term "authorizer_note" maps directly to the column AUTHORIZER_NOTE, which is selected from RH.NOTE_TO_AUTHORIZER in the view text. This column carries the free-text note entered by the requisitioner for the approver or authorizer. Other significant columns include:

Common Use Cases and Queries

Typical consumers use this view for requisition status reporting, approver/purchasing analysis, and integration extracts. A simple query to retrieve requisitions and their authorizer notes is:

SELECT document_number,
       operating_unit_name,
       preparer_name,
       authorizer_note,
       approved_date,
       last_updated_date
FROM   apps.pofv_requisitions
WHERE  authorizer_note IS NOT NULL
ORDER BY last_updated_date DESC;

To filter by operating unit, join to HR_OPERATING_UNITS or rely on the built-in organization security predicate. Because the view applies the '_SEC:RH.ORG_ID' filter, results are automatically restricted to the operating units accessible to the connected responsibility. The read-only nature and outer joins to PER_PEOPLE_F and AP_CARDS_ALL ensure requisitions appear even when preparer or card records are absent.