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

VIEW: APPS.EDW_ITEM_ITEM_CAT_LCV

Object Details
Object Name: EDW_ITEM_ITEM_CAT_LCV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewENG.EDW_ITEM_ITEM_CAT_LCV
Subobject Name:
Status: VALID

View Type

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


This view is the category source view for categories controlled at the master organization level. The view is based on EDWBV_ITEM_ITEM_CAT_LCV.


[View Source]

Columns
Name Datatype Length Mandatory Comments
CATEGORY_PK NUMBER
Yes Unique identifier for the category
INSTANCE VARCHAR2 (0)
Instance from which the record was collected
ALL_FK CHAR (3)
Foreign key to the top level of 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 for 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
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_ITEM_CAT_LCV;

Dependencies

[top of page]

APPS.EDW_ITEM_ITEM_CAT_LCV references the following:

SchemaAPPS
ViewEDWBV_ITEM_ITEM_CAT_LCV
APPS.EDW_ITEM_ITEM_CAT_LCV is referenced by following:

SchemaAPPS
Package BodyEDW_ITEMS_M_C - show dependent code