FND Design Data [Home] [Help]

View: EDW_ITEM_ITEMREV_LCV

Product: ENG - Engineering
Description: This view holds item revision level information
Implementation/DBA Data: ViewAPPS.EDW_ITEM_ITEMREV_LCV
View Text

SELECT ITEM_REVISION_PK
, INSTANCE
, ITEM_ORG_FK
, ITEM_REVISION_DP
, NAME
, ITEM_REVISION
, EFFECTIVE_DATE
, CREATION_DATE
, LAST_UPDATE_DATE
, OPERATION_CODE
, NULL
, NULL
, NULL
, NULL
, NULL
FROM EDWBV_ITEM_ITEMREV_LCV

Columns

Name
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