Results for “country_of_origin_code”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
RCV_FTE_TRANSACTIONS_V is a seeded Oracle E-Business Suite view owned by the APPS schema and classified under the PO – Purchasing product family. Its documented purpose is to provide rolled up transactions for logistics, meaning it consolidates receiving activity into a form suitable for downstream logistics, transportation, and warehouse-facing reporting. The view is a union of two query branches: the first returns base receipt and match transactions, while the second resolves return-to-vendor activity back to its originating receipt so that logistics consumers see a normalized, parent-linked transaction stream.
Rather than exposing raw RCV_TRANSACTIONS rows verbatim, the view normalizes several attributes. For example, the TRANSACTION_TYPE column applies a DECODE that reclassifies 'MATCH' rows as 'RECEIPT', aligning matched transactions with the physical receipt event they correspond to. The first branch emits NULL values for parent columns, whereas the second branch populates PARENT_TRANSACTION_ID and PARENT_TRANSACTION_TYPE from the associated receipt. This makes the view an integration-friendly surface for systems that expect a single, hierarchically consistent view of receiving data.
Underlying Base Objects
Per the documented ETRM 12.2.2 metadata, RCV_FTE_TRANSACTIONS_V is defined over two referenced base objects:
- RCV_TRANSACTIONS (SYNONYM) – the core receiving transactions table supplying transaction identifiers, dates, quantities, UOMs, locators, subinventories, and audit columns.
- MTL_UNITS_OF_MEASURE (SYNONYM) – the units-of-measure lookup used to translate the numeric UOM identifiers on
RCV_TRANSACTIONSinto human-readableUOM_CODEvalues.
The view references MTL_UNITS_OF_MEASURE three times via aliases — MUOM, PRIMARY_MUOM, and SECONDARY_MUOM — each joined with an outer join ((+)) on the corresponding UOM column of RCV_TRANSACTIONS. The RCV_TRANSACTIONS synonym is also self-joined in the second union branch to link return-to-vendor rows to their parent receipt.
Key Columns
The view exposes the full set of logistics-relevant receiving attributes, including:
TRANSACTION_ID– the unique key of the receiving transaction; also used asROOT_TRANSACTION/PARENT_TRANSACTION_IDlinkage.TRANSACTION_TYPE– normalized as'RECEIPT'for both'RECEIVE'and'MATCH'rows; other types pass through unchanged.TRANSACTION_DATE,SHIPMENT_LINE_ID,PO_UNIT_PRICE,CURRENCY_CODE– commercial and timing context of the receipt.QUANTITY,PRIMARY_QUANTITY,SECONDARY_QUANTITY– transactional quantities at each UOM level.UOM_CODE,PRIMARY_UOM_CODE, andSECONDARY_UOM_CODE– resolved UOM codes. TheSECONDARY_UOM_CODEcolumn, mapped fromRT.SECONDARY_UNIT_OF_MEASUREthrough theSECONDARY_MUOMalias, is the value commonly searched for when reconciling dual-UOM (primary/secondary) receipt capture in a logistics interface.QC_GRADE,COUNTRY_OF_ORIGIN_CODE,LPN_ID,LOCATOR_ID,SUBINVENTORY– receiving quality and physical placement attributes.- Audit columns:
LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN.
Common Use Cases and Queries
Typical uses include logistics dashboards, inbound shipment reconciliation, and dual-UOM audits. A common pattern is to isolate transactions where secondary UOM information is populated:
- Secondary UOM reporting – retrieve receipt lines with a resolved secondary UOM code.
- Parent/child audit – identify return-to-vendor transactions and their originating receipts via
PARENT_TRANSACTION_ID. - Shipment-line rollup – aggregate receipts by
SHIPMENT_LINE_IDand currency for logistics tracking.
Sample query:
SELECT TRANSACTION_ID, TRANSACTION_TYPE, TRANSACTION_DATE, SHIPMENT_LINE_ID, QUANTITY, UOM_CODE, PRIMARY_QUANTITY, PRIMARY_UOM_CODE, SECONDARY_QUANTITY, SECONDARY_UOM_CODE
FROM APPS.RCV_FTE_TRANSACTIONS_V
WHERE SECONDARY_UOM_CODE IS NOT NULL
AND TRANSACTION_DATE >= SYSDATE - 30;
Because the view is a union with outer-joined UOM lookups, queries should account for NULL UOM codes when a given UOM identifier is not present in MTL_UNITS_OF_MEASURE. The view is read-only and should be treated as a reporting surface rather than an update target.
-
View: RCV_FTE_TRANSACTIONS_V 12.1.1
Rolled up transactions for logistics
APPS.RCV_FTE_TRANSACTIONS_V·↳ MTL_UNITS_OF_MEASURE·↳ RCV_TRANSACTIONS·Explore PO module →
-
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 →
-
- Retrofitted
APPS.POBV_APPROVED_SUPPLIER_LISTS·↳ PO_APPROVED_SUPPLIER_LIST·↳ PO_ASL_ATTRIBUTES·↳ PO_ASL_STATUSES·Explore PO module →
-
View: RCV_FTE_TRANSACTIONS_V 12.2.2
Rolled up transactions for logistics
APPS.RCV_FTE_TRANSACTIONS_V·↳ MTL_UNITS_OF_MEASURE·↳ RCV_TRANSACTIONS·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 →
-
View: PO_VENDOR_SITES 12.2.2
10SC ONLY - Retrofitted
APPS.PO_VENDOR_SITES·↳ AP_LOOKUP_CODES·↳ AP_SUPPLIER_SITES·↳ FND_GLOBAL·Explore PO module →
-
View: POS_ORD_MODIFIERS_V 12.2.2
APPS.POS_ORD_MODIFIERS_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ MTL_PLANNERS·↳ MTL_SYSTEM_ITEMS_KFV·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 →
-
10SC ONLY - Retrofitted
APPS.RCV_ENTER_RECEIPTS_INTERNAL_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ RCV_ENTER_RECEIPTS_INT_REQ_V·Explore PO module →
-
View: PO_ASL_ATTRIBUTES_V 12.1.1
- Retrofitted
APPS.PO_ASL_ATTRIBUTES_V·↳ CHV_BUCKET_PATTERNS·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore PO module →
-
10SC ONLY - Retrofitted
APPS.RCV_ENTER_RECEIPTS_RMA_V·↳ OE_PO_ENTER_RECEIPTS_V·↳ OE_SYS_PARAMETERS·Explore PO module →
-
View: RCV_TRANSACTIONS_MRC_V 12.1.1
- Retrofitted
APPS.RCV_TRANSACTIONS_MRC_V·↳ RCV_MC_TRANSACTIONS·↳ RCV_TRANSACTIONS·Explore PO module →
-
View: POBV_SUPPLIER_SITES 12.2.2
- Retrofitted
APPS.POBV_SUPPLIER_SITES·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS·↳ PO_VENDORS·Explore PO module →
-
- Retrofitted
APPS.POBV_APPROVED_SUPPLIER_LISTS·↳ PO_APPROVED_SUPPLIER_LIST·↳ PO_ASL_ATTRIBUTES·↳ PO_ASL_STATUSES·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 →
-
Approved supplier list attributes
-
APPS.PO_ASL_ATTRIBUTES_VAL_V·↳ PO_APPROVED_SUPPLIER_LIST·↳ PO_ASL_ATTRIBUTES·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 →
-
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_VENDOR_SITES 12.1.1
10SC ONLY - Retrofitted
APPS.PO_VENDOR_SITES·↳ AP_SUPPLIER_SITES·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 →
-
10SC ONLY - Retrofitted
APPS.RCV_ENTER_RECEIPTS_ASN_V·↳ GL_DAILY_CONVERSION_TYPES·↳ HR_LOCATIONS_ALL_TL·↳ MTL_SYSTEM_ITEMS·Explore PO module →
-
View: RCV_MUR_V 12.1.1
10SC ONLY - Retrofitted
APPS.RCV_MUR_V·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL_TL·↳ HR_SECURITY·Explore PO module →
-
View: POS_LINES_V 12.1.1
APPS.POS_LINES_V·↳ FND_TERRITORIES_VL·↳ HR_LOCATIONS_ALL_TL·↳ HZ_LOCATIONS·Explore PO module →
-
- Retrofitted
APPS.POFV_APPROVED_SUPPLIER_LISTS·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_GENERAL·↳ HR_PERSON_NAME·Explore PO module →
-
For Internal Use Only: This table is global temporary table based on po_line_locations_all table. It is used for internal processing of data for PO Approval Submission Checks.
-
10SC ONLY - Retrofitted
APPS.RCV_ENTER_RECEIPTS_INVENTORY_V·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL_TL·↳ HR_SECURITY·Explore PO module →
-
10SC ONLY - Retrofitted
APPS.RCV_ENTER_RECEIPTS_INT_REQ_V·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL_TL·↳ HR_SECURITY·Explore PO module →
-
10SC ONLY - Retrofitted
APPS.RCV_ENTER_RECEIPTS_INT_REQ_V·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL_TL·↳ HR_SECURITY·Explore PO module →
-
APPS.PO_LINE_LOCATIONS_ARCHIVE_XML·↳ MTL_UNITS_OF_MEASURE_TL·↳ PO_COMMUNICATION_GT·↳ PO_COMMUNICATION_PVT·Explore PO module →
-
View: POBV_SUPPLIER_SITES 12.1.1
- Retrofitted
APPS.POBV_SUPPLIER_SITES·↳ HR_ALL_ORGANIZATION_UNITS·↳ PO_VENDORS·↳ PO_VENDOR_SITES_ALL·Explore PO module →
-
View: POS_ORD_MODIFIERS_V 12.1.1
APPS.POS_ORD_MODIFIERS_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ MTL_PLANNERS·↳ MTL_SYSTEM_ITEMS_KFV·Explore PO module →
-
- Retrofitted
APPS.PO_APPROVED_SUPPLIER_LIST_V·↳ CHV_BUCKET_PATTERNS·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore PO module →
-
View: RCV_TRANSACTIONS_MRC_V 12.2.2
- Retrofitted
APPS.RCV_TRANSACTIONS_MRC_V·↳ RCV_MC_TRANSACTIONS·↳ RCV_TRANSACTIONS·Explore PO module →
-
View on po_line_locations table.
APPS.PO_LINE_LOCATIONS_TRX_V·↳ PO_CLM_INTG_GRP·↳ PO_DISTRIBUTIONS_ALL·↳ PO_LINES_TRX_V·Explore PO module →
-
- Retrofitted
APPS.POFV_APPROVED_SUPPLIER_LISTS·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_GENERAL·Explore PO module →
-
View: PO_LINE_LOCATIONS_V 12.2.2
- Retrofitted
APPS.PO_LINE_LOCATIONS_V·↳ AP_TERMS·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ FND_GLOBAL·Explore PO module →
-
Approved supplier list attributes
-
For Internal Use Only: This table is global temporary table based on po_line_locations_all table. It is used for internal processing of data for PO Approval Submission Checks.
-
View: RCV_MUR_V 12.2.2
10SC ONLY - Retrofitted
APPS.RCV_MUR_V·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL_TL·↳ HR_SECURITY·Explore PO module →
-
APPS.PO_ASL_ATTRIBUTES_VAL_V·↳ PO_APPROVED_SUPPLIER_LIST·↳ PO_ASL_ATTRIBUTES·Explore PO module →
-
APPS.PO_LINE_LOCATIONS_ARCHIVE_XML·↳ MTL_UNITS_OF_MEASURE_TL·↳ PO_COMMUNICATION_GT·↳ PO_COMMUNICATION_PVT·Explore PO module →
-
View: PO_ASL_ATTRIBUTES_V 12.2.2
- Retrofitted
APPS.PO_ASL_ATTRIBUTES_V·↳ CHV_BUCKET_PATTERNS·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore PO module →
-
10SC ONLY - Retrofitted
APPS.PO_LINE_LOCATIONS_RELEASE_V·↳ AP_TERMS·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ FND_GLOBAL·Explore PO 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: POFV_SUPPLIER_SITES 12.1.1
APPS.POFV_SUPPLIER_SITES·↳ AP_TERMS·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ FND_CURRENCIES_VL·Explore PO module →
-
View: POFV_SUPPLIER_SITES 12.2.2
APPS.POFV_SUPPLIER_SITES·↳ AP_TERMS·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ FND_CURRENCIES_VL·Explore PO module →
-
Receiving shipment line information