VIEW: APPS.EGO_ITEM_TRANS_ATTRS_VL

Source

View Text - Preformatted

SELECT 
  b.extension_id, b.inventory_item_id,b.organization_id,b.revision_id,b.c_ext_attr,b.n_ext_attr,b.uom_ext_attr,
  b.d_ext_attr,tl.source_lang,tl."LANGUAGE",b.attr_group_id,tl.tl_ext_attr,b.created_by,b.creation_date,
  b.last_updated_by,b.last_update_date,b.last_update_login,
  b.program_application_id,
  b.program_id,
  b.program_update_date,
  b.request_id    
  FROM ego_item_trans_attrs_b b, ego_item_trans_attrs_tl tl
  WHERE B.EXTENSION_ID = TL.EXTENSION_ID AND TL.LANGUAGE = userenv('LANG')
   

View Text - HTML Formatted

SELECT B.EXTENSION_ID
, B.INVENTORY_ITEM_ID
, B.ORGANIZATION_ID
, B.REVISION_ID
, B.C_EXT_ATTR
, B.N_EXT_ATTR
, B.UOM_EXT_ATTR
, B.D_EXT_ATTR
, TL.SOURCE_LANG
, TL."LANGUAGE"
, B.ATTR_GROUP_ID
, TL.TL_EXT_ATTR
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.PROGRAM_APPLICATION_ID
, B.PROGRAM_ID
, B.PROGRAM_UPDATE_DATE
, B.REQUEST_ID
FROM EGO_ITEM_TRANS_ATTRS_B B
, EGO_ITEM_TRANS_ATTRS_TL TL
WHERE B.EXTENSION_ID = TL.EXTENSION_ID
AND TL.LANGUAGE = USERENV('LANG')