FND Design Data [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: TableONT.OE_TRANSACTION_TYPES_ALL
Primary Key: OE_TRANSACTION_TYPES_ALL_PK
  1. ColumnTRANSACTION_TYPE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
OE_TRANSACTION_TYPES_ALL FK Joins to TableRA_RULES OE_TRANSACTION_TYPES_ALL.ACCOUNTING_RULE_ID
OE_TRANSACTION_TYPES_ALL FK Joins to TableRA_RULES OE_TRANSACTION_TYPES_ALL.INVOICING_RULE_ID
OE_TRANSACTION_TYPES_ALL FK Joins to TableRA_BATCH_SOURCES_ALL OE_TRANSACTION_TYPES_ALL.INVOICE_SOURCE_ID
OE_TRANSACTION_TYPES_ALL FK Joins to TableRA_BATCH_SOURCES_ALL OE_TRANSACTION_TYPES_ALL.NON_DELIVERY_INVOICE_SOURCE_ID
OE_TRANSACTION_TYPES_ALL FK Joins to TableOE_TRANSACTION_TYPES_ALL OE_TRANSACTION_TYPES_ALL.TRANSACTION_TYPE_ID
OE_TRANSACTION_TYPES_ALL FK Joins to TableOE_CREDIT_CHECK_RULES OE_TRANSACTION_TYPES_ALL.ENTRY_CREDIT_CHECK_RULE_ID
OE_TRANSACTION_TYPES_ALL FK Joins to TableOE_CREDIT_CHECK_RULES OE_TRANSACTION_TYPES_ALL.SHIPPING_CREDIT_CHECK_RULE_ID
OE_TRANSACTION_TYPES_ALL FK Joins to TableHR_ALL_ORGANIZATION_UNITS OE_TRANSACTION_TYPES_ALL.WAREHOUSE_ID
OE_TRANSACTION_TYPES_ALL FK Joins to TableOE_TRANSACTION_TYPES_ALL OE_TRANSACTION_TYPES_ALL.DEFAULT_OUTBOUND_LINE_TYPE_ID
OE_TRANSACTION_TYPES_ALL FK Joins to TableOE_TRANSACTION_TYPES_ALL OE_TRANSACTION_TYPES_ALL.DEFAULT_INBOUND_LINE_TYPE_ID
OE_TRANSACTION_TYPES_ALL FK Joins to TableQP_LIST_HEADERS_B OE_TRANSACTION_TYPES_ALL.PRICE_LIST_ID
OE_TRANSACTION_TYPES_ALL FK Joins to TableFND_CURRENCIES OE_TRANSACTION_TYPES_ALL.CURRENCY_CODE
OE_TRANSACTION_TYPES_ALL FK Joins to TableRA_CUST_TRX_TYPES_ALL OE_TRANSACTION_TYPES_ALL.CUST_TRX_TYPE_ID
TableJAI_CMN_ST_FORM_DTLS FK Joins to OE_TRANSACTION_TYPES_ALL JAI_CMN_ST_FORM_DTLS.TRX_TYPE_ID
TableJAI_OM_OE_BOND_REG_DTLS FK Joins to OE_TRANSACTION_TYPES_ALL JAI_OM_OE_BOND_REG_DTLS.ORDER_TYPE_ID
TableJAI_OM_WSH_LINES_ALL FK Joins to OE_TRANSACTION_TYPES_ALL JAI_OM_WSH_LINES_ALL.ORDER_TYPE_ID
TableOE_ORDER_HEADERS_ALL FK Joins to OE_TRANSACTION_TYPES_ALL OE_ORDER_HEADERS_ALL.ORDER_TYPE_ID
TableOE_ORDER_LINES_ALL FK Joins to OE_TRANSACTION_TYPES_ALL OE_ORDER_LINES_ALL.LINE_TYPE_ID
TableOE_TRANSACTION_TYPES_ALL FK Joins to OE_TRANSACTION_TYPES_ALL OE_TRANSACTION_TYPES_ALL.TRANSACTION_TYPE_ID
TableOE_TRANSACTION_TYPES_ALL FK Joins to OE_TRANSACTION_TYPES_ALL OE_TRANSACTION_TYPES_ALL.DEFAULT_OUTBOUND_LINE_TYPE_ID
TableOE_TRANSACTION_TYPES_ALL FK Joins to OE_TRANSACTION_TYPES_ALL OE_TRANSACTION_TYPES_ALL.DEFAULT_INBOUND_LINE_TYPE_ID
TableOE_TRANSACTION_TYPES_TL FK Joins to OE_TRANSACTION_TYPES_ALL OE_TRANSACTION_TYPES_TL.TRANSACTION_TYPE_ID
TableOE_WORKFLOW_ASSIGNMENTS FK Joins to OE_TRANSACTION_TYPES_ALL OE_WORKFLOW_ASSIGNMENTS.ORDER_TYPE_ID
TableOE_WORKFLOW_ASSIGNMENTS FK Joins to OE_TRANSACTION_TYPES_ALL OE_WORKFLOW_ASSIGNMENTS.LINE_TYPE_ID