Search Results rcv_transactions
I'll provide a detailed description of the RCV_TRANSACTIONS table in Oracle E-Business Suite (EBS), specifically in the Purchasing/Receiving module:
Table Name: RCV_TRANSACTIONS
Module: Purchasing (PO)
Purpose: Stores detailed information about receiving transactions
Key Columns:
1. TRANSACTION_ID (Primary Key)
- Unique identifier for each receiving transaction
- Sequentially generated
2. ORGANIZATION_ID
- Inventory organization where the receipt occurred
- Links to HR_ORGANIZATION_UNITS
3. INVENTORY_ITEM_ID
- Item being received
- Links to MTL_SYSTEM_ITEMS_B
4. PURCHASE_ORDER_ID
- Related Purchase Order
- Links to PO_HEADERS_ALL
5. PURCHASE_ORDER_LINE_ID
- Specific PO line associated with transaction
- Links to PO_LINES_ALL
6. TRANSACTION_TYPE
- Receipt type (Standard Receipt, Return to Vendor, etc.)
- Stored as coded value
7. QUANTITY
- Quantity received in transactional UOM
8. UNIT_OF_MEASURE
- Unit of measurement for receipt
9. TRANSACTION_DATE
- Date and time of receiving transaction
10. CURRENCY_CODE
- Transaction currency
Important Attributes:
- Tracks detailed receiving history
- Supports multiple receiving scenarios
- Integrated with Inventory and Purchasing modules
Typical Uses:
- Receiving goods
- Tracking inventory receipts
- Reconciling purchase orders
- Generating receiving reports
Recommendation: Always join with related tables for complete transaction details.
-
Table: RCV_TRANSACTIONS
12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_TRANSACTIONS, object_name:RCV_TRANSACTIONS, status:VALID, product: PO - Purchasing , description: Receiving transactions , implementation_dba_data: PO.RCV_TRANSACTIONS ,
-
Table: RCV_TRANSACTIONS
12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_TRANSACTIONS, object_name:RCV_TRANSACTIONS, status:VALID, product: PO - Purchasing , description: Receiving transactions , implementation_dba_data: PO.RCV_TRANSACTIONS ,
-
View: RCV_FTE_TRANSACTIONS_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PO.RCV_FTE_TRANSACTIONS_V, object_name:RCV_FTE_TRANSACTIONS_V, status:VALID, product: PO - Purchasing , description: Rolled up transactions for logistics , implementation_dba_data: APPS.RCV_FTE_TRANSACTIONS_V ,
-
View: RCV_FTE_TRANSACTIONS_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PO.RCV_FTE_TRANSACTIONS_V, object_name:RCV_FTE_TRANSACTIONS_V, status:VALID, product: PO - Purchasing , description: Rolled up transactions for logistics , implementation_dba_data: APPS.RCV_FTE_TRANSACTIONS_V ,
-
Table: RCV_LOT_TRANSACTIONS
12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_LOT_TRANSACTIONS, object_name:RCV_LOT_TRANSACTIONS, status:VALID, product: PO - Purchasing , description: Receiving lots transactions , implementation_dba_data: PO.RCV_LOT_TRANSACTIONS ,
-
Table: RCV_LOT_TRANSACTIONS
12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_LOT_TRANSACTIONS, object_name:RCV_LOT_TRANSACTIONS, status:VALID, product: PO - Purchasing , description: Receiving lots transactions , implementation_dba_data: PO.RCV_LOT_TRANSACTIONS ,
-
Table: RCV_SERIAL_TRANSACTIONS
12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_SERIAL_TRANSACTIONS, object_name:RCV_SERIAL_TRANSACTIONS, status:VALID, product: PO - Purchasing , description: Receiving serial transactions , implementation_dba_data: PO.RCV_SERIAL_TRANSACTIONS ,
-
Table: RCV_SERIAL_TRANSACTIONS
12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_SERIAL_TRANSACTIONS, object_name:RCV_SERIAL_TRANSACTIONS, status:VALID, product: PO - Purchasing , description: Receiving serial transactions , implementation_dba_data: PO.RCV_SERIAL_TRANSACTIONS ,
-
Lookup Type: MRC_UPGRADE
12.2.2
product: PO - Purchasing , meaning: NODESCRIPTION47 ,
-
Lookup Type: MRC_UPGRADE
12.1.1
product: PO - Purchasing , meaning: NODESCRIPTION47 ,
-
View: RCV_MUR_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PO.RCV_MUR_V, object_name:RCV_MUR_V, status:VALID, product: PO - Purchasing , description: 10SC ONLY - Retrofitted , implementation_dba_data: APPS.RCV_MUR_V ,
-
View: RCV_MUR_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PO.RCV_MUR_V, object_name:RCV_MUR_V, status:VALID, product: PO - Purchasing , description: 10SC ONLY - Retrofitted , implementation_dba_data: APPS.RCV_MUR_V ,
-
View: RCV_FTE_HEADERS_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PO.RCV_FTE_HEADERS_V, object_name:RCV_FTE_HEADERS_V, status:VALID, product: PO - Purchasing , description: Header Lines for logistics , implementation_dba_data: APPS.RCV_FTE_HEADERS_V ,
-
View: RCV_FTE_HEADERS_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PO.RCV_FTE_HEADERS_V, object_name:RCV_FTE_HEADERS_V, status:VALID, product: PO - Purchasing , description: Header Lines for logistics , implementation_dba_data: APPS.RCV_FTE_HEADERS_V ,
-
View: RCV_CORRECTIONS_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PO.RCV_CORRECTIONS_V, object_name:RCV_CORRECTIONS_V, status:VALID, product: PO - Purchasing , description: 10SC ONLY - Retrofitted , implementation_dba_data: APPS.RCV_CORRECTIONS_V ,
-
View: RCV_CORRECTIONS_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PO.RCV_CORRECTIONS_V, object_name:RCV_CORRECTIONS_V, status:VALID, product: PO - Purchasing , description: 10SC ONLY - Retrofitted , implementation_dba_data: APPS.RCV_CORRECTIONS_V ,
-
Table: RCV_MC_TRANSACTIONS
12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_MC_TRANSACTIONS, object_name:RCV_MC_TRANSACTIONS, status:VALID, product: PO - Purchasing , description: MRC sub-table of RCV_TRANSACTIONS , implementation_dba_data: PO.RCV_MC_TRANSACTIONS ,
-
Table: RCV_MC_TRANSACTIONS
12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_MC_TRANSACTIONS, object_name:RCV_MC_TRANSACTIONS, status:VALID, product: PO - Purchasing , description: MRC sub-table of RCV_TRANSACTIONS , implementation_dba_data: PO.RCV_MC_TRANSACTIONS ,
-
Table: RCV_SERIALS_SUPPLY
12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_SERIALS_SUPPLY, object_name:RCV_SERIALS_SUPPLY, status:VALID, product: PO - Purchasing , description: Receiving serial supply , implementation_dba_data: PO.RCV_SERIALS_SUPPLY ,
-
Table: PO_ONLINE_REPORT_TEXT
12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_ONLINE_REPORT_TEXT, object_name:PO_ONLINE_REPORT_TEXT, status:VALID, product: PO - Purchasing , description: Online report errors , implementation_dba_data: PO.PO_ONLINE_REPORT_TEXT ,
-
Table: PO_ONLINE_REPORT_TEXT
12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_ONLINE_REPORT_TEXT, object_name:PO_ONLINE_REPORT_TEXT, status:VALID, product: PO - Purchasing , description: Online report errors , implementation_dba_data: PO.PO_ONLINE_REPORT_TEXT ,
-
Table: RCV_SERIALS_SUPPLY
12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_SERIALS_SUPPLY, object_name:RCV_SERIALS_SUPPLY, status:VALID, product: PO - Purchasing , description: Receiving serial supply , implementation_dba_data: PO.RCV_SERIALS_SUPPLY ,
-
View: RCV_RECEIVERS_UNORDERED_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PO.RCV_RECEIVERS_UNORDERED_V, object_name:RCV_RECEIVERS_UNORDERED_V, status:VALID, product: PO - Purchasing , description: 10SC ONLY - Retrofitted , implementation_dba_data: APPS.RCV_RECEIVERS_UNORDERED_V ,
-
View: RCV_RECEIVERS_UNORDERED_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PO.RCV_RECEIVERS_UNORDERED_V, object_name:RCV_RECEIVERS_UNORDERED_V, status:VALID, product: PO - Purchasing , description: 10SC ONLY - Retrofitted , implementation_dba_data: APPS.RCV_RECEIVERS_UNORDERED_V ,
-
Table: RCV_ROUTING_STEPS
12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_ROUTING_STEPS, object_name:RCV_ROUTING_STEPS, status:VALID, product: PO - Purchasing , description: Receiving routing steps , implementation_dba_data: PO.RCV_ROUTING_STEPS ,
-
Table: RCV_ROUTING_STEPS
12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_ROUTING_STEPS, object_name:RCV_ROUTING_STEPS, status:VALID, product: PO - Purchasing , description: Receiving routing steps , implementation_dba_data: PO.RCV_ROUTING_STEPS ,
-
Table: RCV_RECEIVING_SUB_LEDGER
12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_RECEIVING_SUB_LEDGER, object_name:RCV_RECEIVING_SUB_LEDGER, status:VALID, product: PO - Purchasing , description: Receiving subledger , implementation_dba_data: PO.RCV_RECEIVING_SUB_LEDGER ,
-
Table: RCV_RECEIVING_SUB_LEDGER
12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_RECEIVING_SUB_LEDGER, object_name:RCV_RECEIVING_SUB_LEDGER, status:VALID, product: PO - Purchasing , description: Receiving subledger , implementation_dba_data: PO.RCV_RECEIVING_SUB_LEDGER ,
-
Table: RCV_LOTS_SUPPLY
12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_LOTS_SUPPLY, object_name:RCV_LOTS_SUPPLY, status:VALID, product: PO - Purchasing , description: Receiving lots supply , implementation_dba_data: PO.RCV_LOTS_SUPPLY ,
-
Table: RCV_LOTS_SUPPLY
12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_LOTS_SUPPLY, object_name:RCV_LOTS_SUPPLY, status:VALID, product: PO - Purchasing , description: Receiving lots supply , implementation_dba_data: PO.RCV_LOTS_SUPPLY ,
-
View: POA_PURCHASE_SALES_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PO.POA_PURCHASE_SALES_V, object_name:POA_PURCHASE_SALES_V, status:VALID, product: PO - Purchasing , implementation_dba_data: APPS.POA_PURCHASE_SALES_V ,
-
View: RCV_RECEIPTS_ALL_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PO.RCV_RECEIPTS_ALL_V, object_name:RCV_RECEIPTS_ALL_V, status:VALID, product: PO - Purchasing , description: 10SC ONLY - Retrofitted , implementation_dba_data: APPS.RCV_RECEIPTS_ALL_V ,
-
View: RCV_RECEIPTS_ALL_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PO.RCV_RECEIPTS_ALL_V, object_name:RCV_RECEIPTS_ALL_V, status:VALID, product: PO - Purchasing , description: 10SC ONLY - Retrofitted , implementation_dba_data: APPS.RCV_RECEIPTS_ALL_V ,
-
View: POBV_MC_RECEIVING_TRANSACTIONS
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PO.POBV_MC_RECEIVING_TRANSACTIONS, object_name:POBV_MC_RECEIVING_TRANSACTIONS, status:VALID, product: PO - Purchasing , description: - Retrofitted , implementation_dba_data: APPS.POBV_MC_RECEIVING_TRANSACTIONS ,
-
View: POA_PURCHASE_SALES_V
12.2.2
product: PO - Purchasing , implementation_dba_data: Not implemented in this database ,
-
View: POBV_MC_RECEIVING_TRANSACTIONS
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PO.POBV_MC_RECEIVING_TRANSACTIONS, object_name:POBV_MC_RECEIVING_TRANSACTIONS, status:VALID, product: PO - Purchasing , description: - Retrofitted , implementation_dba_data: APPS.POBV_MC_RECEIVING_TRANSACTIONS ,
-
Table: PO_ACCRUAL_WRITE_OFFS_ALL
12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_ACCRUAL_WRITE_OFFS_ALL, object_name:PO_ACCRUAL_WRITE_OFFS_ALL, status:VALID, product: PO - Purchasing , description: Accrual write-offs , implementation_dba_data: PO.PO_ACCRUAL_WRITE_OFFS_ALL ,
-
Table: PO_ACCRUAL_WRITE_OFFS_ALL
12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_ACCRUAL_WRITE_OFFS_ALL, object_name:PO_ACCRUAL_WRITE_OFFS_ALL, status:VALID, product: PO - Purchasing , description: Accrual write-offs , implementation_dba_data: PO.PO_ACCRUAL_WRITE_OFFS_ALL ,
-
Table: RCV_ROUTING_HEADERS
12.2.2
product: PO - Purchasing , description: Receiving routing headers , implementation_dba_data: Not implemented in this database ,
-
Table: RCV_ROUTING_HEADERS
12.1.1
product: PO - Purchasing , description: Receiving routing headers , implementation_dba_data: Not implemented in this database ,
-
Table: PO_ACCRUAL_RECONCILE_TEMP_ALL
12.2.2
product: PO - Purchasing , description: Accrual Reconciliation Report temporary table , implementation_dba_data: Not implemented in this database ,
-
Table: PO_ACCRUAL_RECONCILE_TEMP_ALL
12.1.1
product: PO - Purchasing , description: Accrual Reconciliation Report temporary table , implementation_dba_data: Not implemented in this database ,
-
View: POFV_MC_RECEIVING_TRANSACTIONS
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PO.POFV_MC_RECEIVING_TRANSACTIONS, object_name:POFV_MC_RECEIVING_TRANSACTIONS, status:VALID, product: PO - Purchasing , description: - Retrofitted , implementation_dba_data: APPS.POFV_MC_RECEIVING_TRANSACTIONS ,
-
View: POFV_MC_RECEIVING_TRANSACTIONS
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PO.POFV_MC_RECEIVING_TRANSACTIONS, object_name:POFV_MC_RECEIVING_TRANSACTIONS, status:VALID, product: PO - Purchasing , description: - Retrofitted , implementation_dba_data: APPS.POFV_MC_RECEIVING_TRANSACTIONS ,
-
Table: RCV_SUPPLY
12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_SUPPLY, object_name:RCV_SUPPLY, status:VALID, product: PO - Purchasing , description: Summary information about items in receiving/inspection , implementation_dba_data: PO.RCV_SUPPLY ,
-
Table: RCV_ACCOUNTING_EVENTS
12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_ACCOUNTING_EVENTS, object_name:RCV_ACCOUNTING_EVENTS, status:VALID, product: PO - Purchasing , description: Receiving Accounting Events , implementation_dba_data: PO.RCV_ACCOUNTING_EVENTS ,
-
Table: RCV_SUPPLY
12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_SUPPLY, object_name:RCV_SUPPLY, status:VALID, product: PO - Purchasing , description: Summary information about items in receiving/inspection , implementation_dba_data: PO.RCV_SUPPLY ,
-
Table: RCV_ACCOUNTING_EVENTS
12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_ACCOUNTING_EVENTS, object_name:RCV_ACCOUNTING_EVENTS, status:VALID, product: PO - Purchasing , description: Receiving Accounting Events , implementation_dba_data: PO.RCV_ACCOUNTING_EVENTS ,
-
Table: PO_REQ_DISTRIBUTIONS_ALL
12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_REQ_DISTRIBUTIONS_ALL, object_name:PO_REQ_DISTRIBUTIONS_ALL, status:VALID, product: PO - Purchasing , description: Requisition distributions , implementation_dba_data: PO.PO_REQ_DISTRIBUTIONS_ALL ,
-
Table: PO_REQ_DISTRIBUTIONS_ALL
12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_REQ_DISTRIBUTIONS_ALL, object_name:PO_REQ_DISTRIBUTIONS_ALL, status:VALID, product: PO - Purchasing , description: Requisition distributions , implementation_dba_data: PO.PO_REQ_DISTRIBUTIONS_ALL ,