FND Design Data [Home] [Help]

Table: OTA_PRICE_LIST_ENTRIES

Product: OTA - Learning Management
Description: A price list entry records the price of an activity between two dates.
Implementation/DBA Data: TableOTA.OTA_PRICE_LIST_ENTRIES
Primary Key: OTA_PRICE_LIST_ENTRIES_PK
  1. ColumnPRICE_LIST_ENTRY_ID
Primary Key: OTA_PRICE_LIST_ENTRIES_UK2
  1. ColumnACTIVITY_VERSION_ID
  2. ColumnSTART_DATE
  3. ColumnPRICE_LIST_ID
  4. ColumnVENDOR_SUPPLY_ID
  5. ColumnPRICE_BASIS
  6. ColumnMINIMUM_ATTENDEES
Foreign Keys
Table
Foreign Table Foreign Key Column
OTA_PRICE_LIST_ENTRIES FK Joins to TableOTA_VENDOR_SUPPLIES OTA_PRICE_LIST_ENTRIES.VENDOR_SUPPLY_ID
OTA_PRICE_LIST_ENTRIES FK Joins to TableOTA_ACTIVITY_VERSIONS OTA_PRICE_LIST_ENTRIES.ACTIVITY_VERSION_ID
OTA_PRICE_LIST_ENTRIES FK Joins to TableOTA_PRICE_LISTS OTA_PRICE_LIST_ENTRIES.PRICE_LIST_ID