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_LINES_IFACE_ALL

Product:	ONT - Order Management
Description:	This is a multi-org table for sales order lines open interface.
Implementation/DBA Data:	ONT.OE_LINES_IFACE_ALL

Foreign Keys

Table	Foreign Table	Foreign Key Column
OE_LINES_IFACE_ALL	HR_ALL_ORGANIZATION_UNITS	OE_LINES_IFACE_ALL.SHIP_FROM_ORG_ID
OE_LINES_IFACE_ALL	HR_ALL_ORGANIZATION_UNITS	OE_LINES_IFACE_ALL.SOLD_FROM_ORG_ID
OE_LINES_IFACE_ALL	RA_RULES	OE_LINES_IFACE_ALL.ACCOUNTING_RULE_ID
OE_LINES_IFACE_ALL	RA_RULES	OE_LINES_IFACE_ALL.INVOICING_RULE_ID
OE_LINES_IFACE_ALL	RA_SALESREPS_ALL	OE_LINES_IFACE_ALL.SALESREP_ID
OE_LINES_IFACE_ALL	RA_TERMS_B	OE_LINES_IFACE_ALL.PAYMENT_TERM_ID
OE_LINES_IFACE_ALL	RA_TERMS_B	OE_LINES_IFACE_ALL.CUSTOMER_PAYMENT_TERM_ID
OE_LINES_IFACE_ALL	HZ_PARTIES	OE_LINES_IFACE_ALL.DELIVER_TO_PARTY_ID
OE_LINES_IFACE_ALL	HZ_PARTIES	OE_LINES_IFACE_ALL.END_CUSTOMER_PARTY_ID
OE_LINES_IFACE_ALL	HZ_PARTIES	OE_LINES_IFACE_ALL.INVOICE_TO_PARTY_ID
OE_LINES_IFACE_ALL	HZ_PARTIES	OE_LINES_IFACE_ALL.SHIP_TO_PARTY_ID
OE_LINES_IFACE_ALL	HZ_CUST_ACCOUNTS	OE_LINES_IFACE_ALL.DELIVER_TO_CUSTOMER_ID
OE_LINES_IFACE_ALL	HZ_CUST_ACCOUNT_ROLES	OE_LINES_IFACE_ALL.END_CUSTOMER_CONTACT_ID
OE_LINES_IFACE_ALL	HZ_CUST_ACCOUNTS	OE_LINES_IFACE_ALL.END_CUSTOMER_ID
OE_LINES_IFACE_ALL	HZ_CUST_ACCOUNTS	OE_LINES_IFACE_ALL.SHIP_TO_CUSTOMER_ID
OE_LINES_IFACE_ALL	HZ_CUST_SITE_USES_ALL	OE_LINES_IFACE_ALL.END_CUSTOMER_SITE_USE_ID
OE_LINES_IFACE_ALL	HZ_CUST_ACCOUNTS	OE_LINES_IFACE_ALL.INVOICE_TO_CUSTOMER_ID
OE_LINES_IFACE_ALL	HZ_ORG_CONTACTS	OE_LINES_IFACE_ALL.DELIVER_TO_ORG_CONTACT_ID
OE_LINES_IFACE_ALL	HZ_PARTY_SITES	OE_LINES_IFACE_ALL.DELIVER_TO_PARTY_SITE_ID
OE_LINES_IFACE_ALL	HZ_PARTY_SITE_USES	OE_LINES_IFACE_ALL.DELIVER_TO_PARTY_SITE_USE_ID
OE_LINES_IFACE_ALL	HZ_ORG_CONTACTS	OE_LINES_IFACE_ALL.END_CUSTOMER_ORG_CONTACT_ID
OE_LINES_IFACE_ALL	HZ_PARTY_SITES	OE_LINES_IFACE_ALL.END_CUSTOMER_PARTY_SITE_ID
OE_LINES_IFACE_ALL	OE_ORDER_SOURCES	OE_LINES_IFACE_ALL.ORDER_SOURCE_ID
OE_LINES_IFACE_ALL	HZ_PARTY_SITE_USES	OE_LINES_IFACE_ALL.END_CUSTOMER_PARTY_SITE_USE_ID
OE_LINES_IFACE_ALL	HZ_ORG_CONTACTS	OE_LINES_IFACE_ALL.INVOICE_TO_ORG_CONTACT_ID
OE_LINES_IFACE_ALL	HZ_PARTY_SITES	OE_LINES_IFACE_ALL.INVOICE_TO_PARTY_SITE_ID
OE_LINES_IFACE_ALL	HZ_PARTY_SITE_USES	OE_LINES_IFACE_ALL.INVOICE_TO_PARTY_SITE_USE_ID
OE_LINES_IFACE_ALL	HZ_ORG_CONTACTS	OE_LINES_IFACE_ALL.SHIP_TO_ORG_CONTACT_ID
OE_LINES_IFACE_ALL	HZ_PARTY_SITES	OE_LINES_IFACE_ALL.SHIP_TO_PARTY_SITE_ID
OE_LINES_IFACE_ALL	HZ_PARTY_SITE_USES	OE_LINES_IFACE_ALL.SHIP_TO_PARTY_SITE_USE_ID