FND Design Data [Home] [Help]

Table: QP_CURRENCY_DETAILS

Product: QP - Advanced Pricing
Description: QP_CURRENCY_DETAILS stores all the lines for the multi-currency lists in QP_CURRENCY_LISTS_B.At any point of time there can be only one active record for a given to_currency_code. Thistable has atleast one record of to_currency_code = base_
Implementation/DBA Data: TableQP.QP_CURRENCY_DETAILS
Primary Key: QP_CURRENCY_DETAILS_PK
  1. ColumnCURRENCY_DETAIL_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
QP_CURRENCY_DETAILS FK Joins to TableQP_CURRENCY_LISTS_B QP_CURRENCY_DETAILS.CURRENCY_HEADER_ID
QP_CURRENCY_DETAILS FK Joins to TableQP_PRICE_FORMULAS_B QP_CURRENCY_DETAILS.PRICE_FORMULA_ID
QP_CURRENCY_DETAILS FK Joins to TableQP_PRICE_FORMULAS_B QP_CURRENCY_DETAILS.MARKUP_FORMULA_ID
QP_CURRENCY_DETAILS FK Joins to TableFND_CURRENCIES QP_CURRENCY_DETAILS.TO_CURRENCY_CODE