QP_PRICING_GUIDE_COMPONENTS
This table is the child of Pricing Guideline Header (qp_pricing_guidelines_vl) and it stores the definition of the guidelines i.e. components, calculation type and calc component based on which guideline type it is.
Details
-
Schema: FUSION
-
Object owner: QP
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
QP_PRICING_GUIDE_COMP_PK |
PRICING_GUIDE_COMPONENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PRICING_GUIDE_COMPONENT_ID | NUMBER | 18 | Yes | Primary Key of the table and it???s a system generated unique number. | |
| PRICING_GUIDELINE_ID | NUMBER | 18 | Yes | Foreign Key of the parent table and it???s a system generated unique number. | |
| GUIDELINE_TYPE_CODE | VARCHAR2 | 30 | Yes | Valid values based on Lookup type QP_GUIDE_TYPES.Indicates if Price Charge or Pricing Total. This will be defaulted from the parent table and cannot be changed in this entity. | |
| COMPONENT_CODE | VARCHAR2 | 30 | Yes | Indicates the component to which the Guideline applies. Can be either a price element like List Price, etc. or a Pricing total depending on the guideline type code | |
| OPERATOR_CODE | VARCHAR2 | 30 | Yes | Operator Code and wil have values like <= or >= and is based on FND lookup for OPERATOR TYPES | |
| CALCULATION_TYPE_CODE | VARCHAR2 | 30 | Yes | Based on lookup type QP_GUIDE_CALC_TYPES | |
| CALCULATION_COMPONENT_CODE | VARCHAR2 | 30 | Component the guideline will evaluate against. This attribute will only contain valid Price Elements | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Currency for Pricing Guideline, based on FND Currencies | ||
| GUIDELINE_STMT_MESSAGE_NAME | VARCHAR2 | 30 | Stores the appropriate/pre-determined pricing message name based on the values for Component, Calculation Type, Calculation Component fields. List of values for messages comprises the seeded pricing messages mentioned in the seed data section. | ||
| GUIDELINE_MATRIX_ID | NUMBER | 18 | Guideline Matrix Id, which is a foreign Key to the ZOC Dynamic Matrix table and will be required for defining attribute based matrix. | ||
| GUIDELINE_RULE_TYPE_CODE | VARCHAR2 | 30 | Guideline Rule Type Code and it is based on lookup type ???QP_GUIDE_RULE_TYPES??? and the values are Simple (based on Guideline Rule defined) and Complex (based on Dynamic Matrix Rule) | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| QP_PRICING_GUIDE_COMPONENTS | qp_pricing_guidelines_all_b | PRICING_GUIDELINE_ID |
| qp_pricing_guideline_items | qp_pricing_guide_components | PRICING_GUIDE_COMPONENT_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| QP_PRICING_GUIDE_COMP_N1 | Non Unique | FUSION_TS_TX_IDX | GUIDELINE_MATRIX_ID |
| QP_PRICING_GUIDE_COMP_PK | Unique | FUSION_TS_TX_IDX | PRICING_GUIDE_COMPONENT_ID |
| QP_PRICING_GUIDE_COMP_U1 | Unique | Default | PRICING_GUIDELINE_ID, COMPONENT_CODE, CALCULATION_TYPE_CODE, CALCULATION_COMPONENT_CODE |