QP_PRICING_GUIDELINES_ALL_B
QP_PRICING_GUIDELINES_ALL_B to store guidelines header row
Details
-
Schema: FUSION
-
Object owner: QP
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
QP_PRICING_GUIDELINES_ALL_B_PK |
PRICING_GUIDELINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PRICING_GUIDELINE_ID | NUMBER | 18 | Yes | Primary Key of the table and is a system generated unique sequence number | |
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| GUIDELINE_TYPE_CODE | VARCHAR2 | 30 | Yes | Valid values based on Lookup type QP_GUIDE_TYPES, Indicates if Price Element or Pricing Total | |
| COMPONENT_ELEMENT_CODE | VARCHAR2 | 30 | 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 | ||
| COMPONENT_TOTAL_ID | NUMBER | 18 | Indicates the component to which the Guideline applies. It would be a total definition which is guideline enabled. | ||
| OPERATOR_CODE | VARCHAR2 | 30 | Operator Code and wil have values like <= or >= and is based on FND lookup for OPERATOR TYPES | ||
| CALCULATION_TYPE_CODE | VARCHAR2 | 30 | Based on lookup type QP_GUIDE_CALC_TYPES | ||
| START_DATE | TIMESTAMP | Yes | User requested effective start date | ||
| CALCULATION_COMPONENT_CODE | VARCHAR2 | 30 | Component the guideline will evaluate against. This attribute will only contain valid Price Elements | ||
| CALCULATION_COMPONENT_TOTAL_ID | NUMBER | 18 | Indicates the total component to which the Guideline will evaluate against. It would be a total definition which is guideline enabled. | ||
| 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. | ||
| END_DATE | TIMESTAMP | User requested effective end date | |||
| STATUS_CODE | VARCHAR2 | 30 | Yes | Based on lookup for approval status codes. In V1.1, this list will include In Progress and Approved and the UI prompt will be ???Status??? | |
| GUIDELINE_VIOLATION_TYPE_CODE | VARCHAR2 | 30 | Overall Exception Type of the Pricing Guideline. Based on lookup type QP_GUIDE_EXCEPTION_TYPES. At run time, value on the child (i.e. charge guideline or total rule) overrides this when defined. If child does not have it then this prevails. | ||
| 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_guidelines_tl | qp_pricing_guidelines_all_b | PRICING_GUIDELINE_ID |
| qp_pricing_guidelines_all_b_st | qp_pricing_guidelines_all_b | PRICING_GUIDELINE_ID |
| qp_total_guidelines | qp_pricing_guidelines_all_b | PRICING_GUIDELINE_ID |
| qp_charge_guidelines | qp_pricing_guidelines_all_b | PRICING_GUIDELINE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| QP_PRICING_GUIDELINES_B_PK | Unique | FUSION_TS_TX_IDX | PRICING_GUIDELINE_ID |