Results for “req_line_id”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The RCV_ENTER_RECEIPTS_V view is an Oracle E-Business Suite database object owned by the APPS schema and classified under the PO – Purchasing product family. Its documentation describes it as "10SC ONLY – Retrofitted," indicating that it was introduced in a specific legacy or specialized release context and subsequently retrofitted into the standard Receiving (RCV) data model. Functionally, the view presents a consolidated, entry-oriented picture of receipts awaiting or undergoing processing in the Receiving open interface and receipt-entry flows. It exposes purchase order, requisition, shipment, item, and destination attributes in a single flattened structure, allowing receipt clerks, integration programs, and reporting tools to query receipt candidates without joining numerous base tables manually.
In Oracle EBS 12.1.1 and 12.2.2, the view supports the Receiving module's user interface layers and interface processing, providing a denormalized row set that reflects valid receipt sources and destinations. Because it is a view rather than a table, it does not store data; it derives its rows dynamically from its underlying base objects at query time.
Underlying Base Objects
Per the documented ETRM 12.2.2 metadata, RCV_ENTER_RECEIPTS_V references the following base objects:
- RCV_ENTER_RECEIPTS_ASN_V (VIEW) — supplies advanced shipment notice receipt rows.
- RCV_ENTER_RECEIPTS_INT_REQ_V (VIEW) — supplies internal requisition receipt rows.
- RCV_ENTER_RECEIPTS_INVENTORY_V (VIEW) — supplies inventory-sourced receipt rows.
- RCV_ENTER_RECEIPTS_PO_V (VIEW) — supplies purchase order receipt rows.
- RCV_ENTER_RECEIPTS_RMA_V (VIEW) — supplies return material authorization receipt rows.
- HR_GENERAL, HR_SECURITY, OE_SYS_PARAMETERS, and PO_CLM_INTG_GRP (PACKAGEs) — support security, system parameter, and integration logic invoked during view resolution.
The view therefore behaves as a union-style aggregator, channeling multiple receipt source types through a common column projection. This design permits a single query surface to retrieve PO, ASN, inventory, RMA, and internal requisition receipts together.
Key Columns
The projection exposes a wide set of identifying and descriptive columns, including:
- SOURCE_TYPE_CODE / RECEIPT_SOURCE_CODE / ORDER_TYPE_CODE — classify the origin of the receipt.
- PO_HEADER_ID, PO_LINE_ID, PO_LINE_LOCATION_ID, PO_RELEASE_ID — purchase order lineage keys.
- REQ_HEADER_ID, REQ_LINE_ID, REQ_DISTRIBUTION_ID — requisition lineage keys.
- RCV_SHIPMENT_HEADER_ID, RCV_SHIPMENT_LINE_ID — receiving shipment identity.
- ITEM_ID, ITEM_NUMBER, ITEM_REVISION, PRIMARY_UOM — item identification and unit of measure.
- VENDOR_ID, VENDOR_SITE_ID, VENDOR_ITEM_NUMBER — supplier details.
- DESTINATION_TYPE_CODE — the searched column, indicating the destination classification for the receipt.
- DELIVER_TO_PERSON_ID, DELIVER_TO_LOCATION_ID, DESTINATION_SUBINVENTORY — delivery target details.
- ORDERED_QTY, UNIT_PRICE, CURRENCY_CODE — quantity and pricing.
- INSPECTION_REQUIRED_FLAG, RECEIPT_REQUIRED_FLAG, ENFORCE_SHIP_TO_LOCATION_CODE — control flags.
- ATTRIBUTE1 through ATTRIBUTE15 — descriptive flexfield columns.
- NEED_BY_DATE, EXPECTED_RECEIPT_DATE, SHIPPED_DATE — scheduling dates.
The DESTINATION_TYPE_CODE column is particularly relevant for determining whether a receipt is destined to inventory, to an expense destination, or to another consuming location.
Common Use Cases and Queries
Typical applications include receipt-entry validation, interface loading, and destination-driven reporting. A representative query filtering by destination type is:
SELECT po_number, item_number, ordered_qty, destination_type_code, destination_subinventory FROM apps.rcv_enter_receipts_v WHERE destination_type_code = 'INVENTORY';- Querying receipts by source:
SELECT receipt_source_code, po_number, vendor_id FROM apps.rcv_enter_receipts_v WHERE receipt_source_code = 'VENDOR'; - Reporting pending inspections:
SELECT po_number, item_number, inspection_required_flag FROM apps.rcv_enter_receipts_v WHERE inspection_required_flag = 'Y';
Because the view is not a base table, it should not be used for direct DML; it serves read-only reporting, interface extraction, and UI support within the Purchasing and Receiving modules.
-
View: RCV_ENTER_RECEIPTS_V 12.2.2
10SC ONLY - Retrofitted
APPS.RCV_ENTER_RECEIPTS_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ OE_SYS_PARAMETERS·Explore PO module →
-
APPS.POR_RCV_PURCHASE_ITEMS_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ MTL_UNITS_OF_MEASURE·↳ PO_DISTRIBUTIONS·Explore ICX module →
-
Summary information about items in receiving/inspection
-
APPS.POR_RCV_INTERNAL_ITEMS_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ MTL_UNITS_OF_MEASURE·↳ OE_ORDER_HEADERS_ALL·Explore ICX module →
-
10SC ONLY - Retrofitted
APPS.RCV_ENTER_RECEIPTS_RMA_V·↳ OE_PO_ENTER_RECEIPTS_V·↳ OE_SYS_PARAMETERS·Explore PO module →
-
View: POR_RCV_SHIPMENTS_V 12.1.1
APPS.POR_RCV_SHIPMENTS_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ MTL_UNITS_OF_MEASURE·↳ OE_ORDER_HEADERS_ALL·Explore ICX module →
-
Stores incoming supply information
-
This enitty is the child table for CSD_REPAIRS and holds all the product (Inbound / Outbound) transactions for a Repair Order.
-
View: PO_REQ_SUPPLY_VIEW 12.1.1
Requisition supply
APPS.PO_REQ_SUPPLY_VIEW·↳ MTL_SUPPLY·↳ MTL_UNITS_OF_MEASURE·↳ PO_REQUISITION_HEADERS_ALL·Explore PO module →
-
10SC ONLY - Retrofitted
APPS.RCV_ENTER_RECEIPTS_SUPPLIER_V·↳ PO_CLM_INTG_GRP·↳ RCV_ENTER_RECEIPTS_ASN_V·↳ RCV_ENTER_RECEIPTS_PO_V·Explore PO module →
-
A supplementary view used to simplify UI coding (Cloned from RCV_ENTER_RECEIPTS_PO_V).
APPS.INL_ENTER_RECEIPTS_PO_V·↳ GL_DAILY_CONVERSION_TYPES·↳ HR_LOCATIONS_ALL_TL·↳ MTL_SYSTEM_ITEMS·Explore INL module →
-
View: POR_RECEIVE_ORDERS_V 12.1.1
Items available for receiving
APPS.POR_RECEIVE_ORDERS_V·↳ FND_GLOBAL·↳ FND_PROFILE·↳ HR_EMPLOYEES_CURRENT_V·Explore ICX module →
-
View: INL_IR_SOURCE_LINES_V 12.1.1
This view shows expected receipts from Internal Requisition.
APPS.INL_IR_SOURCE_LINES_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ INL_ENTER_RECEIPTS_V·Explore INL module →
-
10SC ONLY - Retrofitted
APPS.RCV_ENTER_RECEIPTS_INTERNAL_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ RCV_ENTER_RECEIPTS_INT_REQ_V·Explore PO module →
-
10SC ONLY - Retrofitted
APPS.RCV_ENTER_RECEIPTS_INTERNAL_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ RCV_ENTER_RECEIPTS_INT_REQ_V·Explore PO module →
-
View: INL_ENTER_RECEIPTS_V 12.1.1
A supplementary view used to simplify UI coding (Cloned from RCV_ENTER_RECEIPTS_V).
APPS.INL_ENTER_RECEIPTS_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ INL_ENTER_RECEIPTS_PO_V·Explore INL module →
-
View: PO_REQ_SUPPLY_VIEW 12.2.2
Requisition supply
APPS.PO_REQ_SUPPLY_VIEW·↳ AP_SUPPLIERS·↳ AP_SUPPLIER_SITES_ALL·↳ MTL_SUPPLY·Explore PO module →
-
APPS.POR_RCV_ORD_REQUESTER_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_GENERAL·↳ HR_PERSON_NAME·Explore ICX module →
-
Stores incoming supply information
-
10SC ONLY - Retrofitted
APPS.RCV_ENTER_RECEIPTS_RMA_V·↳ OE_PO_ENTER_RECEIPTS_V·↳ OE_SYS_PARAMETERS·Explore PO module →
-
This view is used for generating XML at requisition distribution level
APPS.ITG_REQ_DISTRIBUTIONS_V·↳ GL_CODE_COMBINATIONS·↳ ITG_X_UTILS·↳ MTL_SYSTEM_ITEMS·Explore ITG module →
-
Summary information about items in receiving/inspection
-
View: POR_RCV_REQ_ITEMS_V 12.2.2
APPS.POR_RCV_REQ_ITEMS_V·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ MTL_SYSTEM_ITEMS·Explore ICX module →
-
APPS.POR_RCV_PURCHASE_ITEMS_V·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ MTL_SYSTEM_ITEMS·Explore ICX module →
-
APPS.POR_RCV_INTERNAL_ITEMS_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_GENERAL·↳ HR_SECURITY·Explore ICX module →
-
View: RCV_CONFIRM_RECEIPT_V 12.1.1
- Retrofitted
APPS.RCV_CONFIRM_RECEIPT_V·↳ FND_GLOBAL·↳ HR_GENERAL·↳ HR_LOCATIONS·Explore PO module →
-
View: CSD_PRODUCT_TXNS_IRO_V 12.2.2
APPS.CSD_PRODUCT_TXNS_IRO_V·↳ CSD_PARTY_SITES_V·↳ CSD_PRODUCT_TRANSACTIONS·↳ CSD_REPAIRS·Explore CSD module →
-
10SC ONLY - Retrofitted
APPS.RCV_ENTER_RECEIPTS_ASN_V·↳ GL_DAILY_CONVERSION_TYPES·↳ HR_LOCATIONS_ALL_TL·↳ MTL_SYSTEM_ITEMS·Explore PO module →
-
APPS.POR_CONFIRM_INTERNAL_RECEIPT_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ MTL_UNITS_OF_MEASURE·↳ OE_ORDER_HEADERS·Explore ICX module →
-
View for querying items to be returned to the supplier (vendor)
APPS.POR_RCV_RETURN_TO_VENDOR_V·↳ FND_GLOBAL·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL·Explore ICX module →
-
Obsolete
APPS.ICX_RCV_ACCEPTED_ITEMS_V·↳ FINANCIALS_SYSTEM_PARAMETERS·↳ FND_GLOBAL·↳ FND_PROFILE·Explore ICX module →
-
APPS.POS_RCV_REJECTED_ITEMS_V·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ FND_GLOBAL·↳ HR_GENERAL·Explore PO module →
-
View: OE_PO_ENTER_RECEIPTS_V 12.1.1
For enter receipts to invoice.
APPS.OE_PO_ENTER_RECEIPTS_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·↳ MTL_CUSTOMER_ITEMS·Explore ONT module →
-
This enitty is the child table for CSD_REPAIRS and holds all the product (Inbound / Outbound) transactions for a Repair Order.
-
View: RCV_VRC_TXS_INT_V 12.1.1
10SC ONLY - Retrofitted
APPS.RCV_VRC_TXS_INT_V·↳ FND_TERRITORIES_TL·↳ GL_DAILY_CONVERSION_TYPES·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore PO module →
-
View: ITG_REQ_LINES_V 12.2.2
This view is used to generate the XML at the requisition lines level
APPS.ITG_REQ_LINES_V·↳ GL_SETS_OF_BOOKS·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_GENERAL·Explore ITG module →
-
View: ITG_REQ_LINES_V 12.1.1
This view is used to generate the XML at the requisition lines level
APPS.ITG_REQ_LINES_V·↳ GL_SETS_OF_BOOKS·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_GENERAL·Explore ITG module →
-
APPS.PA_XLA_BC_PKT_REQ_DETAIL_V·↳ GL_LEDGERS·↳ PA_BC_PACKETS·↳ PA_FUNDS_CONTROL_UTILS·Explore PA module →
-
APPS.PA_XLA_BC_PKT_REQ_DETAIL_V·↳ GL_LEDGERS·↳ PA_BC_PACKETS·↳ PA_FUNDS_CONTROL_UTILS·Explore PA module →
-
View: RCV_ENTER_RECEIPTS_V 12.1.1
10SC ONLY - Retrofitted
APPS.RCV_ENTER_RECEIPTS_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ OE_SYS_PARAMETERS·Explore PO module →
-
10SC ONLY - Retrofitted
APPS.RCV_ENTER_RECEIPTS_SUP_INT_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ RCV_ENTER_RECEIPTS_ASN_V·Explore PO module →
-
10SC ONLY - Retrofitted
APPS.RCV_ENTER_RECEIPTS_SUP_INT_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ PO_CLM_INTG_GRP·Explore PO module →
-
View: INL_RMA_SOURCE_LINES_V 12.1.1
This view shows expected receipts from Return Material Authorizations.
APPS.INL_RMA_SOURCE_LINES_V·↳ ARPT_SQL_FUNC_UTIL·↳ HR_GENERAL·↳ HR_SECURITY·Explore INL module →
-
View: INL_IR_SOURCE_LINES_V 12.2.2
This view shows expected receipts from Internal Requisition.
APPS.INL_IR_SOURCE_LINES_V·↳ INL_ENTER_RECEIPTS_V·Explore INL module →
-
APPS.POS_RCV_REJECTED_ITEMS_V·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL·Explore PO module →
-
Obsolete
APPS.ICX_RCV_ACCEPTED_ITEMS_V·↳ FINANCIALS_SYSTEM_PARAMETERS·↳ FND_PROFILE·↳ HR_EMPLOYEES·Explore ICX module →
-
View: RCV_VRC_TXS_V 12.1.1
10SC ONLY - Retrofitted
APPS.RCV_VRC_TXS_V·↳ FND_CURRENCIES_VL·↳ FND_TERRITORIES_TL·↳ GL_DAILY_CONVERSION_TYPES·Explore PO module →
-
View: INL_PO_SOURCE_LINES_V 12.2.2
This view shows expected receipts from Purchase Orders.
APPS.INL_PO_SOURCE_LINES_V·↳ FND_GLOBAL·↳ INL_ENTER_RECEIPTS_V·↳ PO_VENDORS·Explore INL module →
-
10SC ONLY - Retrofitted
APPS.RCV_ENTER_RECEIPTS_SUPPLIER_V·↳ RCV_ENTER_RECEIPTS_ASN_V·↳ RCV_ENTER_RECEIPTS_PO_V·Explore PO module →
-
View: RCV_VRC_TXS_V 12.2.2
10SC ONLY - Retrofitted
APPS.RCV_VRC_TXS_V·↳ FND_CURRENCIES_VL·↳ FND_GLOBAL·↳ FND_TERRITORIES_TL·Explore PO module →