This table contains products hierarchy
Module:
USAGE_CODE, PRODUCT_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
PRODUCT_ID | NUMBER | 38 | 0 | True | Product Identifier for the Product Group | ||
USAGE_CODE | VARCHAR2 | 32 | True | Usage Code for the product . For eg Service,Base or HRHELPDESK | |||
SOURCE_RECORD_ID | VARCHAR2 | 128 | System Generated Key | ||||
INVENTORY_ITEM_ID | NUMBER | 38 | 0 | INVENTORY_ITEM_ID | DW_CXS_PRODUCT_D | INVENTORY_ITEM_ID | |
INVENTORY_ORGANIZATION_ID | NUMBER | 38 | 0 | INV_ORG_ID | |||
PRODUCT_GROUP_ID | NUMBER | 38 | 0 | Product Group Identifier, derived field. | DW_CXS_PRODUCT_GROUP_D | PRODUCT_GROUP_ID | |
ITEM_OR_PRODUCT_GROUP | VARCHAR2 | 16 | Is this a item or a product group | ||||
FIRST_PRODUCT_GROUP_ID | NUMBER | 38 | 0 | Root or the topmost item in the product hierarchy | DW_CXS_PRODUCT_GROUP_D | PRODUCT_GROUP_ID | |
LAST_PRODUCT_GROUP_ID | NUMBER | 38 | 0 | Current product id in discussion. This is used in generating the entire product hiearchy from root to the current product | DW_CXS_PRODUCT_GROUP_D | PRODUCT_GROUP_ID | |
FIXED_HIERARCHY_LEVEL | NUMBER | 38 | 0 | This gives the distance from the root to the current product | |||
PRODUCT_GROUP_LEVEL_0_TO_TOP | NUMBER | 38 | 0 | Root item or product group | DW_CXS_PRODUCT_GROUP_D | PRODUCT_GROUP_ID | |
PRODUCT_GROUP_LEVEL_1_TO_TOP | NUMBER | 38 | 0 | Child Item at denormalized distance 1 | DW_CXS_PRODUCT_GROUP_D | PRODUCT_GROUP_ID | |
PRODUCT_GROUP_LEVEL_2_TO_TOP | NUMBER | 38 | 0 | Child Item at denormalized distance 2 | DW_CXS_PRODUCT_GROUP_D | PRODUCT_GROUP_ID | |
PRODUCT_GROUP_LEVEL_3_TO_TOP | NUMBER | 38 | 0 | Child Item at denormalized distance 3 | DW_CXS_PRODUCT_GROUP_D | PRODUCT_GROUP_ID | |
PRODUCT_GROUP_LEVEL_4_TO_TOP | NUMBER | 38 | 0 | Child Item at denormalized distance 4 | DW_CXS_PRODUCT_GROUP_D | PRODUCT_GROUP_ID | |
PRODUCT_GROUP_LEVEL_5_TO_TOP | NUMBER | 38 | 0 | Child Item at denormalized distance 5 | DW_CXS_PRODUCT_GROUP_D | PRODUCT_GROUP_ID | |
PRODUCT_GROUP_LEVEL_6_TO_TOP | NUMBER | 38 | 0 | Child Item at denormalized distance 6 | DW_CXS_PRODUCT_GROUP_D | PRODUCT_GROUP_ID | |
PRODUCT_GROUP_LEVEL_7_TO_TOP | NUMBER | 38 | 0 | Child Item at denormalized distance 7 | DW_CXS_PRODUCT_GROUP_D | PRODUCT_GROUP_ID | |
PRODUCT_GROUP_LEVEL_8_TO_TOP | NUMBER | 38 | 0 | Child Item at denormalized distance 8 | DW_CXS_PRODUCT_GROUP_D | PRODUCT_GROUP_ID | |
PRODUCT_GROUP_LEVEL_9_TO_TOP | NUMBER | 38 | 0 | Child Item at denormalized distance 9 | DW_CXS_PRODUCT_GROUP_D | PRODUCT_GROUP_ID | |
PRODUCT_GROUP_LEVEL_10_TO_TOP | NUMBER | 38 | 0 | Child Item at denormalized distance 10 | DW_CXS_PRODUCT_GROUP_D | PRODUCT_GROUP_ID | |
PRODUCT_GROUP_LEVEL_11_TO_TOP | NUMBER | 38 | 0 | Child Item at denormalized distance 11 | DW_CXS_PRODUCT_GROUP_D | PRODUCT_GROUP_ID | |
PRODUCT_GROUP_LEVEL_12_TO_TOP | NUMBER | 38 | 0 | Child Item at denormalized distance 12 | DW_CXS_PRODUCT_GROUP_D | PRODUCT_GROUP_ID | |
PRODUCT_GROUP_LEVEL_13_TO_TOP | NUMBER | 38 | 0 | Child Item at denormalized distance 13 | DW_CXS_PRODUCT_GROUP_D | PRODUCT_GROUP_ID | |
PRODUCT_GROUP_LEVEL_14_TO_TOP | NUMBER | 38 | 0 | Child Item at denormalized distance 14 | DW_CXS_PRODUCT_GROUP_D | PRODUCT_GROUP_ID | |
RELATIONSHIP_ACTIVE_FLAG | VARCHAR2 | 16 | REL_ACTIVE_FLAG | ||||
RELATIONSHIP_START_DATE | TIMESTAMP | REL_START_DATE | |||||
RELATIONSHIP_END_DATE | TIMESTAMP | REL_END_DATE | |||||
CREATED_BY | VARCHAR2 | 128 | Who column: indicates the date and time of the creation of the row. | ||||
CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||||
LAST_UPDATED_BY | VARCHAR2 | 128 | Who column: indicates the user who last updated the row. | ||||
LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||||
LAST_UPDATE_LOGIN | VARCHAR2 | 64 | Who column: indicates the session login associated to the user who last updated the row. |
Copyright © 2019, 2023, Oracle and/or its affiliates.