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

VIEW: APPS.EDWBV_ITEM_ITEMREV_LCV

Object Details
Object Name: EDWBV_ITEM_ITEMREV_LCV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewENG.EDWBV_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 contains item revisions, as well as corresponding parent organization item associations. It is the base view for its counterpart organization item revision collection source view EDW_ITEM_ITEMREV_LCV. The view is based on the following: MTL_SYSTEM_ITEMS_KFV, MTL_ITEM_REVISIONS and MTL_PARAMETERS.


[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 item organization 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 item 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
_DF:REV:_EDW CHAR (30)
Descriptive flexfield tag
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
,      _DF:REV:_EDW
FROM APPS.EDWBV_ITEM_ITEMREV_LCV;

Dependencies

[top of page]

APPS.EDWBV_ITEM_ITEMREV_LCV references the following:

SchemaAPPS
SynonymEDW_LOCAL_INSTANCE
SynonymMTL_ITEM_REVISIONS
SynonymMTL_PARAMETERS
SynonymMTL_SYSTEM_ITEMS_KFV
APPS.EDWBV_ITEM_ITEMREV_LCV is referenced by following:

SchemaAPPS
ViewEDW_ITEM_ITEMREV_LCV