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') |