[Home] [Help]
View: EDW_ITEM_ITEM_CAT_LCV
Product: | ENG - Engineering |
Description: | This view holds item level category information |
Implementation/DBA Data: |
APPS.EDW_ITEM_ITEM_CAT_LCV
|
View Text
SELECT CATEGORY_PK
, INSTANCE
, ALL_FK
, CATEGORY_DP
, NAME
, DESCRIPTION
, CATEGORY_SET_NAME
, FUNCTIONAL_AREA_ID
, CATEGORY_ID
, CREATION_DATE
, LAST_UPDATE_DATE
, OPERATION_CODE
, NULL
, NULL
, NULL
, NULL
, NULL
FROM EDWBV_ITEM_ITEM_CAT_LCV
Columns
Name |
CATEGORY_PK |
INSTANCE |
ALL_FK |
CATEGORY_DP |
NAME |
DESCRIPTION |
CATEGORY_SET_NAME |
FUNCTIONAL_AREA_ID |
CATEGORY_ID |
CREATION_DATE |
LAST_UPDATE_DATE |
OPERATION_CODE |
USER_ATTRIBUTE1 |
USER_ATTRIBUTE2 |
USER_ATTRIBUTE3 |
USER_ATTRIBUTE4 |
USER_ATTRIBUTE5 |