1. Tables and Views for SCM
  2. EGP_SYSTEM_ITEMS_TL_V

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