QP_PRICE_LIST_ITEMS
This table stores the price list items.
Details
-
Schema: FUSION
-
Object owner: QP
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
QP_PRICE_LIST_ITEMS_PK |
PRICE_LIST_ITEM_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PRICE_LIST_ITEM_ID | NUMBER | 18 | Yes | Indicates the Primay Key of price list items | |
| STRUCTURE_DATE | TIMESTAMP | Indicates the structure date of the price list items | |||
| SERVICE_DURATION | NUMBER | Indicates the service duration of an item | |||
| SERVICE_DURATION_PERIOD_CODE | VARCHAR2 | 10 | Indicates the service duration period UOM of a price list item | ||
| PRICE_LIST_ID | NUMBER | 18 | Yes | Mandatory, FK to Price List Header entity. | |
| LINE_TYPE_CODE | VARCHAR2 | 30 | Yes | The Line Action Code to be used. This is defaulted form the header. eg: BUY, SELL, RETURN etc | |
| ITEM_LEVEL_CODE | VARCHAR2 | 30 | Yes | Can be one of the following:ITEM (Item), ITEM_CATEGORY (Item Category) orPRODUCT_GROUP (Product Group).Based on LookupVO where LookupType = PRODUCT_TYPE_CODE | |
| ITEM_ID | NUMBER | 18 | Indicates the Unique Product Identifier | ||
| PRICING_UOM_CODE | VARCHAR2 | 3 | Yes | Indicates the unit of measure code for the Item | |
| PRIMARY_PRICING_UOM_FLAG | VARCHAR2 | 30 | Flag that indicates if the pricing UOM associated with this line is the default UOM for this product | ||
| CATALOG_ID | NUMBER | 18 | Id of the catalog when ITEM_LEVEL_CODE='ITEM_CATEGORY' | ||
| 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. | |
| 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_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP1 | 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. | |||
| SUPPORTED_CHANNELS | VARCHAR2 | 100 | Indicates the channels that can access the price list item record. The list of values include RW for Redwood, etc. This indicates that this price list item can only be accessed through the Redwood UI. All other channels like ADF UI, FBDI, ADFDI will filter the data and not have access to it. | ||
| ENTITY_APPRV_STATUS_CODE | VARCHAR2 | 30 | Approval status of the item on the price list. Values are ORA_DRAFT, ORA_PENDING_APPROVAL, ORA_APPROVED, or ORA_REJECTED. Values come from the ORA_QP_ENTITY_APPROVAL_STATUS lookup. An empty value oF NULL means Approved. | ||
| DELETED_FLAG | VARCHAR2 | 1 | Contains Y or N. Y: Record is marked for deletion and will be deleted upon approval. N: Not marked for deletion. An empty value or NULL means N. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| QP_PRICE_LIST_ITEMS | qp_price_lists_all_b | PRICE_LIST_ID |
| qp_price_list_covered_items | qp_price_list_items | PRICE_LIST_ITEM_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| QP_PRICE_LIST_ITEMS_N1 | Non Unique | FUSION_TS_TX_IDX | ITEM_ID, PRICE_LIST_ID, LINE_TYPE_CODE, ITEM_LEVEL_CODE, PRICING_UOM_CODE, ENTITY_APPRV_STATUS_CODE |
| QP_PRICE_LIST_ITEMS_PK | Unique | FUSION_TS_TX_IDX | PRICE_LIST_ITEM_ID |
| QP_PRICE_LIST_ITEMS_U1 | Unique | FUSION_TS_TX_IDX | PRICE_LIST_ID, LINE_TYPE_CODE, ITEM_LEVEL_CODE, ITEM_ID, PRICING_UOM_CODE, SERVICE_DURATION, SERVICE_DURATION_PERIOD_CODE, ENTITY_APPRV_STATUS_CODE |