EGP_ITEM_TEXT_TL_V

Details

• Schema: FUSION

• Object owner: EGP

• Object type: VIEW

Columns

Name
ID_TYPE ITEM_ID ITEM_CODE ORG_ID LANGUAGE SOURCE_LANG 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, EIOA.inventory_item_id AS item_id, EITTL.item_code, EIOA.organization_id AS ORG_ID, EITTL.LANGUAGE, EITTL.source_lang, EITTL.text, EITTL.item_catalog_group_id, EITTL.created_by, EITTL.creation_date, EITTL.last_updated_by, EITTL.last_update_date, EITTL.last_update_login, EITTL.object_version_number, EITTL.request_id, EITTL.job_definition_name, EITTL.job_definition_package, EITTL.program_name, EITTL.program_app_name, EITTL.sync_pending FROM egp_item_text_tl EITTL, egp_item_org_associations EIOA WHERE EITTL.item_id = EIOA.inventory_item_id AND EITTL.org_id = EIOA.item_definition_org_id