QP_PROMOTIONS_B
Base table that contains the details about the pricing promotion header like number, type, status, effectivity dates, etc.
Details
-
Schema: FUSION
-
Object owner: QP
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
QP_PROMOTIONS_B_PK |
PROMOTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PROMOTION_ID | NUMBER | 18 | Yes | Value that uniquely identifies the pricing promotion. Oracle Fusion Pricing automatically assigns this value. | |
| PROMOTION_NUMBER | VARCHAR2 | 30 | Yes | Indicates the number for the pricing promotion. Oracle Fusion Pricing automatically assigns this value but it can be updated by the user during the create process. It is unique across the application. | |
| PROMOTION_TYPE_CODE | VARCHAR2 | 30 | Yes | Abbreviation that indicates the type of promotion. Valid values include ORA_SALES, etc. A list of accepted values is defined in the lookup type ORA_QP_PROMOTION_TYPE. The default value is ORA_SALES. | |
| PROMOTION_APPLICATION_MODE | VARCHAR2 | 30 | Yes | Abbreviation that indicates the application mode of promotion. Valid values include ORA_AUTOMATIC, etc. A list of accepted values is defined in the lookup type ORA_QP_PROMOTION_MODE. The default value is ORA_AUTOMATIC. | |
| APPROVAL_STATUS_CODE | VARCHAR2 | 30 | Yes | Abbreviation that indicates the status of the promotion. Valid values include ORA_APPROVED and ORA_DRAFT. A list of accepted values is defined in the lookup type ORA_QP_PROMOTION_STATUS. | |
| START_DATE | TIMESTAMP | Yes | Date on which the pricing promotion goes into effect. Start Date is mandatory during the create process. | ||
| END_DATE | TIMESTAMP | Date after which the pricing promotion expires. End Date is optional. | |||
| DYNAMIC_RULE_ID | NUMBER | 18 | Indicates the unique identifier of dynamic rule that is attached to this promotion. | ||
| 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. | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| 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. | |
| PROMOTION_CODE | VARCHAR2 | 100 | Identifies the promotion code for a promotion. | ||
| EXCLUDE_FROM_RECOMMENDATIONS | VARCHAR2 | 1 | Contains Y, N, or a null value. Y: exclude the promotion from the recommendations. N: include the promotion in the recommendations. A null value is interpreted as N. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| qp_promotion_lines_b | qp_promotions_b | PROMOTION_ID |
| qp_promotions_tl | qp_promotions_b | PROMOTION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| QP_PROMOTIONS_B_N1 | Non Unique | FUSION_TS_TX_IDX | PROMOTION_TYPE_CODE, PROMOTION_APPLICATION_MODE, APPROVAL_STATUS_CODE |
| QP_PROMOTIONS_B_N2 | Non Unique | FUSION_TS_TX_IDX | START_DATE, END_DATE |
| QP_PROMOTIONS_B_N3 | Non Unique | FUSION_TS_TX_IDX | PROMOTION_CODE |
| QP_PROMOTIONS_B_U1 | Unique | FUSION_TS_TX_IDX | PROMOTION_ID |
| QP_PROMOTIONS_B_U2 | Unique | FUSION_TS_TX_IDX | PROMOTION_NUMBER |