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

VIEW: APPS.EDW_ITEM_ITEM_LCV

Object Details
Object Name: EDW_ITEM_ITEM_LCV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewENG.EDW_ITEM_ITEM_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 item level source view for master organization items. The view is based on EDWBV_ITEM_ITEM_LCV.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ITEM_NUMBER_PK VARCHAR2 (81)
Unique identifier of the item
INSTANCE VARCHAR2 (0)
Instance from which the record was collected
CATSET1_CATEGORY_FK CHAR (6)
Foreign key to the first level of the first item category hierarchy
CATSET2_CATEGORY_FK CHAR (6)
Foreign key to the first level of the second item category hierarchy
CATSET3_CATEGORY_FK CHAR (6)
Foreign key to first level of the third item category hierarchy
PRODUCT_GROUP_FK CHAR (6)
Foreign key to the product group level
ITEM_NUMBER_DP VARCHAR2 (45)
Not currently used
NAME VARCHAR2 (45)
Item name
ITEM_NAME VARCHAR2 (45)
Item name
DESCRIPTION VARCHAR2 (240)
Item description
ORGANIZATION_ID NUMBER
Yes Internal id of the item's organization
INVENTORY_ITEM_ID NUMBER
Yes Internal id of the item
LAST_UPDATE_DATE DATE
Yes Standard Who column
CREATION_DATE DATE
Yes 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
ITEM_TYPE VARCHAR2 (30)
Item Type
Query Text

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


SELECT ITEM_NUMBER_PK
,      INSTANCE
,      CATSET1_CATEGORY_FK
,      CATSET2_CATEGORY_FK
,      CATSET3_CATEGORY_FK
,      PRODUCT_GROUP_FK
,      ITEM_NUMBER_DP
,      NAME
,      ITEM_NAME
,      DESCRIPTION
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      OPERATION_CODE
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      ITEM_TYPE
FROM APPS.EDW_ITEM_ITEM_LCV;

Dependencies

[top of page]

APPS.EDW_ITEM_ITEM_LCV references the following:

SchemaAPPS
ViewEDWBV_ITEM_ITEM_LCV
APPS.EDW_ITEM_ITEM_LCV is referenced by following:

SchemaAPPS
Package BodyEDW_ITEMS_M_C - show dependent code