FND Design Data [Home] [Help]

Table: OE_HEADERS_IFACE_ALL

Product: ONT - Order Management
Description: This is a multi-org table for sales order headers open interface.
Implementation/DBA Data: TableONT.OE_HEADERS_IFACE_ALL
Foreign Keys
Table
Foreign Table Foreign Key Column
OE_HEADERS_IFACE_ALL FK Joins to TableFND_CURRENCIES OE_HEADERS_IFACE_ALL.TRANSACTIONAL_CURR_CODE
OE_HEADERS_IFACE_ALL FK Joins to TableHR_ALL_ORGANIZATION_UNITS OE_HEADERS_IFACE_ALL.SOLD_FROM_ORG_ID
OE_HEADERS_IFACE_ALL FK Joins to TableRA_RULES OE_HEADERS_IFACE_ALL.ACCOUNTING_RULE_ID
OE_HEADERS_IFACE_ALL FK Joins to TableRA_RULES OE_HEADERS_IFACE_ALL.INVOICING_RULE_ID
OE_HEADERS_IFACE_ALL FK Joins to TableRA_SALESREPS_ALL OE_HEADERS_IFACE_ALL.SALESREP_ID
OE_HEADERS_IFACE_ALL FK Joins to TableRA_TERMS_B OE_HEADERS_IFACE_ALL.PAYMENT_TERM_ID
OE_HEADERS_IFACE_ALL FK Joins to TableRA_TERMS_B OE_HEADERS_IFACE_ALL.CUSTOMER_PAYMENT_TERM_ID
OE_HEADERS_IFACE_ALL FK Joins to TableHZ_CUST_ACCOUNTS OE_HEADERS_IFACE_ALL.DELIVER_TO_CUSTOMER_ID
OE_HEADERS_IFACE_ALL FK Joins to TableHZ_PARTIES OE_HEADERS_IFACE_ALL.DELIVER_TO_PARTY_ID
OE_HEADERS_IFACE_ALL FK Joins to TableHZ_PARTIES OE_HEADERS_IFACE_ALL.END_CUSTOMER_PARTY_ID
OE_HEADERS_IFACE_ALL FK Joins to TableHZ_PARTIES OE_HEADERS_IFACE_ALL.INVOICE_TO_PARTY_ID
OE_HEADERS_IFACE_ALL FK Joins to TableHZ_PARTIES OE_HEADERS_IFACE_ALL.SHIP_TO_PARTY_ID
OE_HEADERS_IFACE_ALL FK Joins to TableHZ_PARTIES OE_HEADERS_IFACE_ALL.SOLD_TO_PARTY_ID
OE_HEADERS_IFACE_ALL FK Joins to TableHZ_CUST_ACCT_SITES_ALL OE_HEADERS_IFACE_ALL.SHIP_TO_CUSTOMER_ID
OE_HEADERS_IFACE_ALL FK Joins to TableHZ_PARTY_SITES OE_HEADERS_IFACE_ALL.SHIP_TO_PARTY_SITE_ID
OE_HEADERS_IFACE_ALL FK Joins to TableHZ_CUST_SITE_USES_ALL OE_HEADERS_IFACE_ALL.SOLD_TO_SITE_USE_ID
OE_HEADERS_IFACE_ALL FK Joins to TableHZ_CONTACT_POINTS OE_HEADERS_IFACE_ALL.SOLD_TO_PHONE_ID
OE_HEADERS_IFACE_ALL FK Joins to TableHZ_CUST_ACCOUNTS OE_HEADERS_IFACE_ALL.END_CUSTOMER_ID
OE_HEADERS_IFACE_ALL FK Joins to TableHZ_CUST_SITE_USES_ALL OE_HEADERS_IFACE_ALL.END_CUSTOMER_SITE_USE_ID
OE_HEADERS_IFACE_ALL FK Joins to TableHZ_PARTY_SITE_USES OE_HEADERS_IFACE_ALL.END_CUSTOMER_PARTY_SITE_USE_ID
OE_HEADERS_IFACE_ALL FK Joins to TableOE_AGREEMENTS_B OE_HEADERS_IFACE_ALL.AGREEMENT_ID
OE_HEADERS_IFACE_ALL FK Joins to TableOE_ORDER_SOURCES OE_HEADERS_IFACE_ALL.ORDER_SOURCE_ID
OE_HEADERS_IFACE_ALL FK Joins to TableOE_ORDER_HEADERS_ALL OE_HEADERS_IFACE_ALL.HEADER_ID