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: OE_TRANSACTION_TYPES_ALL

Product:	ONT - Order Management
Description:	This table stores information about the order and line transaction types
Implementation/DBA Data:	ONT.OE_TRANSACTION_TYPES_ALL

Primary Key: OE_TRANSACTION_TYPES_ALL_PK

TRANSACTION_TYPE_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
OE_TRANSACTION_TYPES_ALL	RA_RULES	OE_TRANSACTION_TYPES_ALL.ACCOUNTING_RULE_ID
OE_TRANSACTION_TYPES_ALL	RA_RULES	OE_TRANSACTION_TYPES_ALL.INVOICING_RULE_ID
OE_TRANSACTION_TYPES_ALL	RA_BATCH_SOURCES_ALL	OE_TRANSACTION_TYPES_ALL.INVOICE_SOURCE_ID
OE_TRANSACTION_TYPES_ALL	RA_BATCH_SOURCES_ALL	OE_TRANSACTION_TYPES_ALL.NON_DELIVERY_INVOICE_SOURCE_ID
OE_TRANSACTION_TYPES_ALL	OE_TRANSACTION_TYPES_ALL	OE_TRANSACTION_TYPES_ALL.TRANSACTION_TYPE_ID
OE_TRANSACTION_TYPES_ALL	OE_CREDIT_CHECK_RULES	OE_TRANSACTION_TYPES_ALL.ENTRY_CREDIT_CHECK_RULE_ID
OE_TRANSACTION_TYPES_ALL	OE_CREDIT_CHECK_RULES	OE_TRANSACTION_TYPES_ALL.SHIPPING_CREDIT_CHECK_RULE_ID
OE_TRANSACTION_TYPES_ALL	HR_ALL_ORGANIZATION_UNITS	OE_TRANSACTION_TYPES_ALL.WAREHOUSE_ID
OE_TRANSACTION_TYPES_ALL	OE_TRANSACTION_TYPES_ALL	OE_TRANSACTION_TYPES_ALL.DEFAULT_OUTBOUND_LINE_TYPE_ID
OE_TRANSACTION_TYPES_ALL	OE_TRANSACTION_TYPES_ALL	OE_TRANSACTION_TYPES_ALL.DEFAULT_INBOUND_LINE_TYPE_ID
OE_TRANSACTION_TYPES_ALL	QP_LIST_HEADERS_B	OE_TRANSACTION_TYPES_ALL.PRICE_LIST_ID
OE_TRANSACTION_TYPES_ALL	FND_CURRENCIES	OE_TRANSACTION_TYPES_ALL.CURRENCY_CODE
OE_TRANSACTION_TYPES_ALL	RA_CUST_TRX_TYPES_ALL	OE_TRANSACTION_TYPES_ALL.CUST_TRX_TYPE_ID
JAI_CMN_ST_FORM_DTLS	OE_TRANSACTION_TYPES_ALL	JAI_CMN_ST_FORM_DTLS.TRX_TYPE_ID
JAI_OM_OE_BOND_REG_DTLS	OE_TRANSACTION_TYPES_ALL	JAI_OM_OE_BOND_REG_DTLS.ORDER_TYPE_ID
JAI_OM_WSH_LINES_ALL	OE_TRANSACTION_TYPES_ALL	JAI_OM_WSH_LINES_ALL.ORDER_TYPE_ID
OE_ORDER_HEADERS_ALL	OE_TRANSACTION_TYPES_ALL	OE_ORDER_HEADERS_ALL.ORDER_TYPE_ID
OE_ORDER_LINES_ALL	OE_TRANSACTION_TYPES_ALL	OE_ORDER_LINES_ALL.LINE_TYPE_ID
OE_TRANSACTION_TYPES_ALL	OE_TRANSACTION_TYPES_ALL	OE_TRANSACTION_TYPES_ALL.TRANSACTION_TYPE_ID
OE_TRANSACTION_TYPES_ALL	OE_TRANSACTION_TYPES_ALL	OE_TRANSACTION_TYPES_ALL.DEFAULT_OUTBOUND_LINE_TYPE_ID
OE_TRANSACTION_TYPES_ALL	OE_TRANSACTION_TYPES_ALL	OE_TRANSACTION_TYPES_ALL.DEFAULT_INBOUND_LINE_TYPE_ID
OE_TRANSACTION_TYPES_TL	OE_TRANSACTION_TYPES_ALL	OE_TRANSACTION_TYPES_TL.TRANSACTION_TYPE_ID
OE_WORKFLOW_ASSIGNMENTS	OE_TRANSACTION_TYPES_ALL	OE_WORKFLOW_ASSIGNMENTS.ORDER_TYPE_ID
OE_WORKFLOW_ASSIGNMENTS	OE_TRANSACTION_TYPES_ALL	OE_WORKFLOW_ASSIGNMENTS.LINE_TYPE_ID