EGP_SYSTEM_ITEMS_TL_ALL_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 T.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, EGP_SYSTEM_ITEMS_B B WHERE T.INVENTORY_ITEM_ID = IO.INVENTORY_ITEM_ID AND IO.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND IO.ITEM_DEFINITION_ORG_ID = B.INVENTORY_ORGANIZATION_ID AND B.ORGANIZATION_ID = T.ORGANIZATION_ID AND ((B.VERSION_ID = -1 AND EXISTS (SELECT NULL FROM INV_ORG_PARAMETERS INV WHERE INV.ORGANIZATION_ID = IO.ORGANIZATION_ID))OR (B.ORGANIZATION_ID= IO.ORGANIZATION_ID AND T.ORGANIZATION_ID = IO.ORGANIZATION_ID)) |