FND Design Data [Home] [Help]

Table: AMS_OFFER_PARTIES

Product: AMS - Marketing
Description: This table stores all the parties eligible for the request only active offers created through Oracle Marketing Online
Implementation/DBA Data: TableAMS.AMS_OFFER_PARTIES
Primary Key: AMS_OFFER_PARTIES_PK
  1. ColumnOFFER_PARTY_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
AMS_OFFER_PARTIES FK Joins to TableQP_LIST_HEADERS_B AMS_OFFER_PARTIES.QP_LIST_HEADER_ID
AMS_OFFER_PARTIES FK Joins to TableHZ_PARTIES AMS_OFFER_PARTIES.PARTY_ID