DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.EDW_ITEM_VBH_CAT_LCV

Object Details
Object Name: EDW_ITEM_VBH_CAT_LCV
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view holds category information for the VBH hierarchy set


[View Source]

Columns
Name Datatype Length Mandatory Comments
CATEGORY_PK NUMBER
Yes Unique Identifier for category
INSTANCE VARCHAR2 (0)
Instance in which the record was collected
ALL_FK CHAR (3)
Foreign key to the 'ALL' level
CATEGORY_DP VARCHAR2 (40)
Not Currently Used.
NAME VARCHAR2 (40)
Product category name
DESCRIPTION VARCHAR2 (240)
Product category description
CATEGORY_SET_NAME VARCHAR2 (30) Yes Product category set name
CATEGORY_SET_ID NUMBER
Yes Unique Identifier for Product category set
CATEGORY_ID NUMBER
Yes Unique identifier for product category
CREATION_DATE DATE
Yes Standard WHO column
LAST_UPDATE_DATE DATE

Standard WHO column
OPERATION_CODE VARCHAR2 (0)
Operation code
USER_ATTRIBUTE1 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE2 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE3 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE4 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE5 VARCHAR2 (0)
User defined attribute
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CATEGORY_PK
,      INSTANCE
,      ALL_FK
,      CATEGORY_DP
,      NAME
,      DESCRIPTION
,      CATEGORY_SET_NAME
,      CATEGORY_SET_ID
,      CATEGORY_ID
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      OPERATION_CODE
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
FROM APPS.EDW_ITEM_VBH_CAT_LCV;

Dependencies

[top of page]

APPS.EDW_ITEM_VBH_CAT_LCV references the following:

SchemaAPPS
SynonymMTL_CATEGORIES_B
SynonymMTL_CATEGORIES_TL
SynonymMTL_CATEGORY_SETS_B
SynonymMTL_CATEGORY_SETS_TL

APPS.EDW_ITEM_VBH_CAT_LCV is not referenced by any database object