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

VIEW: APPS.EDW_ITEM_ITEMREV_LCV

Object Details
Object Name: EDW_ITEM_ITEMREV_LCV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewENG.EDW_ITEM_ITEMREV_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 revision level source view for item revisions. The view is based on EDWBV_ITEM_ITEMREV_LCV.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ITEM_REVISION_PK VARCHAR2 (116)
Unique identifier of the item revision
INSTANCE VARCHAR2 (30)
Instance from which the record was collected
ITEM_ORG_FK VARCHAR2 (112)
Foreign key to the organization item level
ITEM_REVISION_DP VARCHAR2 (49)
Not currently used
NAME VARCHAR2 (49)
Item revision
ITEM_REVISION VARCHAR2 (49)
Item revision
EFFECTIVE_DATE DATE
Yes Effective date of the revision
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATE_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
Query Text

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


SELECT ITEM_REVISION_PK
,      INSTANCE
,      ITEM_ORG_FK
,      ITEM_REVISION_DP
,      NAME
,      ITEM_REVISION
,      EFFECTIVE_DATE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      OPERATION_CODE
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
FROM APPS.EDW_ITEM_ITEMREV_LCV;

Dependencies

[top of page]

APPS.EDW_ITEM_ITEMREV_LCV references the following:

SchemaAPPS
ViewEDWBV_ITEM_ITEMREV_LCV
APPS.EDW_ITEM_ITEMREV_LCV is referenced by following:

SchemaAPPS
Package BodyEDW_ITEMS_M_C - show dependent code