QP — Advanced Pricing
114 documented tables · 116 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
QP_LIST_HEADERS_B |
QP_LIST_HEADERS_B stores the header information for all lists. List types can be, for example, Price Lists, D | hub-leaning |
QP_LIST_LINES |
QP_LIST_LINES stores all list lines for lists in QP_LIST_HEADERS_B. | hub |
QP_CURRENCY_LISTS_B |
QP_CURRENCY_LISTS_B stores the header information for all Multi-Currency lists. A Multi-Currency list is assoc | hub-leaning |
QP_PRICE_FORMULAS_B |
QP_PRICE_FORMULAS_B stores the pricing formula header information. | hub |
QP_PRICING_PHASES |
QP_PRICING_PHASES stores all pricing phases. | hub-leaning |
QP_LIMITS |
This table table holds the definition of the limit, and the Promotion, Deal or modifier for which the limit is | satellite-leaning |
OE_AGREEMENTS_B |
OE_AGREEMENTS_B stores all information about pricing agreements. | satellite-leaning |
QP_QUALIFIER_RULES |
QP_QUALIFIER_RULES stores the header information for all qualifier rules | hub-leaning |
QP_LIMIT_BALANCES |
QP_LIMIT_BALANCES holds the balances for a limit. | satellite-leaning |
QP_PRICING_ATT_EBS_LOG |
Log table for the Euro conversion of QP_PRICING_ATTRIBUTES table. This table is used only by the Euro Convers | standalone |
QP_LIST_LINES_EBS_LOG |
Log table for the Euro conversion of QP_LIST_LINES table. This table is used only by the Euro Conversion con | standalone |
QP_FACTOR_LIST_ATTRS |
This table stores all distinct combinations of list_header_id, pricing_attribute_context andpricing_attribute | satellite-leaning |
QP_PRICE_FORMULAS_TL |
This table stores the translatable columns, name & description of the pricing formulas, in each of the availab | satellite-leaning |
QP_RLTD_MOD_EBS_LOG |
Log table for the Euro conversion of QP_RLTD_MODIFIERS table. This table is used only by the Euro Conversion | standalone |
OE_ITEM_GROUP_LINES |
standalone |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
QP_PREQ_GRP |
GRP | 21 | 97 packages |
QP_QUALIFIER_RULES_PUB |
PUB | 4 | 53 packages |
QP_ATTR_MAPPING_PUB |
PUB | 21 | 42 packages |
QP_PREQ_PUB |
PUB | 13 | 42 packages |
QP_PRICE_LIST_PUB |
PUB | 3 | 33 packages |
QP_UTIL_PUB |
PUB | 25 | 32 packages |
QP_MODIFIERS_PUB |
PUB | 3 | 30 packages |
QP_JAVA_ENGINE_UTIL_PUB |
PUB | 6 | 26 packages |
QP_ATTR_MAP_PUB |
PUB | 6 | 25 packages |
QP_LIMITS_PUB |
PUB | 3 | 15 packages |