Search Results get_max_line_num

Overview

PO_REQUISITION_HEADERS_V is an APPS-owned view in the Oracle E-Business Suite Purchasing (PO) module, documented in ETRM with a status of VALID. Its ETRM description is the terse notation "10SC ONLY - Retrofitted," which indicates that the object was carried over from an earlier documentation baseline and, in the 12.2.2 metadata set, is catalogued primarily to preserve lineage rather than to describe a supported, generally available interface. The view sits on top of the base requisition header entity and presents a denormalized, report-oriented projection of purchase requisition header data — one row per requisition header — enriched with display values that would otherwise require joins and package calls to resolve. Because it exposes preparer names, authorization status display text, document type descriptions, functional currency, computed requisition totals, and the maximum requisition line number, it is oriented toward inquiry screens, concurrent reports, and integration extracts that need human-readable requisition header information in a single query.

Underlying Base Objects

The view is defined over PO_REQUISITION_HEADERS (exposed as a synonym) as its primary driving table, aliased PRH, with ROWID also projected. It joins the following documented base objects:

• PER_PEOPLE_F — supplies PRH.PREPARER_ID match for full name resolution, restricted by effective dates.
• PO_LOOKUP_CODES — resolves AUTHORIZATION_STATUS to a DISPLAYED_FIELD, defaulting incomplete headers via NVL to 'INCOMPLETE'.
• PO_DOCUMENT_TYPES_ALL_B / PO_DOCUMENT_TYPES_ALL_TL — provide the document TYPE_NAME.
• GL_SETS_OF_BOOKS and FINANCIALS_SYSTEM_PARAMS_ALL — supply the ledger and functional CURRENCY_CODE context.
• PO_REQUISITION_HEADERS_PKG — GET_REQ_TOTAL returns the requisition total for a header and currency.
• PO_REQ_LINES_SV1 — GET_MAX_LINE_NUM returns the highest line number for the header.
• Additional documented dependencies include FND_GLOBAL, HR_GENERAL, HR_PERSON_NAME, and HR_SECURITY, which support session context and person-name/security resolution.

Because two columns are derived from stored PL/SQL functions, the view's performance and correctness depend on the availability and state of the PO_REQUISITION_HEADERS_PKG and PO_REQ_LINES_SV1 package bodies, not solely on the base table.

Key Columns

• REQUISITION_HEADER_ID — primary identifier of the requisition header; the join key to requisition lines.
• SEGMENT1–SEGMENT5 — the requisition number and key flexfield segments.
• AUTHORIZATION_STATUS / DISPLAYED_FIELD — raw authorization code and its lookup-based display text.
• PREPARER_ID / FULL_NAME — preparer identifier and effective-dated person name.
• TYPE_LOOKUP_CODE / TYPE_NAME — document type code and translated description.
• CURRENCY_CODE — functional currency derived through the ledger and financials system parameters.
• Get_Req_Total(...) — computed requisition total for the header and currency.
• Get_Max_Line_Num(...) — highest requisition line number associated with the header.
• ORG_ID — operating unit; used for multi-org security filtering.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Who columns.
• PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, REQUEST_ID — concurrent program context.
• ATTRIBUTE1–ATTRIBUTE15, ATTRIBUTE_CATEGORY — descriptive flexfield columns.
• WF_ITEM_TYPE, WF_ITEM_KEY — workflow linkage for approval processing.
• Flags include CLOSED_CODE, CANCEL_FLAG, ENABLED_FLAG, ON_LINE_FLAG, SUMMARY_FLAG, TRANSFERRED_TO_OE_FLAG, and research/preparer status flags.

Common Use Cases and Queries

Typical usage is requisition header reporting: listing open, incomplete, or cancelled requisitions with preparer names and displayed authorization status, and summarising requisition value by operating unit. Filters should always include ORG_ID for multi-org security.

• A report of incomplete requisitions by preparer.
• An extract of requisition totals by currency for ledger reconciliation.
• An inquiry joining REQUISITION_HEADER_ID to PO_REQUISITION_LINES_ALL for line detail.
• Workflow monitoring using WF_ITEM_TYPE and WF_ITEM_KEY.

Sample query:

SELECT h.segment1 requisition_number, h.full_name preparer, h.displayed_field auth_status, h.type_name document_type, h.currency_code, h.requisition_header_id FROM po_requisition_headers_v h WHERE h.org_id = :p_org_id AND NVL(h.cancel_flag,'N') = 'N' AND h.authorization_status = 'INCOMPLETE' ORDER BY h.creation_date DESC;

Because Get_Req_Total and Get_Max_Line_Num are invoked per row, restricting the result set before selecting those columns materially improves response time on large requisition volumes.