[Home] [Help]
View: EGO_ITEM_TRANS_ATTRS_VL
View Text
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')