Results for “preparer_name”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The POR_RCV_REQS_NAME_V view is a reporting object owned by the APPS schema within the Oracle iProcurement (ICX) product family. It exposes requisition-to-receipt information related to receiving activities in Oracle E-Business Suite, and it belongs to the same functional grouping as the POR_RCV_* family of views used by iProcurement and the receiving workflow. Its status is VALID in both Oracle EBS 12.1.1 and 12.2.2, and its structure and definition are effectively shared across these releases.
The view consolidates requisition header and line data with purchase order, purchase release, vendor, shipment, and person information, then presents a denormalized result set. The inclusion of PER_ALL_PEOPLE_F joins indicates that the view resolves human-resources person identifiers (both the requisition preparer and the requisition line "to person") to descriptive full names, which are useful for display and selection purposes. Combined with the POR_VIEW_REQS_PKG.GET_REQ_TOTAL function call, the view provides a single row per requisition/delivery context enriched with a computed total, making it suitable for iProcurement pages that display requisition demand awaiting receipt.
Underlying Base Objects
The documented referenced objects for this view include PO_REQUISITION_HEADERS, PO_REQUISITION_LINES, PO_REQ_DISTRIBUTIONS, PO_DISTRIBUTIONS, PO_HEADERS, PO_LINE_LOCATIONS, PO_RELEASES, PO_VENDORS (exposed as a view), PO_SYSTEM_PARAMETERS, OE_ORDER_HEADERS, RCV_SHIPMENT_LINES, HR_ALL_ORGANIZATION_UNITS_TL, and PER_ALL_PEOPLE_F. All are referenced through APPS synonyms.
These joins link requisition lines to their corresponding PO distributions, line locations, and PO headers so that only deliverable quantities remain visible. Filtering conditions limit results to open, approved shipments that are routed for receiving (RECEIVING_ROUTING_ID = 3) and whose shipment type is STANDARD, BLANKET, or SCHEDULED. The documented view text also includes a UNION ALL branch that sources internal sales order data from OE_ORDER_HEADERS and organization units, extending the view beyond pure purchasing to encompass internal requisitions fulfilled through order management.
Key Columns
- REQUISITION_HEADER_ID / SEGMENT1 / DESCRIPTION — identify the requisition and its document number and description.
- PREPARER_ID — the person who prepared the requisition.
- TO_PERSON_ID — the person for whom the line was requested (the recipient or deliver-to person).
- PAPF.FULL_NAME / PAPF2.FULL_NAME — resolved full names for the to-person and preparer, obtained through effective-dated lookups on
PER_ALL_PEOPLE_F. - ORDER_NUM_REL_NUM — a concatenated display value combining the PO or order number with its release number.
- PO_NUMBER / ORDER_NUMBER / PO_RELEASE_NUMBER — the purchase order, internal order, and release identifiers.
- VENDOR — the supplier or organization name associated with the source document.
- CREATION_DATE — the requisition creation timestamp.
- GET_REQ_TOTAL(...) — the result of the
POR_VIEW_REQS_PKGfunction, providing the aggregated requisition total.
Common Use Cases and Queries
Typical usage is on iProcurement pages and receiving-related reports where a user must review requisitions with outstanding quantities, display the preparer and recipient names in readable form, and identify the corresponding vendor or order. A representative query filtering to a specific preparer or recipient follows:
SELECT requisition_header_id,
segment1,
full_name,
order_num_rel_num,
vendor,
creation_date
FROM apps.por_rcv_reqs_name_v
WHERE preparer_id = :preparer_id
ORDER BY creation_date DESC;
Because the view relies on PER_ALL_PEOPLE_F effective-dated subqueries to return the latest name version, joins to additional HR data should also be filtered by EFFECTIVE_END_DATE to avoid duplicate person rows. For integration and diagnostics, the view serves as a ready-made join between purchasing and HR person references, reducing the need to reconstruct the multi-table relationship across requisitions, distributions, releases, and person records.
-
View: POR_RCV_REQS_NAME_V 12.2.2
APPS.POR_RCV_REQS_NAME_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ OE_ORDER_HEADERS·↳ PER_ALL_PEOPLE_F·Explore ICX module →
-
View: POR_RCV_REQS_VENDOR_V 12.2.2
APPS.POR_RCV_REQS_VENDOR_V·↳ PER_ALL_PEOPLE_F·↳ PO_DISTRIBUTIONS·↳ PO_HEADERS·Explore ICX module →
-
Purged requisitions
-
Header information in PO_HEADERS, PO_RELEASES, and PO_REQUISITION_HEADERS
APPS.PO_DOCUMENT_HEADERS_VIEW·↳ PO_DOCUMENT_TYPES_ALL_B·↳ PO_DOCUMENT_TYPES_ALL_TL·↳ PO_EMPLOYEES_SV·Explore PO module →
-
View with unrestricted access and data feasible to be seen by all users in the system
APPS.POR_VIEW_REQS_BY_PUBLIC_V·↳ AP_CARDS·↳ FND_GLOBAL·↳ PER_ALL_PEOPLE_F·Explore ICX module →
-
View restricted to document owner and to those in relevant approval and security hierarchy
APPS.POR_VIEW_REQS_BY_HIERARCHY_V·↳ AP_CARDS·↳ FND_GLOBAL·↳ FND_USER·Explore ICX module →
-
View: POR_RCV_REQS_NAME_V 12.1.1
APPS.POR_RCV_REQS_NAME_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ OE_ORDER_HEADERS·↳ PER_ALL_PEOPLE_F·Explore ICX module →
-
View: POR_RCV_REQS_VENDOR_V 12.1.1
APPS.POR_RCV_REQS_VENDOR_V·↳ PER_ALL_PEOPLE_F·↳ PO_DISTRIBUTIONS·↳ PO_HEADERS·Explore ICX module →
-
View Requisition By Group
APPS.POR_VIEW_REQS_BY_GROUP_V·↳ AP_CARDS·↳ FINANCIALS_SYSTEM_PARAMETERS·↳ FND_CURRENCY·Explore ICX module →
-
This view is obsolete.
APPS.POR_VIEW_REQS_BY_APPROVER_V·↳ AP_CARDS·↳ FINANCIALS_SYSTEM_PARAMETERS·↳ FND_CURRENCY·Explore ICX module →
-
Orders That I Approved View
APPS.POR_VIEW_REQS_BY_APPR_V·↳ AP_CARDS·↳ FINANCIALS_SYSTEM_PARAMETERS·↳ FND_GLOBAL·Explore ICX module →
-
View Requisition Autoquery
APPS.POR_VIEW_REQS_AUTOQUERY_V·↳ AP_CARDS·↳ FND_GLOBAL·↳ PER_ALL_PEOPLE_F·Explore ICX module →
-
This view access is restricted to the document owner, subsequent approvers and those individuals defined as buyers
APPS.POR_VIEW_REQS_BY_PURCHASING_V·↳ AP_CARDS·↳ FND_GLOBAL·↳ FND_USER·Explore ICX module →
-
Purged requisitions
-
Header information in PO_HEADERS, PO_RELEASES, and PO_REQUISITION_HEADERS
APPS.PO_DOCUMENT_HEADERS_VIEW·↳ PO_DOCUMENT_TYPES_ALL_B·↳ PO_DOCUMENT_TYPES_ALL_TL·↳ PO_EMPLOYEES_SV·Explore PO module →
-
Orders That I Approved View
APPS.POR_VIEW_REQS_BY_APPR_V·↳ AP_CARDS·↳ FINANCIALS_SYSTEM_PARAMETERS·↳ FND_GLOBAL·Explore ICX module →
-
View restricted to document owner and to those in relevant approval and security hierarchy
APPS.POR_VIEW_REQS_BY_HIERARCHY_V·↳ AP_CARDS·↳ FND_GLOBAL·↳ FND_USER·Explore ICX module →
-
View restricted to original and subsequent owners of document
APPS.POR_VIEW_REQS_BY_PRIVATE_V·↳ AP_CARDS·↳ FND_GLOBAL·↳ FND_USER·Explore ICX module →
-
View with unrestricted access and data feasible to be seen by all users in the system
APPS.POR_VIEW_REQS_BY_PUBLIC_V·↳ AP_CARDS·↳ FND_GLOBAL·↳ PER_ALL_PEOPLE_F·Explore ICX module →
-
This view is obsolete.
APPS.POR_VIEW_REQS_BY_APPROVER_V·↳ AP_CARDS·↳ FINANCIALS_SYSTEM_PARAMETERS·↳ FND_CURRENCY·Explore ICX module →
-
View: POR_VIEW_REQS_V 12.2.2
View Requisition
APPS.POR_VIEW_REQS_V·↳ AP_CARDS·↳ FINANCIALS_SYSTEM_PARAMETERS·↳ FND_CURRENCY·Explore ICX module →
-
View: POR_VIEW_REQS_V 12.1.1
View Requisition
APPS.POR_VIEW_REQS_V·↳ AP_CARDS·↳ FINANCIALS_SYSTEM_PARAMETERS·↳ FND_CURRENCY·Explore ICX module →
-
View Requisition Autoquery
APPS.POR_VIEW_REQS_AUTOQUERY_V·↳ AP_CARDS·↳ FND_GLOBAL·↳ PER_ALL_PEOPLE_F·Explore ICX module →
-
View restricted to original and subsequent owners of document
APPS.POR_VIEW_REQS_BY_PRIVATE_V·↳ AP_CARDS·↳ FND_GLOBAL·↳ FND_USER·Explore ICX module →
-
This view access is restricted to the document owner, subsequent approvers and those individuals defined as buyers
APPS.POR_VIEW_REQS_BY_PURCHASING_V·↳ AP_CARDS·↳ FND_GLOBAL·↳ FND_USER·Explore ICX module →
-
View: POFV_REQUISITIONS 12.1.1
- Retrofitted
APPS.POFV_REQUISITIONS·↳ AP_CARDS_ALL·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_GENERAL·Explore PO module →
-
View Requisition By Group
APPS.POR_VIEW_REQS_BY_GROUP_V·↳ AP_CARDS·↳ FINANCIALS_SYSTEM_PARAMETERS·↳ FND_CURRENCY·Explore ICX module →
-
View: POFV_REQUISITIONS 12.2.2
- Retrofitted
APPS.POFV_REQUISITIONS·↳ AP_CARDS_ALL·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_GENERAL·Explore PO 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_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: ICX_PO_REQ_HEADERS_V 12.1.1
Requistion Headers View
APPS.ICX_PO_REQ_HEADERS_V·↳ FINANCIALS_SYSTEM_PARAMETERS·↳ FND_CURRENCY·↳ FND_GLOBAL·Explore ICX module →
-
Requisition Headers View
APPS.ICX_PO_REQUISITION_HEADERS_V·↳ FINANCIALS_SYSTEM_PARAMETERS·↳ FND_CURRENCY·↳ FND_GLOBAL·Explore ICX module →
-
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 →
-
Requisition Headers View
APPS.ICX_PO_REQUISITION_HEADERS_V·↳ FINANCIALS_SYSTEM_PARAMETERS·↳ FND_CURRENCY·↳ FND_GLOBAL·Explore ICX module →
-
View: ICX_PO_REQ_HEADERS_V 12.2.2
Requistion Headers View
APPS.ICX_PO_REQ_HEADERS_V·↳ FINANCIALS_SYSTEM_PARAMETERS·↳ FND_CURRENCY·↳ FND_GLOBAL·Explore ICX module →
-
10SC ONLY - Retrofitted
APPS.PO_REQUISITION_HEADERS_V·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ FND_GLOBAL·↳ GL_SETS_OF_BOOKS·Explore PO 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_HEADER_V 12.1.1
Requisition Header View
APPS.POR_HEADER_V·↳ AP_CARDS·↳ FND_GLOBAL·↳ FND_PROFILE·Explore ICX module →
-
10SC ONLY - Retrofitted
APPS.PO_REQUISITION_HEADERS_V·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ FND_GLOBAL·↳ GL_SETS_OF_BOOKS·Explore PO module →
-
Open Requisition Lines View
APPS.ICX_PO_REQUISITION_OPEN_V·↳ FND_CURRENCY·↳ FND_GLOBAL·↳ GL_DAILY_CONVERSION_TYPES·Explore ICX module →
-
Open Requisition Lines View
APPS.ICX_PO_REQUISITION_OPEN_V·↳ FND_CURRENCY·↳ FND_GLOBAL·↳ GL_DAILY_CONVERSION_TYPES·Explore ICX module →
-
Requistion Lines Inquiry View
APPS.ICX_PO_REQUISITION_LINES_INQ_V·↳ FINANCIALS_SYSTEM_PARAMETERS·↳ FND_CURRENCY·↳ FND_GLOBAL·Explore ICX module →
-
Requistion Lines Inquiry View
APPS.ICX_PO_REQUISITION_LINES_INQ_V·↳ FINANCIALS_SYSTEM_PARAMETERS·↳ FND_CURRENCY·↳ FND_GLOBAL·Explore ICX module →
-
Requisition Distributions View
APPS.ICX_PO_REQ_LINES_DIST_V·↳ FND_CURRENCY·↳ FND_GLOBAL·↳ GL_CODE_COMBINATIONS_KFV·Explore ICX module →
-
Requisition Distributions View
APPS.ICX_PO_REQ_LINES_DIST_V·↳ FND_CURRENCY·↳ FND_GLOBAL·↳ GL_CODE_COMBINATIONS_KFV·Explore ICX module →
-
Requisition Import interface table
-
Requisition Import interface table