FND Design Data [Home] [Help]

Table: AMS_PRICE_LIST_ATTRIBUTES

Product: AMS - Marketing
Description: This is a surrogate table to QP_LIST_HEADERS_B for Price List related information. QP_LIST_HEADER_ID is the foreign key to QP_LIST_HEADERS_B. This table will capture status, owner and other attributes specifice to Marketing Online Requir
Implementation/DBA Data: TableAMS.AMS_PRICE_LIST_ATTRIBUTES
Primary Key: AMS_PRICE_LIST_ATTRIBUTES_PK
  1. ColumnPRICE_LIST_ATTRIBUTE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
AMS_PRICE_LIST_ATTRIBUTES FK Joins to TableJTF_RS_RESOURCE_EXTNS AMS_PRICE_LIST_ATTRIBUTES.OWNER_ID
AMS_PRICE_LIST_ATTRIBUTES FK Joins to TableQP_LIST_HEADERS_B AMS_PRICE_LIST_ATTRIBUTES.QP_LIST_HEADER_ID
AMS_PRICE_LIST_ATTRIBUTES FK Joins to TableAMS_CUSTOM_SETUPS_B AMS_PRICE_LIST_ATTRIBUTES.CUSTOM_SETUP_ID
AMS_PRICE_LIST_ATTRIBUTES FK Joins to TableAMS_USER_STATUSES_B AMS_PRICE_LIST_ATTRIBUTES.USER_STATUS_ID