Results for “note_to_receiver”
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 →
-
10SC ONLY - Retrofitted
APPS.RCV_ENTER_RECEIPTS_RMA_V·↳ OE_PO_ENTER_RECEIPTS_V·↳ OE_SYS_PARAMETERS·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: RCV_RECEIPTS_PRINT_INV 12.2.2
Print view of receipts
APPS.RCV_RECEIPTS_PRINT_INV·↳ FND_GLOBAL·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL_TL·Explore PO module →
-
View: RCV_RECEIPTS_PRINT_REQ 12.2.2
Print view of receipts
APPS.RCV_RECEIPTS_PRINT_REQ·↳ FND_GLOBAL·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL_TL·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: 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: RCV_RETURNS_V 12.2.2
- Retrofitted
APPS.RCV_RETURNS_V·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ HR_LOCATIONS_ALL_TL·↳ MTL_SYSTEM_ITEMS·Explore PO module →
-
10SC ONLY - Retrofitted
APPS.RCV_ENTER_RECEIPTS_RMA_V·↳ OE_PO_ENTER_RECEIPTS_V·↳ OE_SYS_PARAMETERS·Explore PO module →
-
View: PO_HEADERS_TRX_V 12.2.2
View on po_headers table.
-
10SC ONLY - Retrofitted
APPS.RCV_ENTER_RECEIPTS_SUP_INT_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ RCV_ENTER_RECEIPTS_ASN_V·Explore PO 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·↳ PO_CLM_INTG_GRP·Explore PO module →
-
View: PO_ECX_HEADER_V 12.1.1
APPS.PO_ECX_HEADER_V·↳ AP_TERMS·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ FND_GLOBAL·Explore PO module →
-
10SC ONLY - Retrofitted
APPS.RCV_ENTER_RECEIPTS_SUPPLIER_V·↳ RCV_ENTER_RECEIPTS_ASN_V·↳ RCV_ENTER_RECEIPTS_PO_V·Explore PO module →
-
Open Requisition Lines View
APPS.ICX_PO_REQUISITION_OPEN_V·↳ FND_CURRENCY·↳ FND_GLOBAL·↳ GL_DAILY_CONVERSION_TYPES·Explore ICX 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 →
-
Archived Purchase Orders Header View
APPS.ICX_PO_HEADERS_ARCHIVE_V·↳ AP_TERMS·↳ FND_CURRENCY·↳ FND_GLOBAL·Explore ICX module →
-
View: PO_HEADER_RELEASE_V 12.2.2
10SC ONLY
APPS.PO_HEADER_RELEASE_V·↳ FND_GLOBAL·↳ FND_PROFILE·↳ HR_GENERAL·Explore PO module →
-
View: PO_HEADER_RELEASE_V 12.1.1
10SC ONLY
APPS.PO_HEADER_RELEASE_V·↳ FND_GLOBAL·↳ HR_GENERAL·↳ HR_PERSON_NAME·Explore PO module →
-
APPS.POS_PO_HEADERS_ARCHIVE_V·↳ AP_TERMS·↳ FND_CURRENCY·↳ FND_GLOBAL·Explore PO module →
-
Obsolete
APPS.ICX_PO_HDR_ARCHIVE_OPEN_V·↳ AP_TERMS·↳ FND_CURRENCY·↳ FND_GLOBAL·Explore ICX module →
-
Supplier Orders View
APPS.ICX_PO_SUPPLIER_ORDERS_V·↳ AP_TERMS·↳ FND_CURRENCY·↳ FND_GLOBAL·Explore ICX module →
-
View: RCV_RECEIPTS_PRINT_RMA 12.2.2
Print view of receipts
APPS.RCV_RECEIPTS_PRINT_RMA·↳ FND_GLOBAL·↳ HR_LOCATIONS_ALL_TL·↳ HZ_CUST_ACCOUNTS·Explore PO module →
-
View: RCV_RECEIPTS_PRINT_REQ 12.1.1
Print view of receipts
APPS.RCV_RECEIPTS_PRINT_REQ·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ FND_GLOBAL·↳ HR_GENERAL·Explore PO module →
-
View: POR_LINES_ALL_V 12.1.1
Requisition Line View
APPS.POR_LINES_ALL_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HR_GENERAL·Explore ICX module →
-
View: POR_LINES_ALL_V 12.2.2
Requisition Line View
APPS.POR_LINES_ALL_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HR_GENERAL·Explore ICX module →
-
10SC ONLY - Retrofitted
APPS.RCV_ENTER_RECEIPTS_ASN_V·↳ GL_DAILY_CONVERSION_TYPES·↳ HR_LOCATIONS_ALL_TL·↳ MTL_SYSTEM_ITEMS·Explore PO module →
-
View: PO_LINE_LOCATIONS_V 12.1.1
- Retrofitted
APPS.PO_LINE_LOCATIONS_V·↳ AP_TERMS·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ FND_GLOBAL·Explore PO 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: RCV_VRC_TXS_CUST_V 12.2.2
10SC ONLY - Retrofitted
APPS.RCV_VRC_TXS_CUST_V·↳ FND_TERRITORIES_TL·↳ GL_DAILY_CONVERSION_TYPES·↳ 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 →
-
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 →
-
View: PO_HEADERS_V 12.2.2
10SC ONLY
APPS.PO_HEADERS_V·↳ AP_TERMS·↳ FND_GLOBAL·↳ GL_DAILY_CONVERSION_TYPES·Explore PO module →
-
View: INL_RMA_SOURCE_LINES_V 12.2.2
This view shows expected receipts from Return Material Authorizations.
APPS.INL_RMA_SOURCE_LINES_V·↳ ARPT_SQL_FUNC_UTIL·↳ HZ_CUSTOMER_PARTY_FIND_V·↳ INL_ENTER_RECEIPTS_V·Explore INL module →
-
View: RCV_TRANSACTIONS_V 12.1.1
- Retrofitted
APPS.RCV_TRANSACTIONS_V·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ FND_GLOBAL·↳ GL_DAILY_CONVERSION_TYPES·Explore PO module →
-
View: RCV_VRC_TXS_VENDINT_V 12.2.2
10SC ONLY - Retrofitted
APPS.RCV_VRC_TXS_VENDINT_V·↳ FND_CURRENCIES_VL·↳ FND_GLOBAL·↳ FND_TERRITORIES_TL·Explore PO module →
-
View: ITG_PO_HEADER_ARCH_V 12.1.1
Used for XML mapping in the header level
APPS.ITG_PO_HEADER_ARCH_V·↳ AP_CARDS_ALL·↳ AP_TERMS·↳ FINANCIALS_SYSTEM_PARAMS_ALL·Explore ITG module →
-
View: RCV_CORRECTIONS_V 12.1.1
10SC ONLY - Retrofitted
APPS.RCV_CORRECTIONS_V·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ GL_DAILY_CONVERSION_TYPES·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore PO module →
-
View: RCV_VRC_TXS_VENDINT_V 12.1.1
10SC ONLY - Retrofitted
APPS.RCV_VRC_TXS_VENDINT_V·↳ FND_CURRENCIES_VL·↳ FND_TERRITORIES_TL·↳ GL_DAILY_CONVERSION_TYPES·Explore PO module →
-
View: RCV_VIEW_INTERFACE_V 12.2.2
- Retrofitted
APPS.RCV_VIEW_INTERFACE_V·↳ FND_CURRENCIES_VL·↳ FND_GLOBAL·↳ HR_GENERAL·Explore PO module →
-
View: PO_LINES_INQ_V 12.2.2
- Retrofitted
APPS.PO_LINES_INQ_V·↳ AP_TERMS·↳ FND_GLOBAL·↳ GL_DAILY_CONVERSION_TYPES·Explore PO module →
-
- Retrofitted
APPS.PO_REQUISITION_LINES_INQ_V·↳ BOM_RESOURCES·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ GL_DAILY_CONVERSION_TYPES·Explore PO 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 →
-
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 →
-
Security view for owned requisition lines
APPS.PO_OWNED_REQUISITION_LINES·↳ PO_REQUISITION_HEADERS_ALL·↳ PO_REQUISITION_LINES·Explore PO module →
-
View: RCV_RECEIPTS_PRINT_INV 12.1.1
Print view of receipts
APPS.RCV_RECEIPTS_PRINT_INV·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ FND_GLOBAL·↳ HR_GENERAL·Explore PO module →
-
APPS.PO_LINE_LOCATIONS_ARCHIVE_XML·↳ MTL_UNITS_OF_MEASURE_TL·↳ PO_COMMUNICATION_GT·↳ PO_COMMUNICATION_PVT·Explore PO module →