QP Tables (114)

QP - Advanced Pricing — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

Table	Columns	Description
`OE_AGREEMENTS_B`	65	OE_AGREEMENTS_B stores all information about pricing agreements.
`OE_AGREEMENTS_TL`	11	OE_AGREEMENTS_TL stores the translatable column, i.e. name of the agreement, in each of the available languages in the database.
`OE_ITEM_GROUPS`	24
`OE_ITEM_GROUP_LINES`	45
`OE_PRC_COPY_PARAMETERS`	9
`OE_PRC_RULE_LINE_VALUES`	29
`OE_PRICING_CONTRACTS`	25
`OE_PRICING_RULE_LINES`	26
`OE_RULE_FORMULA_COMPTS`	29
`QP_ADV_MOD_PRODUCTS`	3	This table stores all product information and the pricing phase for all products used in modifiers of type Other Item Discount, Promotional
`QP_ARCH_CRITERIA_HEADERS`	8	Stores the header information for the archive process
`QP_ARCH_CRITERIA_LINES`	3	Stores criteria for archive process
`QP_ARCH_LIST_HEADERS_B`	60
`QP_ARCH_LIST_HEADERS_TL`	12
`QP_ARCH_LIST_LINES`	103
`QP_ARCH_PRICING_ATTRIBUTES`	55
`QP_ARCH_QUALIFIERS`	52
`QP_ARCH_RLTD_MODIFIERS`	27
`QP_ARCH_ROW_COUNTS`	3	Stores the count of archived records
`QP_ATTRIBUTE_DEFNS`	202	QP_ATTRIBUTE_DEFNS is the table on which the Qualifier and Pricing Attribute Descriptive Flexfields are based. It is used for the entity and
`QP_ATTRIBUTE_GROUPS`	52
`QP_ATTRIBUTE_SOURCING`	36	Stores attribute mapping rules rules defined for an attribute for each of the Pricing Transaction entity, it is linked to.
`QP_CACHE_DO_SIZES`	7
`QP_CACHE_KEY_STATS`	7
`QP_CACHE_STATS`	11
`QP_COUPONS`	30	QP_COUPONS stores any Coupons which have been issued.
`QP_CURRENCY_DETAILS`	45	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 acti
`QP_CURRENCY_LISTS_B`	27	QP_CURRENCY_LISTS_B stores the header information for all Multi-Currency lists. A Multi-Currency list is associated with standard and agreem
`QP_CURRENCY_LISTS_TL`	10	QP_CURRENCY_LISTS_TL stores the translatable columns, name and description of themulti-currency list, in each of the available languages in
`QP_DEBUG_FORMULA_STEP_VALUES`	9	This table contains information about the formula step values which are inserted into the table QP_FORMULA_STEP_VALUES. The step values are
`QP_DEBUG_REQ`	21	This table contains information about the Debug requests.
`QP_DEBUG_REQ_LDETS`	53	This table contains information about the line details being priced. It has adjustment and discount details for lines, including adjustments
`QP_DEBUG_REQ_LINES`	44	This table contains information about the lines being priced.
`QP_DEBUG_REQ_LINE_ATTRS`	36	This table contains information on the pricing attributes that the attribute mapping functionality passed to the pricing engine. The pricin
`QP_DEBUG_REQ_RLTD_LINES`	21	This table contains information about the related lines.
`QP_DEBUG_TEXT`	3	This table stores the Debug messages.
`QP_DISCOUNT_MAPPING`	12	Used for upgrade purposes. QP_DISCOUNT_MAPPING table stores mapping information between the obsolete Order Entry pricing tables and the new
`QP_EVENT_PHASES`	30	QP_EVENT_PHASES stores the mapping between pricing events and pricing phases.
`QP_FACTOR_LIST_ATTRS`	3	This table stores all distinct combinations of list_header_id, pricing_attribute_context andpricing_attribute for the factor lists.
`QP_FORMULAS_EBS_LOG`	27	Log table for the Euro conversion of QP_PRICE_FORMULAS_B table. This table is used only by the Euro Conversion concurrent program to store
`QP_FORMULA_LN_EBS_LOG`	33	Log table for the Euro conversion of QP_PRICE_FORMULA_LINES table. This table is used only by the Euro Conversion concurrent program to st
`QP_FWK_DELAYED_REQUESTS`	37
`QP_GRANTS`	14	QP_GRANTS works with FND data security system to achieve data security for pricing entities.
`QP_INTERFACE_ERRORS`	19	QP_INTERFACE_ERRORS stores errors that occur during the bulk import of pricing objects.
`QP_INTERFACE_LIST_HEADERS`	73	QP_LIST_HEADERS_B stores the header information for all lists. List types can be, for example, Price Lists, Discount Lists or Promotions.
`QP_INTERFACE_LIST_LINES`	105	QP_LIST_LINES stores all list lines for lists in QP_LIST_HEADERS_B.
`QP_INTERFACE_PRICING_ATTRIBS`	64	QP_PRICING_ATTRIBUTES stores product information and pricing attributes.
`QP_INTERFACE_QUALIFIERS`	67	QP_QUALIFIERS stores qualifier attribute information.
`QP_INT_FML_STEP_VALS_T`	14	Permanent table for holding the formula step values
`QP_INT_LDETS_T`	81	Permanent table for holding the details of the derivation of the base and adjusted prices.
`QP_INT_LINES_T`	76	Permanent table for holding the elements in the calling application that requires a base and adjusted price.
`QP_INT_LINE_ATTRS_T`	41	Permanent table for holding the pricing attributes.
`QP_INT_PROFS_T`	8	Interface table for Profile name and value pairs per request. These profiles do not include only SITE-level updatable ones which Java Engine
`QP_INT_RLTD_LINES_T`	26	Permanent table for holding the relationships between request lines and between request lines and request line details.
`QP_JSESSIONS`	8
`QP_LIMITS`	46	This table table holds the definition of the limit, and the Promotion, Deal or modifier for which the limit is set.
`QP_LIMIT_ATTRIBUTES`	33	This table will hold the attributes for the limit. An attribute defines dimension for a limit or balance, e.g. customer, product, etc.
`QP_LIMIT_BALANCES`	44	QP_LIMIT_BALANCES holds the balances for a limit.
`QP_LIMIT_TRANSACTIONS`	36	This table holds details of all the transactions which consumed or increased the available balance on all the limits.
`QP_LIST_HEADERS_B`	60	QP_LIST_HEADERS_B stores the header information for all lists. List types can be, for example, Price Lists, Discount Lists or Promotions.
`QP_LIST_HEADERS_EBS_LOG`	38	Log table for the Euro conversion of QP_LIST_HEADERS_B table. This table is used only by the Euro Conversion concurrent program to store
`QP_LIST_HEADERS_TL`	11	QP_LIST_HEADERS_TL stores the translatable columns, name and description of the list, in each of the available languages in the database.
`QP_LIST_HEADER_PHASES`	9	This table stores all the current phases for a list header for Pricing Engine performance
`QP_LIST_LINES`	111	QP_LIST_LINES stores all list lines for lists in QP_LIST_HEADERS_B.
`QP_LIST_LINES_EBS_LOG`	39	Log table for the Euro conversion of QP_LIST_LINES table. This table is used only by the Euro Conversion concurrent program to store the m
`QP_LIST_LINES_TEMP`	97
`QP_NPREQ_LINE_PATRNS_T`	4
`QP_NPREQ_PATRN_PHASES_T`	6
`QP_PARAMETERS_B`	12	It stores the information for all pricing parameters. The parameters are defined for a level.
`QP_PARAMETERS_TL`	11	Stores the translatable columns, name and description of the paramter , in each of the available languages in the database.
`QP_PARAMETER_VALUES`	11	It stores all seeded and user assigned values for all parameters for a request type.
`QP_PATTERNS`	15
`QP_PATTERN_PHASES`	14
`QP_PB_INPUT_HEADERS_B`	40	Header Record of Price Book Request Input Criteria with non-transalateable columns
`QP_PB_INPUT_HEADERS_TL`	11	Header Record of Price Book Request Input Criteria with transalateable columns
`QP_PB_INPUT_LINES`	11	Line Level information of the Input Criteria in the Price Book request
`QP_PRC_CONTEXTS_B`	30	Stores Context Definition
`QP_PRC_CONTEXTS_TL`	13	This table stores context names and descriptions in various languages.
`QP_PREQ_LDETS_TMP_T1`	76
`QP_PREQ_LINES_TMP_T1`	73
`QP_PREQ_LINE_ATTRS_TMP_T`	37
`QP_PREQ_PATRN_QUAL_T`	34
`QP_PREQ_QUAL_TMP_T`	44
`QP_PRICE_BOOK_ATTRIBUTES`	16	This table stores: 1) the pricing attribute for the price list line (one of the detail lines) of each price book line of the Price Book that
`QP_PRICE_BOOK_BREAK_LINES`	18	This table stores the price break child lines for PBH type of price list lines and modifiers in the generated Price Book.
`QP_PRICE_BOOK_HEADERS_ALL_B`	22	Header Level Record of a Price Book containing non-translateable columns
`QP_PRICE_BOOK_HEADERS_TL`	10	Header Level Record of a Price Book containing translateable columns
`QP_PRICE_BOOK_LINES`	13	Line Summary Level Record of a Price Book
`QP_PRICE_BOOK_LINE_DETAILS`	18	Line Detail Level Record of a Price Book
`QP_PRICE_BOOK_MESSAGES`	12	This table stores the error and warning messages associatedat the Input Header record level, at the Price Book Header record level and at th
`QP_PRICE_FORMULAS_B`	28	QP_PRICE_FORMULAS_B stores the pricing formula header information.
`QP_PRICE_FORMULAS_TL`	11	This table stores the translatable columns, name & description of the pricing formulas, in each of the available languages in the database.
`QP_PRICE_FORMULA_LINES`	35	QP_PRICE_FORMULA_LINES stores each component that makes up the formula.
`QP_PRICE_REQ_SOURCES`	24	QP_PRICE_REQ_SOURCES stores the mapping between Pricing Request Types and Source Systems.
`QP_PRICING_ATTRIBUTES`	57	QP_PRICING_ATTRIBUTES stores product information and pricing attributes.
`QP_PRICING_ATT_EBS_LOG`	33	Log table for the Euro conversion of QP_PRICING_ATTRIBUTES table. This table is used only by the Euro Conversion concurrent program to stor
`QP_PRICING_PHASES`	39	QP_PRICING_PHASES stores all pricing phases.
`QP_PTE_REQUEST_TYPES_B`	32	Stores details of Request Types
`QP_PTE_REQUEST_TYPES_TL`	10	Stores description of Request types
`QP_PTE_SEGMENTS`	37	This table stores the attribute mapping methods, attribute mapping levels and various other information for a given attribute for all the P
`QP_PTE_SOURCE_SYSTEMS`	29	Stores details of Source systems
`QP_QUALIFIERS`	55	QP_QUALIFIERS stores qualifier attribute information.
`QP_QUALIFIERS_EBS_LOG`	35	Log table for the Euro conversion of QP_QUALIFIERS table. This table is used only by the Euro Conversion concurrent program to store the ma
`QP_QUALIFIERS_FWK_DUMMY`	56
`QP_QUALIFIER_RULES`	28	QP_QUALIFIER_RULES stores the header information for all qualifier rules
`QP_RLTD_MODIFIERS`	26	QP_RLTD_MODIFIERS stores the relationship between modifier lines.
`QP_RLTD_MOD_EBS_LOG`	31	Log table for the Euro conversion of QP_RLTD_MODIFIERS table. This table is used only by the Euro Conversion concurrent program to store th
`QP_SEGMENTS_B`	40	This table stores all the attribute details for all types of attributes. This table is a child table of QP_PRC_CONTEXTS_B.
`QP_SEGMENTS_TL`	13	Stores Attribute Names
`QP_SOURCESYSTEM_FNAREA_MAP`	31	Stores the functional areas for PTE/Source System Code combinations
`QP_UI_QUERIES_TL`	13	This table is used to save the query when user saves a query criteria on the Pricing Organizer.
`QP_UI_QUERY_COLUMNS`	11	This table is used to save the name-value pairs for columns (to be binded) being used in the query where clause, stored in master table qp_u
`QP_UPGRADE_ERRORS`	18	QP_UPGRADE_ERRORS holds details of the errors which occured in upgrading pricing data.
`QP_UPG_LINES_DISTRIBUTION`	7	This table stores information about which workers handle which list_lines, headers, formulas or price adjustments at the time of upgrade.