EGP_ITEM_REVISIONS_TL

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

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'

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'