[Home] [Help] [Dependency Information]
Object Name: | EDWBV_ITEM_ITEM_CAT_LCV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ENG.EDWBV_ITEM_ITEM_CAT_LCV |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view contains categories controlled at the master organization level, as well as the category sets they belong to. It is the base view for its counterpart category collection source view EDW_ITEM_ITEM_CAT_LCV. The view is based on the following: MTL_CATEGORIES_KFV and MTL_CATEGORY_SETS.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
_KF:MCAT:MCAT:_EDW | CHAR | (16) | Key Flexfield tag | |
CATEGORY_PK | NUMBER | Yes | Unique identier of the category | |
INSTANCE | VARCHAR2 | (0) | Instance from which the record was collected | |
ALL_FK | CHAR | (3) | Foreign key to the top level in the item dimension | |
CATEGORY_DP | VARCHAR2 | (163) | Not currently used | |
NAME | VARCHAR2 | (163) | Category name | |
DESCRIPTION | VARCHAR2 | (240) | Category description | |
CATEGORY_SET_NAME | VARCHAR2 | (30) | Yes | Category set name |
CATEGORY_SET_ID | NUMBER | Yes | Category Set Surrogate Key | |
CATEGORY_ID | NUMBER | Yes | Internal id of the category | |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Standard Who column | ||
OPERATION_CODE | VARCHAR2 | (0) | Code used by the collection program to determine whether to insert/update/delete this record | |
DF:CAT:_EDW | CHAR | (26) | Descriptive Flexfield tag |
Cut, paste (and edit) the following text to query this object:
SELECT _KF:MCAT:MCAT:_EDW
, CATEGORY_PK
, INSTANCE
, ALL_FK
, CATEGORY_DP
, NAME
, DESCRIPTION
, CATEGORY_SET_NAME
, CATEGORY_SET_ID
, CATEGORY_ID
, CREATION_DATE
, LAST_UPDATE_DATE
, OPERATION_CODE
, DF:CAT:_EDW
FROM APPS.EDWBV_ITEM_ITEM_CAT_LCV;
|
|
|