EGP_SYSTEM_ITEMS_TL_V
Details
-
Schema: FUSION
-
Object owner: EGP
-
Object type: VIEW
Columns
Name |
---|
INVENTORY_ITEM_ID HTML_LONG_DESCRIPTION ORGANIZATION_ID LANGUAGE SOURCE_LANG DESCRIPTION LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN LONG_DESCRIPTION OBJECT_VERSION_NUMBER TEMPLATE_NAME |
Query
SQL_Statement |
---|
SELECT IO.INVENTORY_ITEM_ID, T.HTML_LONG_DESCRIPTION, IO.ORGANIZATION_ID, T.LANGUAGE, T.SOURCE_LANG, T.DESCRIPTION, T.LAST_UPDATE_DATE, T.LAST_UPDATED_BY, T.CREATION_DATE, T.CREATED_BY, T.LAST_UPDATE_LOGIN, T.LONG_DESCRIPTION, T.OBJECT_VERSION_NUMBER, T.TEMPLATE_NAME FROM EGP_SYSTEM_ITEMS_TL T, EGP_ITEM_ORG_ASSOCIATIONS IO WHERE T.INVENTORY_ITEM_ID = IO.INVENTORY_ITEM_ID AND T.ORGANIZATION_ID = IO.ITEM_DEFINITION_ORG_ID |