Results for “pcard_description”
14 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
POR_VIEW_HEADER_ALL_V is a view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the ICX (Oracle iProcurement) product module. Its documented description is "View Requsition Header view." In practice, the view consolidates the header-level attributes of purchase requisitions into a single, denormalized presentation layer used by the iProcurement and Oracle Purchasing user interfaces and by reporting tools that require requisition header information without joining the individual base tables and PL/SQL APIs.
The view performs two roles simultaneously. First, it exposes persistent columns directly from PO_REQUISITION_HEADERS_ALL, such as REQUISITION_HEADER_ID, SEGMENT1 (the requisition number), PREPARER_ID, DESCRIPTION, NOTE_TO_AUTHORIZER, AUTHORIZATION_STATUS, PCARD_ID, and the fifteen descriptive flexfield ATTRIBUTE columns. Second, it derives display-oriented values by invoking PL/SQL functions in the POR_VIEW_REQS_PKG package at query time, including the urgent flag, the note to the agent/buyer, the requisition total, the requestor, the deliver-to location, and a combined requestor/deliver-to string. Because several values are computed through function calls and profile-dependent formatting, the view is intended for read-oriented presentation rather than high-volume set processing.
Underlying Base Objects
The view is defined over the following documented base objects: PO_REQUISITION_HEADERS_ALL (synonym), the driving table holding the requisition header records; PER_ALL_PEOPLE_F (synonym), joined on the preparer to resolve the preparer's full name and restricted to the currently effective person record via the SYSDATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE predicate; AP_CARDS_ALL (synonym), outer-joined through the PCARD_ID to supply procurement card number and description; PO_LOOKUP_CODES (view), used twice over conceptually to resolve the AUTHORIZATION_STATUS into a DISPLAYED_FIELD via lookup type 'AUTHORIZATION STATUS', with NVL applied to default a null status to 'INCOMPLETE'; GL_SETS_OF_BOOKS (view) and FINANCIALS_SYSTEM_PARAMS_ALL (synonym), joined on SET_OF_BOOKS_ID and ORG_ID to establish the operating unit and currency context; and the packages POR_VIEW_REQS_PKG, FND_PROFILE, FND_CURRENCY, and FND_GLOBAL, which supply the derived columns and the currency and date formatting masks.
Key Columns
- REQUISITION_HEADER_ID — Primary key of the requisition header, used to link to the base tables and to the requisition line tables.
- REQ_NUM — Exposed from PRH.SEGMENT1; the human-readable requisition number.
- PREPARER_ID / PREPARER_NAME — The preparer's person identifier and the corresponding full name from PER_ALL_PEOPLE_F.
- APPROVAL_STATUS_CODE / STATUS — The base authorization status and its decoded display value from PO_LOOKUP_CODES.
- URGENT_FLAG — Derived by POR_VIEW_REQS_PKG.GET_URGENT_FLAG(REQUISITION_HEADER_ID). This is the column most relevant to a search on "urgent_flag"; it indicates whether the requisition has been marked as urgent and is computed at query time rather than stored on the header.
- PCARD_ID, PCARD_NUMBER, PCARD_DESCRIPTION — Procurement card detail, populated only when the requisition is card-funded.
- NOTE_TO_BUYER — Returned by POR_VIEW_REQS_PKG.GET_NOTE_TO_AGENT.
- CREATION_DATE — Converted to character using FND_PROFILE.VALUE_WNPS('ICX_DATE_FORMAT_MASK').
- REQUISITION_TOTAL — Returned by POR_VIEW_REQS_PKG.GET_REQ_TOTAL and formatted using FND_CURRENCY.SAFE_GET_FORMAT_MASK against the set of books currency.
- REQUESTOR, SHIP_TO, EMERGENCY_PO_NUM — Derived requestor identity, combined requestor/deliver-to string, and the emergency purchase order number.
- ATTRIBUTE1 through ATTRIBUTE15 — Descriptive flexfield segments carried through from the header table.
Common Use Cases and Queries
The view is typically queried to surface urgent requisitions for a preparer, to obtain a formatted requisition total, or to render a header summary for a custom report or OAF page. Because URGENT_FLAG is computed, filtering on it in the WHERE clause forces the function to execute per row; for performance-sensitive extracts it is preferable to filter on the base table first and evaluate the flag in the select list.
Sample query listing urgent requisitions with preparer and total:
- SELECT v.req_num, v.preparer_name, v.status, v.urgent_flag, v.requisition_total FROM apps.por_view_header_all_v v WHERE v.urgent_flag = 'Y' AND v.preparer_id = :p_person_id ORDER BY v.creation_date DESC;
- SELECT v.requisition_header_id, v.req_num, v.requestor, v.ship_to, v.requisition_total FROM apps.por_view_header_all_v v WHERE v.requisition_header_id = :p_header_id;
- SELECT v.req_num, v.pcard_number, v.pcard_description FROM apps.por_view_header_all_v v WHERE v.pcard_id IS NOT NULL;
Caveats: the view restricts results to preparers with an effective-dated person record covering SYSDATE, so historic preparers may be excluded; the currency and date masks are profile-driven, so output format depends on session profile settings; and the ORG_ID join to FINANCIALS_SYSTEM_PARAMS_ALL anchors results to a set of books, which must be accounted for in multi-organization reporting. When accurate performance is required, join directly to PO_REQUISITION_HEADERS_ALL and invoke POR_VIEW_REQS_PKG functions selectively.
-
View: POR_VIEW_HEADER_ALL_V 12.2.2
View Requsition Header view
APPS.POR_VIEW_HEADER_ALL_V·↳ AP_CARDS_ALL·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ FND_CURRENCY·Explore ICX module →
-
View: POR_VIEW_HEADER_ALL_V 12.1.1
View Requsition Header view
APPS.POR_VIEW_HEADER_ALL_V·↳ AP_CARDS_ALL·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ FND_CURRENCY·Explore ICX module →
-
View: POR_HEADER_V 12.2.2
Requisition Header View
APPS.POR_HEADER_V·↳ AP_CARDS·↳ FND_GLOBAL·↳ FND_PROFILE·Explore ICX module →
-
View: POR_VIEW_HEADER_V 12.1.1
View Requisition Header
APPS.POR_VIEW_HEADER_V·↳ AP_CARDS·↳ FINANCIALS_SYSTEM_PARAMETERS·↳ FND_CURRENCY·Explore ICX module →
-
View: POR_VIEW_HEADER_V 12.2.2
View Requisition Header
APPS.POR_VIEW_HEADER_V·↳ AP_CARDS·↳ FINANCIALS_SYSTEM_PARAMETERS·↳ FND_CURRENCY·Explore ICX module →
-
View: POR_HEADER_V 12.1.1
Requisition Header View
APPS.POR_HEADER_V·↳ AP_CARDS·↳ FND_GLOBAL·↳ FND_PROFILE·Explore ICX module →
-
VIEW: APPS.POR_VIEW_HEADER_V 12.1.1
-
VIEW: APPS.POR_VIEW_HEADER_V 12.2.2
-
VIEW: APPS.POR_HEADER_V 12.1.1
-
VIEW: APPS.POR_HEADER_V 12.2.2
-
eTRM - ICX Tables and Views 12.1.1
-
eTRM - ICX Tables and Views 12.2.2