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_INTERFACE

Product:	PO - Purchasing
Description:	Receiving transactions interface table
Implementation/DBA Data:	PO.RCV_TRANSACTIONS_INTERFACE

Primary Key: RCV_TRX_INTERFACE_PK

INTERFACE_TRANSACTION_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
RCV_TRANSACTIONS_INTERFACE	PO_VENDORS	RCV_TRANSACTIONS_INTERFACE.VENDOR_ID
RCV_TRANSACTIONS_INTERFACE	PO_VENDOR_SITES_ALL	RCV_TRANSACTIONS_INTERFACE.VENDOR_SITE_ID
RCV_TRANSACTIONS_INTERFACE	RCV_ROUTING_HEADERS	RCV_TRANSACTIONS_INTERFACE.ROUTING_HEADER_ID
RCV_TRANSACTIONS_INTERFACE	RCV_ROUTING_STEPS	RCV_TRANSACTIONS_INTERFACE.ROUTING_STEP_ID
RCV_TRANSACTIONS_INTERFACE	RCV_TRANSACTIONS	RCV_TRANSACTIONS_INTERFACE.PARENT_TRANSACTION_ID
RCV_TRANSACTIONS_INTERFACE	PO_HEADERS_ALL	RCV_TRANSACTIONS_INTERFACE.PO_HEADER_ID
RCV_TRANSACTIONS_INTERFACE	PO_LINES_ALL	RCV_TRANSACTIONS_INTERFACE.PO_LINE_ID
RCV_TRANSACTIONS_INTERFACE	PO_LINE_LOCATIONS_ALL	RCV_TRANSACTIONS_INTERFACE.PO_LINE_LOCATION_ID
RCV_TRANSACTIONS_INTERFACE	MTL_MATERIAL_TRANSACTIONS	RCV_TRANSACTIONS_INTERFACE.INV_TRANSACTION_ID
RCV_TRANSACTIONS_INTERFACE	PO_DISTRIBUTIONS_ALL	RCV_TRANSACTIONS_INTERFACE.PO_DISTRIBUTION_ID
RCV_TRANSACTIONS_INTERFACE	PO_RELEASES_ALL	RCV_TRANSACTIONS_INTERFACE.PO_RELEASE_ID
RCV_TRANSACTIONS_INTERFACE	PO_REQUISITION_LINES_ALL	RCV_TRANSACTIONS_INTERFACE.REQUISITION_LINE_ID
RCV_TRANSACTIONS_INTERFACE	PO_REQ_DISTRIBUTIONS_ALL	RCV_TRANSACTIONS_INTERFACE.REQ_DISTRIBUTION_ID
RCV_TRANSACTIONS_INTERFACE	PO_QUALITY_CODES	RCV_TRANSACTIONS_INTERFACE.INSPECTION_QUALITY_CODE
RCV_TRANSACTIONS_INTERFACE	GL_CODE_COMBINATIONS	RCV_TRANSACTIONS_INTERFACE.CHARGE_ACCOUNT_ID
RCV_TRANSACTIONS_INTERFACE	GL_CODE_COMBINATIONS	RCV_TRANSACTIONS_INTERFACE.TRANSPORTATION_ACCOUNT_ID
RCV_TRANSACTIONS_INTERFACE	BOM_RESOURCES	RCV_TRANSACTIONS_INTERFACE.BOM_RESOURCE_ID
RCV_TRANSACTIONS_INTERFACE	MTL_SECONDARY_INVENTORIES	RCV_TRANSACTIONS_INTERFACE.SUBINVENTORY RCV_TRANSACTIONS_INTERFACE.TO_ORGANIZATION_ID
RCV_TRANSACTIONS_INTERFACE	MTL_ITEM_LOCATIONS	RCV_TRANSACTIONS_INTERFACE.LOCATOR_ID RCV_TRANSACTIONS_INTERFACE.TO_ORGANIZATION_ID
RCV_TRANSACTIONS_INTERFACE	GL_DAILY_CONVERSION_TYPES	RCV_TRANSACTIONS_INTERFACE.CURRENCY_CONVERSION_TYPE
RCV_TRANSACTIONS_INTERFACE	MTL_TRANSACTION_REASONS	RCV_TRANSACTIONS_INTERFACE.REASON_ID
RCV_TRANSACTIONS_INTERFACE	RCV_SHIPMENT_HEADERS	RCV_TRANSACTIONS_INTERFACE.SHIPMENT_HEADER_ID
RCV_TRANSACTIONS_INTERFACE	RCV_SHIPMENT_LINES	RCV_TRANSACTIONS_INTERFACE.SHIPMENT_LINE_ID
JAI_CMN_LINES	RCV_TRANSACTIONS_INTERFACE	JAI_CMN_LINES.INTERFACE_TRANSACTION_ID
PO_INTERFACE_ERRORS	RCV_TRANSACTIONS_INTERFACE	PO_INTERFACE_ERRORS.INTERFACE_TRANSACTION_ID
RCV_LOTS_INTERFACE	RCV_TRANSACTIONS_INTERFACE	RCV_LOTS_INTERFACE.INTERFACE_TRANSACTION_ID
RCV_SERIALS_INTERFACE	RCV_TRANSACTIONS_INTERFACE	RCV_SERIALS_INTERFACE.INTERFACE_TRANSACTION_ID
WMS_LPN_CONTENTS_INTERFACE	RCV_TRANSACTIONS_INTERFACE	WMS_LPN_CONTENTS_INTERFACE.INTERFACE_TRANSACTION_ID