EGP_ITEM_REVISIONS_TL_V
Details
-
Schema: FUSION
-
Object owner: EGP
-
Object type: VIEW
Columns
Name |
---|
REVISION_ID LANGUAGE SOURCE_LANG DESCRIPTION OBJECT_VERSION_NUMBER CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN |
Query
SQL_Statement |
---|
SELECT T.REVISION_ID, T.LANGUAGE, T.SOURCE_LANG, T.DESCRIPTION, T.OBJECT_VERSION_NUMBER, T.CREATION_DATE, T.CREATED_BY, T.LAST_UPDATE_DATE, T.LAST_UPDATED_BY, T.LAST_UPDATE_LOGIN FROM EGP_ITEM_REVISIONS_TL T, EGP_ITEM_ORG_ASSOCIATIONS IO, EGP_ITEM_REVISIONS_B B WHERE B.REVISION_ID = T.REVISION_ID AND B.INVENTORY_ITEM_ID = IO.INVENTORY_ITEM_ID AND B.ORGANIZATION_ID = IO.ITEM_DEFINITION_ORG_ID AND IO.CHANGE_ROW_FLAG='N' |