Results for “preparer_id”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
POR_RCV_HOME_REQS_V is a view owned by the APPS schema within the Oracle iProcurement (ICX) product family. Its documented purpose is to query requisitions that are surfaced on the receiving home page, presenting a consolidated, denormalized picture of requisition demand that is either expected as an external purchase order shipment or as an internal inventory shipment. In Oracle EBS 12.1.1 and 12.2.2 this view acts primarily as a reporting and UI-support construct rather than a transactional object; no DML is expected against it, and it is consumed by the receiving home page region to show the user the requisition lines awaiting receipt.
The view is relevant to users who search on the term po_requisition_headers because its driving table is PO_REQUISITION_HEADERS (referenced in the metadata as the synonym PO_REQUISITION_HEADERS under the APPS schema). The view resolves requisition header attributes and joins them forward through requisition lines and purchase order or shipment line structures, so it answers the question: which of my requisitions have receipt-qualifying demand remaining?
Underlying Base Objects
Documented referenced base objects include PO_REQUISITION_HEADERS, PO_REQUISITION_LINES, PO_REQ_DISTRIBUTIONS, PO_HEADERS_ALL, PO_LINES_TRX_V, PO_LINE_LOCATIONS_TRX_V, PO_DISTRIBUTIONS_TRX_V, PO_VENDORS, RCV_SHIPMENT_LINES, HR_ALL_ORGANIZATION_UNITS_TL, MTL_SYSTEM_ITEMS, and the packages PO_INQ_SV and PO_CLM_INTG_GRP. The transactional joins map requisition headers to requisition lines, then to line locations and distributions, then to purchase order headers and vendors, filtered by receiving routing.
Structurally the view is a UNION ALL of two branches. The first branch joins PO_REQUISITION_HEADERS, PO_REQUISITION_LINES, PO_LINE_LOCATIONS, PO_HEADERS, PO_DISTRIBUTIONS, and PO_VENDORS, restricting demand to line locations that are approved, not cancelled, not finally closed, of shipment type STANDARD, BLANKET, or SCHEDULED, with a receiving routing identifier of 3, and with a positive open quantity (ordered minus delivered minus cancelled). The second branch covers internal inventory requisitions, joining requisition headers and lines to RCV_SHIPMENT_LINES and HR_ALL_ORGANIZATION_UNITS, with routing header 3 and shipped quantity exceeding received quantity. This union design is what allows a single home page query to blend external purchasing demand with internal inventory replenishment demand.
Key Columns
- REQUISITION_HEADER_ID — the primary identifier of the requisition header, linking back to PO_REQUISITION_HEADERS.
- SEGMENT1 — the human-readable requisition number.
- DESCRIPTION — the requisition header description.
- PREPARER_ID — the user who prepared the requisition.
- TO_PERSON_ID — the requisition line requestor/deliver-to person.
- ORDER_NUM — the purchase order number for externally sourced demand; for inventory-sourced rows this is populated via the PO_INQ_SV.GET_SO_NUMBER call rather than a purchase order.
- VENDOR — the vendor name for purchase order demand; for inventory demand the organization unit name is returned instead.
Common Use Cases and Queries
The principal use case is the receiving home page listing requisition demand pending receipt. A secondary use is ad hoc reporting on open, receipt-eligible requisition activity across purchasing and inventory sourcing.
SELECT requisition_header_id, segment1, description,
preparer_id, to_person_id, order_num, vendor
FROM apps.por_rcv_home_reqs_v
WHERE segment1 = :requisition_number;
Because the view already filters for open, approved, unclosed, receipt-eligible demand, no additional quantity filtering is normally required. A typical analyst query aggregates by vendor or order number to see outstanding receipt workload:
SELECT vendor, order_num, COUNT(*) req_lines
FROM apps.por_rcv_home_reqs_v
GROUP BY vendor, order_num;
Consumers should note that the UNION ALL means a requisition can appear with vendor-populated rows for external PO demand and organization-name rows for inventory demand. Join back to PO_REQUISITION_HEADERS on REQUISITION_HEADER_ID for any header attributes not exposed here.
-
View: POR_RCV_HOME_REQS_V 12.1.1
View to query requisitions in receiving home page
APPS.POR_RCV_HOME_REQS_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ PO_DISTRIBUTIONS_ALL·↳ PO_HEADERS_ALL·Explore ICX module →
-
View: POR_RCV_REQS_ALL_V 12.1.1
APPS.POR_RCV_REQS_ALL_V·↳ OE_ORDER_HEADERS_ALL·↳ PO_DISTRIBUTIONS_ALL·↳ PO_HEADERS_ALL·Explore ICX module →
-
View: POR_RCV_REQS_ALL_V 12.2.2
APPS.POR_RCV_REQS_ALL_V·↳ OE_ORDER_IMPORT_INTEROP_PUB·↳ PO_CLM_INTG_GRP·↳ PO_DISTRIBUTIONS_TRX_V·Explore ICX module →
-
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: POR_RCV_HOME_REQS_V 12.2.2
View to query requisitions in receiving home page
APPS.POR_RCV_HOME_REQS_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ MTL_SYSTEM_ITEMS·↳ PO_CLM_INTG_GRP·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 →
-
10SC ONLY - Retrofitted
APPS.PO_REQS_IN_TRANSIT_ALL_V·↳ FND_GLOBAL·↳ FND_PROFILE·↳ HR_EMPLOYEES·Explore PO module →
-
View: POR_RCV_REQS_ORDER_V 12.2.2
APPS.POR_RCV_REQS_ORDER_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ OE_ORDER_HEADERS·↳ PO_DISTRIBUTIONS·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: PO_REQS_IN_POOL_SEC_V 12.2.2
This view was created for HTML Autocreate. This view retrieves the requisition headers that have one or more lines that are currently in the pool (i.e. eligible for Autocreate), in the operating units specified by the MO: Security Profile p
APPS.PO_REQS_IN_POOL_SEC_V·↳ PO_REQUISITION_HEADERS_CLM_V·↳ PO_REQUISITION_LINES·Explore PO 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 →
-
10SC ONLY - Retrofitted
APPS.PO_REQUISITION_HEADERS_ALL_V·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ PER_ALL_PEOPLE_F·Explore PO 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 →
-
Table: PO_WF_DEBUG 12.2.2
This table is reserved for use by Oracle only
-
This view is obsolete.
APPS.POR_VIEW_REQS_BY_APPROVER_V·↳ AP_CARDS·↳ FINANCIALS_SYSTEM_PARAMETERS·↳ FND_CURRENCY·Explore ICX module →
-
View: POR_RCV_REQS_ORDER_V 12.1.1
APPS.POR_RCV_REQS_ORDER_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ OE_ORDER_HEADERS·↳ PO_DISTRIBUTIONS·Explore ICX module →
-
View: PJM_PROJECT_REQ_V 12.1.1
Project related purchase requisition information for the Web Inquiry.
APPS.PJM_PROJECT_REQ_V·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ FND_CURRENCY_CACHE·↳ FND_GLOBAL·Explore PJM module →
-
Orders That I Approved View
APPS.POR_VIEW_REQS_BY_APPR_V·↳ AP_CARDS·↳ FINANCIALS_SYSTEM_PARAMETERS·↳ FND_GLOBAL·Explore ICX module →
-
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 →
-
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 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 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: 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: PJM_PROJECT_REQ_V 12.2.2
Project related purchase requisition information for the Web Inquiry.
APPS.PJM_PROJECT_REQ_V·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ FND_CURRENCY_CACHE·↳ FND_GLOBAL·Explore PJM 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 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 →
-
10SC ONLY - Retrofitted
APPS.PO_REQS_IN_TRANSIT_ALL_V·↳ FND_GLOBAL·↳ FND_PROFILE·↳ HR_EMPLOYEES·Explore PO module →
-
The View is used to retrieve requisition details in the form 'Document Cross-Reference'
APPS.FV_REQUISITION_MASTER_V·↳ PO_HEADERS_ALL·↳ PO_LINE_LOCATIONS_ALL·↳ PO_REQUISITION_HEADERS·Explore FV module →
-
This view is obsolete.
APPS.POR_VIEW_REQS_BY_APPROVER_V·↳ AP_CARDS·↳ FINANCIALS_SYSTEM_PARAMETERS·↳ FND_CURRENCY·Explore ICX module →
-
View Requisition By Group
APPS.POR_VIEW_REQS_BY_GROUP_V·↳ AP_CARDS·↳ FINANCIALS_SYSTEM_PARAMETERS·↳ FND_CURRENCY·Explore ICX module →
-
View: PO_REQS_IN_POOL_SEC_V 12.1.1
This view was created for HTML Autocreate. This view retrieves the requisition headers that have one or more lines that are currently in the pool (i.e. eligible for Autocreate), in the operating units specified by the MO: Security Profile p
APPS.PO_REQS_IN_POOL_SEC_V·↳ PO_REQUISITION_HEADERS_ALL·↳ PO_REQUISITION_LINES·Explore PO module →
-
10SC ONLY - Retrofitted
APPS.PO_REQUISITION_HEADERS_ALL_V·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ PER_ALL_PEOPLE_F·Explore PO module →
-
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: 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 →
-
The View is used to retrieve requisition details in the form 'Document Cross-Reference'
APPS.FV_REQUISITION_MASTER_V·↳ PO_HEADERS_ALL·↳ PO_LINE_LOCATIONS_ALL·↳ PO_REQUISITION_HEADERS·Explore FV module →
-
Table: PO_WF_DEBUG 12.1.1
This table is reserved for use by Oracle only
-
View: POFV_REQUISITIONS 12.2.2
- Retrofitted
APPS.POFV_REQUISITIONS·↳ AP_CARDS_ALL·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_GENERAL·Explore PO module →
-
View: POBV_REQUISITIONS 12.1.1
- Retrofitted
APPS.POBV_REQUISITIONS·↳ HR_ALL_ORGANIZATION_UNITS·↳ PO_REQUISITION_HEADERS_ALL·Explore PO module →
-
View: POBV_REQUISITIONS 12.2.2
- Retrofitted
APPS.POBV_REQUISITIONS·↳ HR_ALL_ORGANIZATION_UNITS·↳ PO_REQUISITION_HEADERS_ALL·Explore PO module →
-
IA_REQUEST_HEADERS stores information about the requests you create
-
IA_REQUEST_HEADERS stores information about the requests you create
-
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 →
-
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 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 →
-
View: POFV_REQUISITIONS 12.1.1
- Retrofitted
APPS.POFV_REQUISITIONS·↳ AP_CARDS_ALL·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_GENERAL·Explore PO module →