EGP_ITEM_TEXT_VL

Details

• Schema: FUSION

• Object owner: EGP

• Object type: VIEW

Columns

Name
ID_TYPE ITEM_ID ITEM_CODE ORG_ID TEXT ITEM_CATALOG_GROUP_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE PROGRAM_NAME PROGRAM_APP_NAME SYNC_PENDING

Query

SQL_Statement

SELECT EITTL.ID_TYPE ID_TYPE, EITTL.ITEM_ID ITEM_ID, EITTL.ITEM_CODE ITEM_CODE, IOP.organization_id AS ORG_ID, EITTL.TEXT TEXT, EITTL.ITEM_CATALOG_GROUP_ID ITEM_CATALOG_GROUP_ID, EITTL.CREATED_BY CREATED_BY, EITTL.CREATION_DATE CREATION_DATE, EITTL.LAST_UPDATED_BY LAST_UPDATED_BY, EITTL.LAST_UPDATE_DATE LAST_UPDATE_DATE, EITTL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, EITTL.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, EITTL.REQUEST_ID REQUEST_ID, EITTL.JOB_DEFINITION_NAME JOB_DEFINITION_NAME, EITTL.JOB_DEFINITION_PACKAGE JOB_DEFINITION_PACKAGE, EITTL.PROGRAM_NAME PROGRAM_NAME, EITTL.PROGRAM_APP_NAME PROGRAM_APP_NAME, EITTL.SYNC_PENDING SYNC_PENDING FROM EGP_ITEM_TEXT_TL EITTL, egp_item_org_associations EIOA, inv_org_parameters IOP WHERE EITTL.item_id = EIOA.inventory_item_id AND EITTL.org_id = IOP.item_definition_org_id AND EIOA.organization_id = IOP.organization_id AND EITTL.LANGUAGE = USERENV('LANG')