[Home] [Help]
[Dependency Information]
Object Name: | AMS_MTL_CATEGORIES_DENORM_B |
---|---|
Object Type: | TABLE |
Owner: | AMS |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
AMS_MTL_DENORM_CATEGORIES_B stores the inventory categories with concatenated description and concatenated ids, which are used in category assignment screen. This denorm table has been created to improve the performance of the screen.
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AMS_MTL_CATEGORY_DENORM_B_U1 | NORMAL | UNIQUE |
![]() |
![]() |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CATEGORY_ID | NUMBER | Yes | Category Identifier | |
STRUCTURE_ID | NUMBER | Yes | Structure Identifier | |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard WHO Column | |
CREATION_DATE | DATE | Yes | Standard WHO Column | |
CREATED_BY | NUMBER | Yes | Standard WHO Column | |
LAST_UPDATE_LOGIN | NUMBER | Standard WHO Column | ||
CONCATENATED_IDS | VARCHAR2 | (4000) | Concatenated category identifier | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
Cut, paste (and edit) the following text to query this object:
SELECT CATEGORY_ID
, STRUCTURE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, CONCATENATED_IDS
, SECURITY_GROUP_ID
FROM AMS.AMS_MTL_CATEGORIES_DENORM_B;
AMS.AMS_MTL_CATEGORIES_DENORM_B does not reference any database object
AMS.AMS_MTL_CATEGORIES_DENORM_B is referenced by following:
|
|
|