This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.
The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend
This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.
Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.
| Description: | OE_AGREEMENTS_B stores all information about pricing agreements. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OE_AGREEMENTS_B.PRICE_LIST_ID | QP_LIST_HEADERS_B |
| OE_AGREEMENTS_B.INVOICING_RULE_ID | RA_RULES |
| OE_AGREEMENTS_B.ACCOUNTING_RULE_ID | RA_RULES |
| OE_AGREEMENTS_B.SALESREP_ID | RA_SALESREPS_ALL |
| Foreign Key Column | Foreign Table |
|---|---|
| OE_HEADERS_IFACE_ALL.AGREEMENT_ID | OE_AGREEMENTS_B |
| OE_HEADER_ACKS.AGREEMENT_ID | OE_AGREEMENTS_B |
| OE_ORDER_HEADERS_ALL.AGREEMENT_ID | OE_AGREEMENTS_B |
| OE_ORDER_LINES_ALL.AGREEMENT_ID | OE_AGREEMENTS_B |
QP.OE_AGREEMENTS_B does not reference any database object
QP.OE_AGREEMENTS_B is referenced by following:
| Description: | OE_AGREEMENTS_TL stores the translatable column, i.e. name of the agreement, in each of the available languages in the database. |
|---|
QP.OE_AGREEMENTS_TL does not reference any database object
QP.OE_AGREEMENTS_TL is referenced by following:
| Description: |
|---|
QP.OE_ITEM_GROUPS does not reference any database object
QP.OE_ITEM_GROUPS is referenced by following:
| Description: |
|---|
QP.OE_ITEM_GROUP_LINES does not reference any database object
QP.OE_ITEM_GROUP_LINES is referenced by following:
| Description: |
|---|
QP.OE_PRC_COPY_PARAMETERS does not reference any database object
QP.OE_PRC_COPY_PARAMETERS is referenced by following:
| Description: |
|---|
QP.OE_PRC_RULE_LINE_VALUES does not reference any database object
QP.OE_PRC_RULE_LINE_VALUES is referenced by following:
| Description: |
|---|
QP.OE_PRICING_CONTRACTS does not reference any database object
QP.OE_PRICING_CONTRACTS is referenced by following:
| Description: |
|---|
QP.OE_PRICING_RULE_LINES does not reference any database object
QP.OE_PRICING_RULE_LINES is referenced by following:
| Description: |
|---|
QP.OE_RULE_FORMULA_COMPTS does not reference any database object
QP.OE_RULE_FORMULA_COMPTS is referenced by following:
| Description: | This table stores all product information and the pricing phase for all products used in modifiers of type Other Item Discount, Promotional goods or Related and modifiers in the Group of Lines level. |
|---|
QP.QP_ADV_MOD_PRODUCTS does not reference any database object
QP.QP_ADV_MOD_PRODUCTS is referenced by following:
| Description: | Stores the header information for the archive process |
|---|
QP.QP_ARCH_CRITERIA_HEADERS does not reference any database object
QP.QP_ARCH_CRITERIA_HEADERS is referenced by following:
| Description: | Stores criteria for archive process |
|---|
QP.QP_ARCH_CRITERIA_LINES does not reference any database object
QP.QP_ARCH_CRITERIA_LINES is referenced by following:
| Description: |
|---|
QP.QP_ARCH_LIST_HEADERS_B does not reference any database object
QP.QP_ARCH_LIST_HEADERS_B is referenced by following:
| Description: |
|---|
QP.QP_ARCH_LIST_HEADERS_TL does not reference any database object
QP.QP_ARCH_LIST_HEADERS_TL is referenced by following:
| Description: |
|---|
QP.QP_ARCH_LIST_LINES does not reference any database object
QP.QP_ARCH_LIST_LINES is referenced by following:
| Description: |
|---|
QP.QP_ARCH_PRICING_ATTRIBUTES does not reference any database object
QP.QP_ARCH_PRICING_ATTRIBUTES is referenced by following:
| Description: |
|---|
QP.QP_ARCH_QUALIFIERS does not reference any database object
QP.QP_ARCH_QUALIFIERS is referenced by following:
| Description: |
|---|
QP.QP_ARCH_RLTD_MODIFIERS does not reference any database object
QP.QP_ARCH_RLTD_MODIFIERS is referenced by following:
| Description: | Stores the count of archived records |
|---|
QP.QP_ARCH_ROW_COUNTS does not reference any database object
QP.QP_ARCH_ROW_COUNTS is referenced by following:
| Description: | QP_ATTRIBUTE_DEFNS is the table on which the Qualifier and Pricing Attribute Descriptive Flexfields are based. It is used for the entity and attribute definiton in attribute sourcing. |
|---|
QP.QP_ATTRIBUTE_DEFNS does not reference any database object
QP.QP_ATTRIBUTE_DEFNS is referenced by following:
| Description: |
|---|
QP.QP_ATTRIBUTE_GROUPS does not reference any database object
QP.QP_ATTRIBUTE_GROUPS is referenced by following:
| Description: | Stores attribute mapping rules rules defined for an attribute for each of the Pricing Transaction entity, it is linked to. |
|---|
QP.QP_ATTRIBUTE_SOURCING does not reference any database object
QP.QP_ATTRIBUTE_SOURCING is referenced by following:
| Description: |
|---|
QP.QP_CACHE_DO_SIZES does not reference any database object
QP.QP_CACHE_DO_SIZES is referenced by following:
| Description: |
|---|
QP.QP_CACHE_KEY_STATS does not reference any database object
QP.QP_CACHE_KEY_STATS is referenced by following:
| Description: |
|---|
QP.QP_CACHE_STATS does not reference any database object
QP.QP_CACHE_STATS is referenced by following:
| Description: | QP_COUPONS stores any Coupons which have been issued. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| QP_COUPONS.ISSUED_BY_MODIFIER_ID | QP_LIST_LINES |
QP.QP_COUPONS does not reference any database object
QP.QP_COUPONS is referenced by following:
| 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_ |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| QP_CURRENCY_DETAILS.CURRENCY_HEADER_ID | QP_CURRENCY_LISTS_B |
| QP_CURRENCY_DETAILS.PRICE_FORMULA_ID | QP_PRICE_FORMULAS_B |
| QP_CURRENCY_DETAILS.MARKUP_FORMULA_ID | QP_PRICE_FORMULAS_B |
| QP_CURRENCY_DETAILS.TO_CURRENCY_CODE | FND_CURRENCIES |
QP.QP_CURRENCY_DETAILS does not reference any database object
QP.QP_CURRENCY_DETAILS is referenced by following:
| Description: | QP_CURRENCY_LISTS_B stores the header information for all Multi-Currency lists. A Multi-Currency list is associated with standard and agreement price lists of same currency, if the advance pricing is used and multi-currency is installed. On |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| QP_CURRENCY_DETAILS.CURRENCY_HEADER_ID | QP_CURRENCY_LISTS_B |
| QP_CURRENCY_LISTS_TL.CURRENCY_HEADER_ID | QP_CURRENCY_LISTS_B |
| QP_LIST_HEADERS_B.CURRENCY_HEADER_ID | QP_CURRENCY_LISTS_B |
QP.QP_CURRENCY_LISTS_B does not reference any database object
QP.QP_CURRENCY_LISTS_B is referenced by following:
| Description: | QP_CURRENCY_LISTS_TL stores the translatable columns, name and description of themulti-currency list, in each of the available languages in the database. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| QP_CURRENCY_LISTS_TL.CURRENCY_HEADER_ID | QP_CURRENCY_LISTS_B |
QP.QP_CURRENCY_LISTS_TL does not reference any database object
QP.QP_CURRENCY_LISTS_TL is referenced by following:
| Description: | This table contains information about the formula step values which are inserted into the table QP_FORMULA_STEP_VALUES. The step values are inserted into the table during the evaluation of formula attached to the price lists. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| QP_DEBUG_FORMULA_STEP_VALUES.PRICE_FORMULA_ID | QP_PRICE_FORMULAS_B |
| QP_DEBUG_FORMULA_STEP_VALUES.LIST_HEADER_ID | QP_LIST_HEADERS_B |
| QP_DEBUG_FORMULA_STEP_VALUES.LIST_LINE_ID | QP_LIST_LINES |
QP.QP_DEBUG_FORMULA_STEP_VALUES does not reference any database object
QP.QP_DEBUG_FORMULA_STEP_VALUES is referenced by following:
| Description: | This table contains information about the Debug requests. |
|---|
QP.QP_DEBUG_REQ does not reference any database object
QP.QP_DEBUG_REQ is referenced by following:
| Description: | This table contains information about the line details being priced. It has adjustment and discount details for lines, including adjustments and discounts that the pricing engine eliminates. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| QP_DEBUG_REQ_LDETS.CREATED_FROM_LIST_HEADER_ID | QP_LIST_HEADERS_B |
| QP_DEBUG_REQ_LDETS.CREATED_FROM_LIST_LINE_ID | QP_LIST_LINES |
QP.QP_DEBUG_REQ_LDETS does not reference any database object
QP.QP_DEBUG_REQ_LDETS is referenced by following:
| Description: | This table contains information about the lines being priced. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| QP_DEBUG_REQ_LINES.PRICE_LIST_HEADER_ID | QP_LIST_HEADERS_B |
QP.QP_DEBUG_REQ_LINES does not reference any database object
QP.QP_DEBUG_REQ_LINES is referenced by following:
| Description: | This table contains information on the pricing attributes that the attribute mapping functionality passed to the pricing engine. The pricing engine uses these attributes to qualify a line or an order for benefits. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| QP_DEBUG_REQ_LINE_ATTRS.LIST_HEADER_ID | QP_LIST_HEADERS_B |
| QP_DEBUG_REQ_LINE_ATTRS.LIST_LINE_ID | QP_LIST_LINES |
QP.QP_DEBUG_REQ_LINE_ATTRS does not reference any database object
QP.QP_DEBUG_REQ_LINE_ATTRS is referenced by following:
| Description: | This table contains information about the related lines. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| QP_DEBUG_REQ_RLTD_LINES.LIST_LINE_ID | QP_LIST_LINES |
| QP_DEBUG_REQ_RLTD_LINES.RELATED_LIST_LINE_ID | QP_LIST_LINES |
QP.QP_DEBUG_REQ_RLTD_LINES does not reference any database object
QP.QP_DEBUG_REQ_RLTD_LINES is referenced by following:
| Description: | This table stores the Debug messages. |
|---|
QP.QP_DEBUG_TEXT does not reference any database object
QP.QP_DEBUG_TEXT is referenced by following:
| Description: | Used for upgrade purposes. QP_DISCOUNT_MAPPING table stores mapping information between the obsolete Order Entry pricing tables and the new pricing tables. |
|---|
QP.QP_DISCOUNT_MAPPING does not reference any database object
QP.QP_DISCOUNT_MAPPING is referenced by following:
| Description: | QP_EVENT_PHASES stores the mapping between pricing events and pricing phases. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| QP_EVENT_PHASES.PRICING_PHASE_ID | QP_PRICING_PHASES |
QP.QP_EVENT_PHASES does not reference any database object
QP.QP_EVENT_PHASES is referenced by following:
| Description: | This table stores all distinct combinations of list_header_id, pricing_attribute_context andpricing_attribute for the factor lists. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| QP_FACTOR_LIST_ATTRS.LIST_HEADER_ID | QP_LIST_HEADERS_B |
QP.QP_FACTOR_LIST_ATTRS does not reference any database object
QP.QP_FACTOR_LIST_ATTRS is referenced by following:
| Description: | 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 the mapping between the Original NCU column values and the corresponding Euro converted values. |
|---|
QP.QP_FORMULAS_EBS_LOG does not reference any database object
QP.QP_FORMULAS_EBS_LOG is referenced by following:
| Description: | Log table for the Euro conversion of QP_PRICE_FORMULA_LINES table. This table is used only by the Euro Conversion concurrent program to store the mapping between the Original NCU column values and the corresponding Euro converted values. |
|---|
QP.QP_FORMULA_LN_EBS_LOG does not reference any database object
QP.QP_FORMULA_LN_EBS_LOG is referenced by following:
| Description: |
|---|
QP.QP_FWK_DELAYED_REQUESTS does not reference any database object
QP.QP_FWK_DELAYED_REQUESTS is referenced by following:
| Description: | QP_GRANTS works with FND data security system to achieve data security for pricing entities. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| QP_GRANTS.INSTANCE_ID | QP_LIST_HEADERS_B |
QP.QP_GRANTS does not reference any database object
QP.QP_GRANTS is referenced by following:
| Description: | QP_INTERFACE_ERRORS stores errors that occur during the bulk import of pricing objects. |
|---|
QP.QP_INTERFACE_ERRORS does not reference any database object
QP.QP_INTERFACE_ERRORS is referenced by following:
| Description: | QP_LIST_HEADERS_B stores the header information for all lists. List types can be, for example, Price Lists, Discount Lists or Promotions. |
|---|
QP.QP_INTERFACE_LIST_HEADERS does not reference any database object
QP.QP_INTERFACE_LIST_HEADERS is referenced by following:
| Description: | QP_LIST_LINES stores all list lines for lists in QP_LIST_HEADERS_B. |
|---|
QP.QP_INTERFACE_LIST_LINES does not reference any database object
QP.QP_INTERFACE_LIST_LINES is referenced by following:
| Description: | QP_PRICING_ATTRIBUTES stores product information and pricing attributes. |
|---|
QP.QP_INTERFACE_PRICING_ATTRIBS does not reference any database object
QP.QP_INTERFACE_PRICING_ATTRIBS is referenced by following:
| Description: | QP_QUALIFIERS stores qualifier attribute information. |
|---|
QP.QP_INTERFACE_QUALIFIERS does not reference any database object
QP.QP_INTERFACE_QUALIFIERS is referenced by following:
| Description: | Permanent table for holding the formula step values |
|---|
QP.QP_INT_FML_STEP_VALS_T does not reference any database object
QP.QP_INT_FML_STEP_VALS_T is referenced by following:
| Description: | Permanent table for holding the details of the derivation of the base and adjusted prices. |
|---|
QP.QP_INT_LDETS_T does not reference any database object
QP.QP_INT_LDETS_T is referenced by following:
| Description: | Permanent table for holding the elements in the calling application that requires a base and adjusted price. |
|---|
QP.QP_INT_LINES_T does not reference any database object
QP.QP_INT_LINES_T is referenced by following:
| Description: | Permanent table for holding the pricing attributes. |
|---|
QP.QP_INT_LINE_ATTRS_T does not reference any database object
QP.QP_INT_LINE_ATTRS_T is referenced by following:
| Description: | Interface table for Profile name and value pairs per request. These profiles do not include only SITE-level updatable ones which Java Engine already cached. |
|---|
QP.QP_INT_PROFS_T does not reference any database object
QP.QP_INT_PROFS_T is referenced by following:
| Description: | Permanent table for holding the relationships between request lines and between request lines and request line details. |
|---|
QP.QP_INT_RLTD_LINES_T does not reference any database object
QP.QP_INT_RLTD_LINES_T is referenced by following:
| Description: |
|---|
QP.QP_JSESSIONS does not reference any database object
QP.QP_JSESSIONS is referenced by following:
| Description: | This table table holds the definition of the limit, and the Promotion, Deal or modifier for which the limit is set. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| QP_LIMITS.LIST_HEADER_ID | QP_LIST_HEADERS_B |
| QP_LIMITS.LIST_LINE_ID | QP_LIST_LINES |
| Foreign Key Column | Foreign Table |
|---|---|
| QP_LIMIT_ATTRIBUTES.LIMIT_ID | QP_LIMITS |
| QP_LIMIT_BALANCES.LIMIT_ID | QP_LIMITS |
QP.QP_LIMITS does not reference any database object
QP.QP_LIMITS is referenced by following:
| Description: | This table will hold the attributes for the limit. An attribute defines dimension for a limit or balance, e.g. customer, product, etc. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| QP_LIMIT_ATTRIBUTES.LIMIT_ID | QP_LIMITS |
QP.QP_LIMIT_ATTRIBUTES does not reference any database object
QP.QP_LIMIT_ATTRIBUTES is referenced by following:
| Description: | QP_LIMIT_BALANCES holds the balances for a limit. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| QP_LIMIT_BALANCES.LIMIT_ID | QP_LIMITS |
| Foreign Key Column | Foreign Table |
|---|---|
| QP_LIMIT_TRANSACTIONS.LIMIT_BALANCE_ID | QP_LIMIT_BALANCES |
QP.QP_LIMIT_BALANCES does not reference any database object
QP.QP_LIMIT_BALANCES is referenced by following:
| Description: | This table holds details of all the transactions which consumed or increased the available balance on all the limits. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| QP_LIMIT_TRANSACTIONS.LIMIT_BALANCE_ID | QP_LIMIT_BALANCES |
| QP_LIMIT_TRANSACTIONS.LIST_HEADER_ID | QP_LIST_HEADERS_B |
| QP_LIMIT_TRANSACTIONS.LIST_LINE_ID | QP_LIST_LINES |
QP.QP_LIMIT_TRANSACTIONS does not reference any database object
QP.QP_LIMIT_TRANSACTIONS is referenced by following:
| Description: | QP_LIST_HEADERS_B stores the header information for all lists. List types can be, for example, Price Lists, Discount Lists or Promotions. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| QP_LIST_HEADERS_B.CURRENCY_CODE | FND_CURRENCIES |
| QP_LIST_HEADERS_B.TERMS_ID | RA_TERMS_B |
| QP_LIST_HEADERS_B.PARENT_LIST_HEADER_ID | QP_LIST_HEADERS_B |
| QP_LIST_HEADERS_B.CURRENCY_HEADER_ID | QP_CURRENCY_LISTS_B |
| Foreign Key Column | Foreign Table |
|---|---|
| AMS_ACT_OFFERS.QP_LIST_HEADER_ID | QP_LIST_HEADERS_B |
| AMS_EVENT_OFFERS_ALL_B.PRICELIST_HEADER_ID | QP_LIST_HEADERS_B |
| AMS_OFFERS.QP_LIST_HEADER_ID | QP_LIST_HEADERS_B |
| AMS_OFFER_PARTIES.QP_LIST_HEADER_ID | QP_LIST_HEADERS_B |
| AMS_OFFER_PRODUCTS.QP_LIST_HEADER_ID | QP_LIST_HEADERS_B |
| AMS_PRICE_LIST_ATTRIBUTES.QP_LIST_HEADER_ID | QP_LIST_HEADERS_B |
| AS_PRICE_LISTS.PRICE_LIST_ID | QP_LIST_HEADERS_B |
| CSD_REPAIR_TYPES_B.PRICE_LIST_HEADER_ID | QP_LIST_HEADERS_B |
| CS_ESTIMATE_DETAILS.PRICE_LIST_HEADER_ID | QP_LIST_HEADERS_B |
| FTE_LANE_RATE_CHARTS.LIST_HEADER_ID | QP_LIST_HEADERS_B |
| FTE_LOAD_CHARGES.PRICING_LIST_HEADER_ID | QP_LIST_HEADERS_B |
| FTE_PRC_PARAMETERS.LIST_HEADER_ID | QP_LIST_HEADERS_B |
| JAI_CMN_CUS_ADDRESSES.PRICE_LIST_ID | QP_LIST_HEADERS_B |
| JAI_CMN_CUS_ADDRESSES.VAT_PRICE_LIST_ID | QP_LIST_HEADERS_B |
| JAI_CMN_VENDOR_SITES.PRICE_LIST_ID | QP_LIST_HEADERS_B |
| JAI_CMN_VENDOR_SITES.VAT_PRICE_LIST_ID | QP_LIST_HEADERS_B |
| JTF_MSITE_CURRENCIES.BIZPARTNER_PRC_LISTID | QP_LIST_HEADERS_B |
| JTF_MSITE_CURRENCIES.REGISTERED_PRC_LISTID | QP_LIST_HEADERS_B |
| JTF_MSITE_CURRENCIES.WALKIN_PRC_LISTID | QP_LIST_HEADERS_B |
| OE_AGREEMENTS_B.PRICE_LIST_ID | QP_LIST_HEADERS_B |
| OE_ORDER_HEADERS_ALL.PRICE_LIST_ID | QP_LIST_HEADERS_B |
| OE_ORDER_LINES_ALL.PRICE_LIST_ID | QP_LIST_HEADERS_B |
| OE_PRICE_ADJS_IFACE_ALL.LIST_HEADER_ID | QP_LIST_HEADERS_B |
| OE_PRICE_ADJUSTMENTS.LIST_HEADER_ID | QP_LIST_HEADERS_B |
| OE_TRANSACTION_TYPES_ALL.PRICE_LIST_ID | QP_LIST_HEADERS_B |
| OKC_K_LINES_B.PH_QP_REFERENCE_ID | QP_LIST_HEADERS_B |
| OZF_ACTIVITY_HL_DENORM.LIST_HEADER_ID | QP_LIST_HEADERS_B |
| OZF_OFFERS.QP_LIST_HEADER_ID | QP_LIST_HEADERS_B |
| OZF_OFFER_PARTIES.QP_LIST_HEADER_ID | QP_LIST_HEADERS_B |
| OZF_OFFER_PRODUCTS.QP_LIST_HEADER_ID | QP_LIST_HEADERS_B |
| QP_DEBUG_REQ_LDETS.CREATED_FROM_LIST_HEADER_ID | QP_LIST_HEADERS_B |
| QP_DEBUG_REQ_LINES.PRICE_LIST_HEADER_ID | QP_LIST_HEADERS_B |
| QP_DEBUG_REQ_LINE_ATTRS.LIST_HEADER_ID | QP_LIST_HEADERS_B |
| QP_DEBUG_FORMULA_STEP_VALUES.LIST_HEADER_ID | QP_LIST_HEADERS_B |
| QP_FACTOR_LIST_ATTRS.LIST_HEADER_ID | QP_LIST_HEADERS_B |
| QP_GRANTS.INSTANCE_ID | QP_LIST_HEADERS_B |
| QP_LIMITS.LIST_HEADER_ID | QP_LIST_HEADERS_B |
| QP_LIMIT_TRANSACTIONS.LIST_HEADER_ID | QP_LIST_HEADERS_B |
| QP_LIST_HEADERS_B.PARENT_LIST_HEADER_ID | QP_LIST_HEADERS_B |
| QP_LIST_HEADERS_TL.LIST_HEADER_ID | QP_LIST_HEADERS_B |
| QP_LIST_LINES.LIST_HEADER_ID | QP_LIST_HEADERS_B |
| QP_PRICE_FORMULA_LINES.PRICE_MODIFIER_LIST_ID | QP_LIST_HEADERS_B |
| QP_QUALIFIERS.LIST_HEADER_ID | QP_LIST_HEADERS_B |
QP.QP_LIST_HEADERS_B does not reference any database object
QP.QP_LIST_HEADERS_B is referenced by following:
| Description: | 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 the mapping between the Original NCU column values and the corresponding Euro converted values. For |
|---|
QP.QP_LIST_HEADERS_EBS_LOG does not reference any database object
QP.QP_LIST_HEADERS_EBS_LOG is referenced by following:
| Description: | QP_LIST_HEADERS_TL stores the translatable columns, name and description of the list, in each of the available languages in the database. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| QP_LIST_HEADERS_TL.LIST_HEADER_ID | QP_LIST_HEADERS_B |
QP.QP_LIST_HEADERS_TL does not reference any database object
QP.QP_LIST_HEADERS_TL is referenced by following:
| Description: | This table stores all the current phases for a list header for Pricing Engine performance |
|---|
QP.QP_LIST_HEADER_PHASES does not reference any database object
QP.QP_LIST_HEADER_PHASES is referenced by following:
| Description: | QP_LIST_LINES stores all list lines for lists in QP_LIST_HEADERS_B. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| QP_LIST_LINES.LIST_HEADER_ID | QP_LIST_HEADERS_B |
| QP_LIST_LINES.PRICING_PHASE_ID | QP_PRICING_PHASES |
|
QP_LIST_LINES.INVENTORY_ITEM_ID
QP_LIST_LINES.RELATED_ITEM_ID QP_LIST_LINES.RELATIONSHIP_TYPE_ID QP_LIST_LINES.ORGANIZATION_ID |
MTL_RELATED_ITEMS |
| QP_LIST_LINES.PRICE_BY_FORMULA_ID | QP_PRICE_FORMULAS_B |
| QP_LIST_LINES.GENERATE_USING_FORMULA_ID | QP_PRICE_FORMULAS_B |
| QP_LIST_LINES.BENEFIT_PRICE_LIST_LINE_ID | QP_LIST_LINES |
| Foreign Key Column | Foreign Table |
|---|---|
| AMS_EVENT_OFFERS_ALL_B.PRICELIST_LINE_ID | QP_LIST_LINES |
| AMS_RELATED_DEAL_LINES.MODIFIER_ID | QP_LIST_LINES |
| AMS_RELATED_DEAL_LINES.RELATED_MODIFIER_ID | QP_LIST_LINES |
| FTE_LOAD_CHARGES.PRICING_LIST_LINE_ID | QP_LIST_LINES |
| JTF_PC_HIERARCHIES.NODE_REFERENCE | QP_LIST_LINES |
| OE_PRICE_ADJS_IFACE_ALL.LIST_LINE_ID | QP_LIST_LINES |
| OE_PRICE_ADJUSTMENTS.LIST_LINE_ID | QP_LIST_LINES |
| OKC_K_LINES_B.PH_QP_REFERENCE_ID | QP_LIST_LINES |
| OZF_RELATED_DEAL_LINES.MODIFIER_ID | QP_LIST_LINES |
| OZF_RELATED_DEAL_LINES.RELATED_MODIFIER_ID | QP_LIST_LINES |
| QP_COUPONS.ISSUED_BY_MODIFIER_ID | QP_LIST_LINES |
| QP_DEBUG_REQ_LDETS.CREATED_FROM_LIST_LINE_ID | QP_LIST_LINES |
| QP_DEBUG_REQ_LINE_ATTRS.LIST_LINE_ID | QP_LIST_LINES |
| QP_DEBUG_REQ_RLTD_LINES.LIST_LINE_ID | QP_LIST_LINES |
| QP_DEBUG_REQ_RLTD_LINES.RELATED_LIST_LINE_ID | QP_LIST_LINES |
| QP_DEBUG_FORMULA_STEP_VALUES.LIST_LINE_ID | QP_LIST_LINES |
| QP_LIMITS.LIST_LINE_ID | QP_LIST_LINES |
| QP_LIMIT_TRANSACTIONS.LIST_LINE_ID | QP_LIST_LINES |
| QP_LIST_LINES.BENEFIT_PRICE_LIST_LINE_ID | QP_LIST_LINES |
| QP_PRICING_ATTRIBUTES.LIST_LINE_ID | QP_LIST_LINES |
| QP_LIST_LINES | |
| QP_QUALIFIERS.LIST_LINE_ID | QP_LIST_LINES |
| QP_RLTD_MODIFIERS.FROM_RLTD_MODIFIER_ID | QP_LIST_LINES |
| QP_RLTD_MODIFIERS.TO_RLTD_MODIFIER_ID | QP_LIST_LINES |
| XNC_BILLING_SYSTEM_MAP.LIST_LINE_ID | QP_LIST_LINES |
QP.QP_LIST_LINES does not reference any database object
QP.QP_LIST_LINES is referenced by following:
| Description: | 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 mapping between the Original NCU column values and the corresponding Euro converted values. |
|---|
QP.QP_LIST_LINES_EBS_LOG does not reference any database object
QP.QP_LIST_LINES_EBS_LOG is referenced by following:
| Description: |
|---|
QP.QP_LIST_LINES_TEMP does not reference any database object
QP.QP_LIST_LINES_TEMP is referenced by following:
| Description: |
|---|
QP.QP_NPREQ_LINE_PATRNS_T does not reference any database object
QP.QP_NPREQ_LINE_PATRNS_T is referenced by following:
| Description: |
|---|
QP.QP_NPREQ_PATRN_PHASES_T does not reference any database object
QP.QP_NPREQ_PATRN_PHASES_T is referenced by following:
| Description: | It stores the information for all pricing parameters. The parameters are defined for a level. |
|---|
QP.QP_PARAMETERS_B does not reference any database object
QP.QP_PARAMETERS_B is referenced by following:
| Description: | Stores the translatable columns, name and description of the paramter , in each of the available languages in the database. |
|---|
QP.QP_PARAMETERS_TL does not reference any database object
QP.QP_PARAMETERS_TL is referenced by following:
| Description: | It stores all seeded and user assigned values for all parameters for a request type. |
|---|
QP.QP_PARAMETER_VALUES does not reference any database object
QP.QP_PARAMETER_VALUES is referenced by following:
| Description: |
|---|
QP.QP_PATTERNS does not reference any database object
QP.QP_PATTERNS is referenced by following:
| Description: |
|---|
QP.QP_PATTERN_PHASES does not reference any database object
QP.QP_PATTERN_PHASES is referenced by following:
| Description: | Header Record of Price Book Request Input Criteria with non-transalateable columns |
|---|
QP.QP_PB_INPUT_HEADERS_B does not reference any database object
QP.QP_PB_INPUT_HEADERS_B is referenced by following:
| Description: | Header Record of Price Book Request Input Criteria with transalateable columns |
|---|
QP.QP_PB_INPUT_HEADERS_TL does not reference any database object
QP.QP_PB_INPUT_HEADERS_TL is referenced by following:
| Description: | Line Level information of the Input Criteria in the Price Book request |
|---|
QP.QP_PB_INPUT_LINES does not reference any database object
QP.QP_PB_INPUT_LINES is referenced by following:
| Description: | Stores Context Definition |
|---|
QP.QP_PRC_CONTEXTS_B does not reference any database object
QP.QP_PRC_CONTEXTS_B is referenced by following:
| Description: | This table stores context names and descriptions in various languages. |
|---|
QP.QP_PRC_CONTEXTS_TL does not reference any database object
QP.QP_PRC_CONTEXTS_TL is referenced by following:
| Description: |
|---|
QP.QP_PREQ_LDETS_TMP_T1 does not reference any database object
QP.QP_PREQ_LDETS_TMP_T1 is referenced by following:
| Description: |
|---|
QP.QP_PREQ_LINES_TMP_T1 does not reference any database object
QP.QP_PREQ_LINES_TMP_T1 is referenced by following:
| Description: |
|---|
QP.QP_PREQ_LINE_ATTRS_TMP_T does not reference any database object
QP.QP_PREQ_LINE_ATTRS_TMP_T is referenced by following:
| Description: |
|---|
QP.QP_PREQ_PATRN_QUAL_T does not reference any database object
QP.QP_PREQ_PATRN_QUAL_T is referenced by following:
| Description: |
|---|
QP.QP_PREQ_QUAL_TMP_T does not reference any database object
QP.QP_PREQ_QUAL_TMP_T is referenced by following:
| Description: | 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 has been generated. Pricing Context, Attribute and Values are stored to preserve the actual pricin |
|---|
QP.QP_PRICE_BOOK_ATTRIBUTES does not reference any database object
QP.QP_PRICE_BOOK_ATTRIBUTES is referenced by following:
| Description: | This table stores the price break child lines for PBH type of price list lines and modifiers in the generated Price Book. |
|---|
QP.QP_PRICE_BOOK_BREAK_LINES does not reference any database object
QP.QP_PRICE_BOOK_BREAK_LINES is referenced by following:
| Description: | Header Level Record of a Price Book containing non-translateable columns |
|---|
QP.QP_PRICE_BOOK_HEADERS_ALL_B does not reference any database object
QP.QP_PRICE_BOOK_HEADERS_ALL_B is referenced by following:
| Description: | Header Level Record of a Price Book containing translateable columns |
|---|
QP.QP_PRICE_BOOK_HEADERS_TL does not reference any database object
QP.QP_PRICE_BOOK_HEADERS_TL is referenced by following:
| Description: | Line Summary Level Record of a Price Book |
|---|
QP.QP_PRICE_BOOK_LINES does not reference any database object
QP.QP_PRICE_BOOK_LINES is referenced by following:
| Description: | Line Detail Level Record of a Price Book |
|---|
QP.QP_PRICE_BOOK_LINE_DETAILS does not reference any database object
QP.QP_PRICE_BOOK_LINE_DETAILS is referenced by following:
| Description: | This table stores the error and warning messages associatedat the Input Header record level, at the Price Book Header record level and at the Price Book Line record level. |
|---|
QP.QP_PRICE_BOOK_MESSAGES does not reference any database object
QP.QP_PRICE_BOOK_MESSAGES is referenced by following:
| Description: | QP_PRICE_FORMULAS_B stores the pricing formula header information. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| QP_CURRENCY_DETAILS.PRICE_FORMULA_ID | QP_PRICE_FORMULAS_B |
| QP_CURRENCY_DETAILS.MARKUP_FORMULA_ID | QP_PRICE_FORMULAS_B |
| QP_DEBUG_FORMULA_STEP_VALUES.PRICE_FORMULA_ID | QP_PRICE_FORMULAS_B |
| QP_LIST_LINES.PRICE_BY_FORMULA_ID | QP_PRICE_FORMULAS_B |
| QP_LIST_LINES.GENERATE_USING_FORMULA_ID | QP_PRICE_FORMULAS_B |
| QP_PRICE_FORMULAS_TL.PRICE_FORMULA_ID | QP_PRICE_FORMULAS_B |
| QP_PRICE_FORMULAS_B |
QP.QP_PRICE_FORMULAS_B does not reference any database object
QP.QP_PRICE_FORMULAS_B is referenced by following:
| Description: | This table stores the translatable columns, name & description of the pricing formulas, in each of the available languages in the database. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| QP_PRICE_FORMULAS_TL.PRICE_FORMULA_ID | QP_PRICE_FORMULAS_B |
QP.QP_PRICE_FORMULAS_TL does not reference any database object
QP.QP_PRICE_FORMULAS_TL is referenced by following:
| Description: | QP_PRICE_FORMULA_LINES stores each component that makes up the formula. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| QP_PRICE_FORMULA_LINES.PRICE_MODIFIER_LIST_ID | QP_LIST_HEADERS_B |
QP.QP_PRICE_FORMULA_LINES does not reference any database object
QP.QP_PRICE_FORMULA_LINES is referenced by following:
| Description: | QP_PRICE_REQ_SOURCES stores the mapping between Pricing Request Types and Source Systems. |
|---|
QP.QP_PRICE_REQ_SOURCES does not reference any database object
QP.QP_PRICE_REQ_SOURCES is referenced by following:
| Description: | QP_PRICING_ATTRIBUTES stores product information and pricing attributes. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| QP_PRICING_ATTRIBUTES.LIST_LINE_ID | QP_LIST_LINES |
QP.QP_PRICING_ATTRIBUTES does not reference any database object
QP.QP_PRICING_ATTRIBUTES is referenced by following:
| Description: | Log table for the Euro conversion of QP_PRICING_ATTRIBUTES table. This table is used only by the Euro Conversion concurrent program to store the mapping between the Original NCU column values and the corresponding Euro converted values. |
|---|
QP.QP_PRICING_ATT_EBS_LOG does not reference any database object
QP.QP_PRICING_ATT_EBS_LOG is referenced by following:
| Description: | QP_PRICING_PHASES stores all pricing phases. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| FTE_LOAD_CHARGES.PRICING_PHASE_ID | QP_PRICING_PHASES |
| QP_EVENT_PHASES.PRICING_PHASE_ID | QP_PRICING_PHASES |
| QP_LIST_LINES.PRICING_PHASE_ID | QP_PRICING_PHASES |
QP.QP_PRICING_PHASES does not reference any database object
QP.QP_PRICING_PHASES is referenced by following:
| Description: | Stores details of Request Types |
|---|
QP.QP_PTE_REQUEST_TYPES_B does not reference any database object
QP.QP_PTE_REQUEST_TYPES_B is referenced by following:
| Description: | Stores description of Request types |
|---|
QP.QP_PTE_REQUEST_TYPES_TL does not reference any database object
QP.QP_PTE_REQUEST_TYPES_TL is referenced by following:
| Description: | This table stores the attribute mapping methods, attribute mapping levels and various other information for a given attribute for all the Pricing Transaction Entities that it is linked to. |
|---|
QP.QP_PTE_SEGMENTS does not reference any database object
QP.QP_PTE_SEGMENTS is referenced by following:
| Description: | Stores details of Source systems |
|---|
QP.QP_PTE_SOURCE_SYSTEMS does not reference any database object
QP.QP_PTE_SOURCE_SYSTEMS is referenced by following:
| Description: | QP_QUALIFIERS stores qualifier attribute information. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| QP_QUALIFIERS.LIST_HEADER_ID | QP_LIST_HEADERS_B |
| QP_QUALIFIERS.LIST_LINE_ID | QP_LIST_LINES |
| QP_QUALIFIERS.CREATED_FROM_RULE_ID | QP_QUALIFIER_RULES |
QP.QP_QUALIFIERS does not reference any database object
QP.QP_QUALIFIERS is referenced by following:
| Description: | Log table for the Euro conversion of QP_QUALIFIERS table. This table is used only by the Euro Conversion concurrent program to store the mapping between the Original NCU column values and the corresponding Euro converted values. |
|---|
QP.QP_QUALIFIERS_EBS_LOG does not reference any database object
QP.QP_QUALIFIERS_EBS_LOG is referenced by following:
| Description: |
|---|
QP.QP_QUALIFIERS_FWK_DUMMY does not reference any database object
QP.QP_QUALIFIERS_FWK_DUMMY is referenced by following:
| Description: | QP_QUALIFIER_RULES stores the header information for all qualifier rules |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| QP_QUALIFIER_RULES | |
| QP_QUALIFIERS.CREATED_FROM_RULE_ID | QP_QUALIFIER_RULES |
QP.QP_QUALIFIER_RULES does not reference any database object
QP.QP_QUALIFIER_RULES is referenced by following:
| Description: | QP_RLTD_MODIFIERS stores the relationship between modifier lines. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| QP_RLTD_MODIFIERS.FROM_RLTD_MODIFIER_ID | QP_LIST_LINES |
| QP_RLTD_MODIFIERS.TO_RLTD_MODIFIER_ID | QP_LIST_LINES |
QP.QP_RLTD_MODIFIERS does not reference any database object
QP.QP_RLTD_MODIFIERS is referenced by following:
| Description: | Log table for the Euro conversion of QP_RLTD_MODIFIERS table. This table is used only by the Euro Conversion concurrent program to store the mapping between the Original NCU column values and the corresponding Euro converted values. |
|---|
QP.QP_RLTD_MOD_EBS_LOG does not reference any database object
QP.QP_RLTD_MOD_EBS_LOG is referenced by following:
| Description: | This table stores all the attribute details for all types of attributes. This table is a child table of QP_PRC_CONTEXTS_B. |
|---|
QP.QP_SEGMENTS_B does not reference any database object
QP.QP_SEGMENTS_B is referenced by following:
| Description: | Stores Attribute Names |
|---|
QP.QP_SEGMENTS_TL does not reference any database object
QP.QP_SEGMENTS_TL is referenced by following:
| Description: | Stores the functional areas for PTE/Source System Code combinations |
|---|
QP.QP_SOURCESYSTEM_FNAREA_MAP does not reference any database object
QP.QP_SOURCESYSTEM_FNAREA_MAP is referenced by following:
| Description: | This table is used to save the query when user saves a query criteria on the Pricing Organizer. |
|---|
QP.QP_UI_QUERIES_TL does not reference any database object
QP.QP_UI_QUERIES_TL is referenced by following:
| Description: | 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_ui_queries_tl |
|---|
QP.QP_UI_QUERY_COLUMNS does not reference any database object
QP.QP_UI_QUERY_COLUMNS is referenced by following:
| Description: | QP_UPGRADE_ERRORS holds details of the errors which occured in upgrading pricing data. |
|---|
QP.QP_UPGRADE_ERRORS does not reference any database object
QP.QP_UPGRADE_ERRORS is referenced by following:
| Description: | This table stores information about which workers handle which list_lines, headers, formulas or price adjustments at the time of upgrade. |
|---|
QP.QP_UPG_LINES_DISTRIBUTION does not reference any database object
QP.QP_UPG_LINES_DISTRIBUTION is referenced by following:
APPS.OE_AGREEMENTS_V is not referenced by any database object
APPS.OE_DISCOUNTS_V is not referenced by any database object
APPS.OE_DISCOUNT_BY_V is not referenced by any database object
APPS.OE_DISCOUNT_CUSTOMERS_V is not referenced by any database object
APPS.OE_DISCOUNT_LINES_115_V is not referenced by any database object
APPS.OE_DISCOUNT_LINES_V is not referenced by any database object
APPS.OE_PRC_CONTRACT_LINES_V is not referenced by any database object
APPS.OE_PRICE_BREAK_LINES_V is not referenced by any database object
APPS.OE_PRICE_LISTS_115_VL is not referenced by any database object
APPS.OE_PRICE_LISTS_ACTIVE_V is not referenced by any database object
APPS.OE_PRICE_LISTS_V is not referenced by any database object
APPS.OE_PRICE_LISTS_VL is not referenced by any database object
APPS.OE_PRICING_CONTRACTS_V is not referenced by any database object
APPS.OE_PRICING_ENTITIES_V is not referenced by any database object
APPS.QPBV_ADDITIONAL_BUY_PRODUCTS is not referenced by any database object
APPS.QPBV_AGREEMENTS is not referenced by any database object
APPS.QPBV_COUPON_ISSUES is not referenced by any database object
APPS.QPBV_FACTOR_ASSO_PRICING_ATTRS is not referenced by any database object
APPS.QPBV_FACTOR_BASE_PRICING_ATTRS is not referenced by any database object
APPS.QPBV_FORMULA_HEADERS is not referenced by any database object
APPS.QPBV_FORMULA_LINES is not referenced by any database object
APPS.QPBV_ITEM_UPGRADES is not referenced by any database object
APPS.QPBV_MODIFIER_HEADERS is not referenced by any database object
APPS.QPBV_MODIFIER_LINES is not referenced by any database object
APPS.QPBV_PRICE_BREAK_LINES is not referenced by any database object
APPS.QPBV_PRICE_LISTS is not referenced by any database object
APPS.QPBV_PRICE_LIST_LINES is not referenced by any database object
APPS.QPBV_PRICING_ATTRIBUTES is not referenced by any database object
APPS.QPBV_PRODUCTS is not referenced by any database object
APPS.QPBV_PRODUCT_BENEFITS is not referenced by any database object
APPS.QPBV_PRODUCT_EXCLUSIONS is not referenced by any database object
APPS.QPBV_PROMOTION_HEADERS is not referenced by any database object
APPS.QPBV_QUALIFIERS is not referenced by any database object
APPS.QPBV_SECONDARY_PRICE_LISTS is not referenced by any database object
APPS.QPBV_TERM_SUBSTITUTIONS is not referenced by any database object
APPS.QPFV_ADDITIONAL_BUY_PRODUCTS is not referenced by any database object
APPS.QPFV_AGREEMENTS is not referenced by any database object
APPS.QPFV_COUPON_ISSUES is not referenced by any database object
APPS.QPFV_FACTOR_ASSO_PRICING_ATTRS is not referenced by any database object
APPS.QPFV_FACTOR_BASE_PRICING_ATTRS is not referenced by any database object
APPS.QPFV_FORMULA_LINES is not referenced by any database object
APPS.QPFV_ITEM_UPGRADES is not referenced by any database object
APPS.QPFV_MODIFIER_HEADERS is not referenced by any database object
APPS.QPFV_MODIFIER_LINES is not referenced by any database object
APPS.QPFV_PRICE_BREAK_LINES is not referenced by any database object
APPS.QPFV_PRICE_LISTS is not referenced by any database object
APPS.QPFV_PRICE_LIST_LINES is not referenced by any database object
APPS.QPFV_PRICING_ATTRIBUTES is not referenced by any database object
APPS.QPFV_PRODUCTS is not referenced by any database object
APPS.QPFV_PRODUCT_BENEFITS is not referenced by any database object
APPS.QPFV_PRODUCT_EXCLUSIONS is not referenced by any database object
APPS.QPFV_PROMOTION_HEADERS is not referenced by any database object
APPS.QPFV_QUALIFIERS is not referenced by any database object
APPS.QPFV_TERM_SUBSTITUTIONS is not referenced by any database object
APPS.QP_AGR_PRICE_BREAK_LINES_V is not referenced by any database object
APPS.QP_CURRENCY_LISTS_VL is not referenced by any database object
APPS.QP_CUSTOMERS_V is not referenced by any database object
APPS.QP_CUSTOMER_ITEMS_V is not referenced by any database object
APPS.QP_DEBUG_FORMULA_STEP_VALUES_V is not referenced by any database object
APPS.QP_DEBUG_REQ_LDETS_V is not referenced by any database object
APPS.QP_DEBUG_REQ_LINES_V is not referenced by any database object
APPS.QP_DEBUG_REQ_PRI_LINE_ATTRS_V is not referenced by any database object
APPS.QP_DEBUG_REQ_PROD_LINE_ATTRS_V is not referenced by any database object
APPS.QP_DEBUG_REQ_QUAL_LINE_ATTRS_V is not referenced by any database object
APPS.QP_DEBUG_REQ_RLTD_LINES_V is not referenced by any database object
APPS.QP_DEBUG_REQ_V is not referenced by any database object
APPS.QP_ENTITY_PARAMETERS_V is not referenced by any database object
APPS.QP_FORMULA_STEP_VALUES_TMP is not referenced by any database object
APPS.QP_HDR_LVL_QUAL_V is not referenced by any database object
APPS.QP_HDR_PRICING_ATTRIBS_V is not referenced by any database object
APPS.QP_HDR_QUALIF_ATTRIBS_V is not referenced by any database object
APPS.QP_LDETS_V is not referenced by any database object
APPS.QP_LIMITS_V is not referenced by any database object
APPS.QP_LIMIT_ATTRIBUTES_V is not referenced by any database object
APPS.QP_LIMIT_BALANCES_V is not referenced by any database object
APPS.QP_LINES_SUMMARY_V is not referenced by any database object
APPS.QP_LINE_LVL_QUAL_V is not referenced by any database object
APPS.QP_LINE_PRICING_ATTRIBS_V is not referenced by any database object
APPS.QP_LINE_QUALIF_ATTRIBS_V is not referenced by any database object
APPS.QP_LISTS_V is not referenced by any database object
APPS.QP_LIST_ATTRIBUTES_V is not referenced by any database object
APPS.QP_LIST_HEADERS_V is not referenced by any database object
APPS.QP_LIST_LINES_V is not referenced by any database object
APPS.QP_LIST_SUMMARY_VL is not referenced by any database object
APPS.QP_MODIFIER_SUMMARY_V is not referenced by any database object
APPS.QP_PREQ_LDETS_TMP is not referenced by any database object
APPS.QP_PREQ_LINES_TMP is not referenced by any database object
APPS.QP_PREQ_LINE_ATTRS_FORMULA_TMP is not referenced by any database object
APPS.QP_PREQ_LINE_ATTRS_TMP is not referenced by any database object
APPS.QP_PREQ_QUAL_TMP is not referenced by any database object
APPS.QP_PREQ_RLTD_LINES_TMP is not referenced by any database object
APPS.QP_PRICE_BREAKS_V is not referenced by any database object
APPS.QP_PRICE_FACTORS_V is not referenced by any database object
APPS.QP_PRICE_REQ_SOURCES_V is not referenced by any database object
APPS.QP_PRICING_ATTR_GET_V is not referenced by any database object
APPS.QP_PRICING_ATTR_V is not referenced by any database object
APPS.QP_PTE_CONTEXT_TYPES_V is not referenced by any database object
APPS.QP_PTE_REQUEST_TYPES_V is not referenced by any database object
APPS.QP_QUALIFIER_CONTEXT_V is not referenced by any database object
APPS.QP_QUALIFIER_RULES_V is not referenced by any database object
APPS.QP_SECONDARY_PRICE_LISTS_V is not referenced by any database object
APPS.QP_SHIP_TO_ORGS_V is not referenced by any database object
|
|
|
| Copyright (c) 2001 - 2005, Oracle | - Use Restricted by Contract |