eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: RCV_TRANSACTIONS

Product:	PO - Purchasing
Description:	Receiving transactions
Implementation/DBA Data:	PO.RCV_TRANSACTIONS

Primary Key: RCV_TRANSACTIONS_PK

TRANSACTION_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
RCV_TRANSACTIONS	PO_LINES_ALL	RCV_TRANSACTIONS.PO_LINE_ID
RCV_TRANSACTIONS	PO_LINE_LOCATIONS_ALL	RCV_TRANSACTIONS.PO_LINE_LOCATION_ID
RCV_TRANSACTIONS	PO_RELEASES_ALL	RCV_TRANSACTIONS.PO_RELEASE_ID
RCV_TRANSACTIONS	PO_DISTRIBUTIONS_ALL	RCV_TRANSACTIONS.PO_DISTRIBUTION_ID
RCV_TRANSACTIONS	PO_REQUISITION_LINES_ALL	RCV_TRANSACTIONS.REQUISITION_LINE_ID
RCV_TRANSACTIONS	PO_REQ_DISTRIBUTIONS_ALL	RCV_TRANSACTIONS.REQ_DISTRIBUTION_ID
RCV_TRANSACTIONS	RCV_ROUTING_HEADERS	RCV_TRANSACTIONS.ROUTING_HEADER_ID
RCV_TRANSACTIONS	RCV_ROUTING_STEPS	RCV_TRANSACTIONS.ROUTING_STEP_ID
RCV_TRANSACTIONS	RCV_SHIPMENT_HEADERS	RCV_TRANSACTIONS.SHIPMENT_HEADER_ID
RCV_TRANSACTIONS	PO_VENDORS	RCV_TRANSACTIONS.VENDOR_ID
RCV_TRANSACTIONS	PO_VENDOR_SITES_ALL	RCV_TRANSACTIONS.VENDOR_SITE_ID
RCV_TRANSACTIONS	MTL_SECONDARY_INVENTORIES	RCV_TRANSACTIONS.SUBINVENTORY RCV_TRANSACTIONS.ORGANIZATION_ID
RCV_TRANSACTIONS	RCV_SHIPMENT_LINES	RCV_TRANSACTIONS.SHIPMENT_LINE_ID
RCV_TRANSACTIONS	BOM_RESOURCES	RCV_TRANSACTIONS.BOM_RESOURCE_ID
RCV_TRANSACTIONS	MTL_ITEM_LOCATIONS	RCV_TRANSACTIONS.LOCATOR_ID RCV_TRANSACTIONS.ORGANIZATION_ID
RCV_TRANSACTIONS	MTL_TRANSACTION_REASONS	RCV_TRANSACTIONS.REASON_ID
RCV_TRANSACTIONS	GL_DAILY_CONVERSION_TYPES	RCV_TRANSACTIONS.CURRENCY_CONVERSION_TYPE
RCV_TRANSACTIONS	HR_LOCATIONS_ALL	RCV_TRANSACTIONS.LOCATION_ID
RCV_TRANSACTIONS	MTL_MATERIAL_TRANSACTIONS	RCV_TRANSACTIONS.INV_TRANSACTION_ID
RCV_TRANSACTIONS	RCV_TRANSACTIONS	RCV_TRANSACTIONS.PARENT_TRANSACTION_ID
RCV_TRANSACTIONS	PO_HEADERS_ALL	RCV_TRANSACTIONS.PO_HEADER_ID
AP_HOLDS_ALL	RCV_TRANSACTIONS	AP_HOLDS_ALL.RCV_TRANSACTION_ID
AP_INVOICE_DISTRIBUTIONS_ALL	RCV_TRANSACTIONS	AP_INVOICE_DISTRIBUTIONS_ALL.RCV_TRANSACTION_ID
%	RCV_TRANSACTIONS
AP_MATCHED_RECT_ADJ_ALL	RCV_TRANSACTIONS	AP_MATCHED_RECT_ADJ_ALL.PARENT_RCV_TXN_ID
AP_MATCHED_RECT_ADJ_ALL	RCV_TRANSACTIONS	AP_MATCHED_RECT_ADJ_ALL.ADJUSTED_RCV_TXN_ID
CST_AE_HEADERS	RCV_TRANSACTIONS	CST_AE_HEADERS.ACCOUNTING_EVENT_ID
CST_AP_PO_RECONCILIATION	RCV_TRANSACTIONS	CST_AP_PO_RECONCILIATION.RCV_TRANSACTION_ID
CST_RCV_ACQ_COSTS	RCV_TRANSACTIONS	CST_RCV_ACQ_COSTS.RCV_TRANSACTION_ID
CST_WRITE_OFF_DETAILS	RCV_TRANSACTIONS	CST_WRITE_OFF_DETAILS.RCV_TRANSACTION_ID
FV_INV_SELECTED_DUEDATE	RCV_TRANSACTIONS	FV_INV_SELECTED_DUEDATE.TRANSACTION_ID
FV_RCV_TRANSACTIONS	RCV_TRANSACTIONS	FV_RCV_TRANSACTIONS.TRANSACTION_ID
JAI_AP_MATCH_ERS_T	RCV_TRANSACTIONS	JAI_AP_MATCH_ERS_T.RCV_TRANSACTION_ID
JAI_AP_MATCH_INV_TAXES	RCV_TRANSACTIONS	JAI_AP_MATCH_INV_TAXES.RCV_TRANSACTION_ID
JAI_CMN_BOE_MATCHINGS	RCV_TRANSACTIONS	JAI_CMN_BOE_MATCHINGS.TRANSACTION_ID
JAI_CMN_RG_ROUND_LINES	RCV_TRANSACTIONS	JAI_CMN_RG_ROUND_LINES.SRC_TRANSACTION_ID
JAI_CMN_ST_FORM_DTLS	RCV_TRANSACTIONS	JAI_CMN_ST_FORM_DTLS.RCV_TRANSACTION_ID
JAI_OM_REP_JAINEXFR_T	RCV_TRANSACTIONS	JAI_OM_REP_JAINEXFR_T.TRANSACTION_ID
JAI_OPM_CM_ADJS_DTL	RCV_TRANSACTIONS	JAI_OPM_CM_ADJS_DTL.RCV_TRANSACTION_ID
JAI_PO_REP_PRRG_T	RCV_TRANSACTIONS	JAI_PO_REP_PRRG_T.RCV_TRANSACTION_ID
JAI_RCV_CENVAT_CLAIMS	RCV_TRANSACTIONS	JAI_RCV_CENVAT_CLAIMS.TRANSACTION_ID
JAI_RCV_CENVAT_CLAIM_T	RCV_TRANSACTIONS	JAI_RCV_CENVAT_CLAIM_T.TRANSACTION_ID
JAI_RCV_JOURNAL_ENTRIES	RCV_TRANSACTIONS	JAI_RCV_JOURNAL_ENTRIES.TRANSACTION_ID
JAI_RCV_LINES	RCV_TRANSACTIONS	JAI_RCV_LINES.TRANSACTION_ID
JAI_RCV_LINE_TAXES	RCV_TRANSACTIONS	JAI_RCV_LINE_TAXES.TRANSACTION_ID
JAI_RCV_REP_ACCRUAL_T	RCV_TRANSACTIONS	JAI_RCV_REP_ACCRUAL_T.TRANSACTION_ID
JAI_RCV_RGM_CLAIMS	RCV_TRANSACTIONS	JAI_RCV_RGM_CLAIMS.TAX_TRANSACTION_ID
JAI_RCV_RGM_CLAIMS	RCV_TRANSACTIONS	JAI_RCV_RGM_CLAIMS.TRANSACTION_ID
JAI_RCV_RGM_LINES	RCV_TRANSACTIONS	JAI_RCV_RGM_LINES.TRANSACTION_ID
JAI_RCV_RTV_BATCH_TRXS	RCV_TRANSACTIONS	JAI_RCV_RTV_BATCH_TRXS.PARENT_TRANSACTION_ID
JAI_RCV_RTV_DTLS	RCV_TRANSACTIONS	JAI_RCV_RTV_DTLS.TRANSACTION_ID
JAI_RCV_RTV_DTLS	RCV_TRANSACTIONS	JAI_RCV_RTV_DTLS.PARENT_TRANSACTION_ID
JAI_RCV_SUBLED_ENTRIES	RCV_TRANSACTIONS	JAI_RCV_SUBLED_ENTRIES.RCV_TRANSACTION_ID
JAI_RCV_TP_INV_DETAILS	RCV_TRANSACTIONS	JAI_RCV_TP_INV_DETAILS.RCV_TRANSACTION_ID
JAI_RCV_TRANSACTIONS	RCV_TRANSACTIONS	JAI_RCV_TRANSACTIONS.TRANSACTION_ID
JAI_RCV_TRANSACTIONS	RCV_TRANSACTIONS	JAI_RCV_TRANSACTIONS.TAX_TRANSACTION_ID
JAI_RCV_TRANSACTIONS	RCV_TRANSACTIONS	JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_ID
JE_IT_PO_PACKSLIPS	RCV_TRANSACTIONS	JE_IT_PO_PACKSLIPS.TRANSACTION_ID
MTL_MATERIAL_TRANSACTIONS	RCV_TRANSACTIONS	MTL_MATERIAL_TRANSACTIONS.RCV_TRANSACTION_ID
MTL_MATERIAL_TRANSACTIONS_TEMP	RCV_TRANSACTIONS	MTL_MATERIAL_TRANSACTIONS_TEMP.RCV_TRANSACTION_ID
MTL_SUPPLY	RCV_TRANSACTIONS	MTL_SUPPLY.RCV_TRANSACTION_ID
PO_ACCRUAL_RECONCILE_TEMP_ALL	RCV_TRANSACTIONS	PO_ACCRUAL_RECONCILE_TEMP_ALL.PO_TRANSACTION_ID
PO_ACCRUAL_WRITE_OFFS_ALL	RCV_TRANSACTIONS	PO_ACCRUAL_WRITE_OFFS_ALL.PO_TRANSACTION_ID
PO_ONLINE_REPORT_TEXT	RCV_TRANSACTIONS	PO_ONLINE_REPORT_TEXT.TRANSACTION_ID
RCV_ACCOUNTING_EVENTS	RCV_TRANSACTIONS	RCV_ACCOUNTING_EVENTS.RCV_TRANSACTION_ID
RCV_LOTS_SUPPLY	RCV_TRANSACTIONS	RCV_LOTS_SUPPLY.TRANSACTION_ID
RCV_LOT_TRANSACTIONS	RCV_TRANSACTIONS	RCV_LOT_TRANSACTIONS.TRANSACTION_ID
RCV_LOT_TRANSACTIONS	RCV_TRANSACTIONS	RCV_LOT_TRANSACTIONS.SOURCE_TRANSACTION_ID
RCV_LOT_TRANSACTIONS	RCV_TRANSACTIONS	RCV_LOT_TRANSACTIONS.CORRECTION_TRANSACTION_ID
RCV_SERIALS_SUPPLY	RCV_TRANSACTIONS	RCV_SERIALS_SUPPLY.TRANSACTION_ID
RCV_SERIAL_TRANSACTIONS	RCV_TRANSACTIONS	RCV_SERIAL_TRANSACTIONS.SOURCE_TRANSACTION_ID
RCV_SERIAL_TRANSACTIONS	RCV_TRANSACTIONS	RCV_SERIAL_TRANSACTIONS.CORRECTION_TRANSACTION_ID
RCV_SERIAL_TRANSACTIONS	RCV_TRANSACTIONS	RCV_SERIAL_TRANSACTIONS.TRANSACTION_ID
RCV_RECEIVING_SUB_LEDGER	RCV_TRANSACTIONS	RCV_RECEIVING_SUB_LEDGER.RCV_TRANSACTION_ID
RCV_SUPPLY	RCV_TRANSACTIONS	RCV_SUPPLY.RCV_TRANSACTION_ID
RCV_TRANSACTIONS	RCV_TRANSACTIONS	RCV_TRANSACTIONS.PARENT_TRANSACTION_ID
RCV_TRANSACTIONS_INTERFACE	RCV_TRANSACTIONS	RCV_TRANSACTIONS_INTERFACE.PARENT_TRANSACTION_ID
WIP_COST_TXN_INTERFACE	RCV_TRANSACTIONS	WIP_COST_TXN_INTERFACE.RCV_TRANSACTION_ID
WIP_TRANSACTIONS	RCV_TRANSACTIONS	WIP_TRANSACTIONS.RCV_TRANSACTION_ID