FND Design Data [Home] [Help]

Table: OE_AGREEMENTS_B

Product: QP - Advanced Pricing
Description: OE_AGREEMENTS_B stores all information about pricing agreements.
Implementation/DBA Data: TableQP.OE_AGREEMENTS_B
Primary Key: OE_AGREEMENTS_B_PK
  1. ColumnAGREEMENT_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
OE_AGREEMENTS_B FK Joins to TableQP_LIST_HEADERS_B OE_AGREEMENTS_B.PRICE_LIST_ID
OE_AGREEMENTS_B FK Joins to TableRA_RULES OE_AGREEMENTS_B.INVOICING_RULE_ID
OE_AGREEMENTS_B FK Joins to TableRA_RULES OE_AGREEMENTS_B.ACCOUNTING_RULE_ID
OE_AGREEMENTS_B FK Joins to TableRA_SALESREPS_ALL OE_AGREEMENTS_B.SALESREP_ID
TableOE_HEADERS_IFACE_ALL FK Joins to OE_AGREEMENTS_B OE_HEADERS_IFACE_ALL.AGREEMENT_ID
TableOE_HEADER_ACKS FK Joins to OE_AGREEMENTS_B OE_HEADER_ACKS.AGREEMENT_ID
TableOE_ORDER_HEADERS_ALL FK Joins to OE_AGREEMENTS_B OE_ORDER_HEADERS_ALL.AGREEMENT_ID
TableOE_ORDER_LINES_ALL FK Joins to OE_AGREEMENTS_B OE_ORDER_LINES_ALL.AGREEMENT_ID