DW_CXS_PRODUCT_GROUP_CF_DN_DH

This table contains products hierarchy

Details

Module:

Key Columns

USAGE_CODE, PRODUCT_ID

Columns

Columns
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.