Many of the standard object definitions have a category table associated with them - for example, WH_CONTACT_CATEGORIES. These tables are documented together with the other tables related to the object definition.
Similarly, the design categories that are applicable to a specific custom object definition are found in table WH_PROJECT_CATEGORIES, documented with the other Project tables.
The category values that are actually assigned to specific records are found in table WH_CATEGEORIES, shown below. That table "flattens" the category tree structure by providing a single row containing up to 10 levels of nesting for a given category.
WH_CATEGORIES
Column Name |
Oracle Data Type |
MSSQL Data Type |
OBJECT_PRIMARY_KEY |
NUMBER |
INT |
OBJECT_ENTITY_CODE |
VARCHAR2(4) |
VARCHAR(4) |
OBJECT_IS_EMBEDDED |
VARCHAR2(5) |
VARCHAR(5) |
OBJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
CATEGORY_PRIMARY_KEY |
NUMBER |
INT |
CATEGORY_NAME |
VARCHAR2(50) |
VARCHAR(50) |
CATEGORY_DISPLAY_ORDER |
NUMBER) |
INT |
CATEGORY_TREE_POSITION |
VARCHAR2(250) |
VARCHAR(250) |
CATEGORY_IS_ACTIVE |
NUMBER |
INT |
CATEGORY_FULL_NAME |
VARCHAR2(1000) |
VARCHAR(1000) |
CATEGORY_LEVEL_01 |
VARCHAR2(50) |
VARCHAR(50) |
CATEGORY_LEVEL_02 |
VARCHAR2(50) |
VARCHAR(50) |
CATEGORY_LEVEL_03 |
VARCHAR2(50) |
VARCHAR(50) |
CATEGORY_LEVEL_04 |
VARCHAR2(50) |
VARCHAR(50) |
CATEGORY_LEVEL_05 |
VARCHAR2(50) |
VARCHAR(50) |
CATEGORY_LEVEL_06 |
VARCHAR2(50) |
VARCHAR(50) |
CATEGORY_LEVEL_07 |
VARCHAR2(50) |
VARCHAR(50) |
CATEGORY_LEVEL_08 |
VARCHAR2(50) |
VARCHAR(50) |
CATEGORY_LEVEL_09 |
VARCHAR2(50) |
VARCHAR(50) |
CATEGORY_LEVEL_10 |
VARCHAR2(50) |
VARCHAR(50) |
WH_CURRENCIES
Column Name |
Oracle Data Type |
MSSQL Data Type |
CURRENCY_CODE |
VARCHAR2(3) |
VARCHAR(3) |
CURRENCY_EXCHANGE_RATE |
NUMBER |
INT |
CURRENCY_NAME |
VARCHAR2(50) |
VARCHAR(50) |
CURRENCY_SYMBOL |
VARCHAR2(2) |
VARCHAR(2) |
LAST_MODIFIED_ON |
DATE |
DATETIME |
WH_LOOKUP_TABLE_ITEMS
Column Name |
Oracle Data Type |
MSSQL Data Type |
TABLE_PRIMARY_KEY |
NUMBER |
INT |
TABLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
TABLE_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
TABLE_VERSION |
NUMBER |
INT |
ITEM_PRIMARY_KEY |
NUMBER |
INT |
ITEM_NAME |
VARCHAR2(50) |
VARCHAR(50) |
ITEM_DISPLAY_ORDER |
NUMBER |
INT |
ITEM_TREE_POSITION |
VARCHAR2(250) |
VARCHAR(250) |
ITEM_IS_ACTIVE |
VARCHAR2(10) |
VARCHAR(10) |
ITEM_PARENT_PRIMARY_KEY |
NUMBER |
INT |
ITEM_NAME_FULL |
VARCHAR2(700) |
VARCHAR(700) |
ITEM_LEVEL_01 |
VARCHAR2(50) |
VARCHAR(50) |
ITEM_LEVEL_02 |
VARCHAR2(50) |
VARCHAR(50) |
ITEM_LEVEL_03 |
VARCHAR2(50) |
VARCHAR(50) |
ITEM_LEVEL_04 |
VARCHAR2(50) |
VARCHAR(50) |
ITEM_LEVEL_05 |
VARCHAR2(50) |
VARCHAR(50) |
ITEM_LEVEL_06 |
VARCHAR2(50) |
VARCHAR(50) |
ITEM_LEVEL_07 |
VARCHAR2(50) |
VARCHAR(50) |
ITEM_LEVEL_08 |
VARCHAR2(50) |
VARCHAR(50) |
ITEM_LEVEL_09 |
VARCHAR2(50) |
VARCHAR(50) |
ITEM_LEVEL_10 |
VARCHAR2(50) |
VARCHAR(50) |
