DBA Data[Home] [Help]

VIEW: APPS.GR_OTHER_NAMES_TL_V

Source

View Text - Preformatted

SELECT b.ROWID ROW_ID, b.ITEM_CODE, b.LANGUAGE, t.DESCRIPTION, b.ORGN_CODE, s.ORGN_NAME, b.SYNONYM_SEQUENCE_NUMBER, b.SOURCE_LANG, b.ITEM_OTHER_NAME, b.CREATED_BY, b.CREATION_DATE, b.LAST_UPDATED_BY, b.LAST_UPDATE_DATE, b.LAST_UPDATE_LOGIN FROM GR_OTHER_NAMES_TL b, FND_LANGUAGES_VL t, SY_ORGN_MST s WHERE b.LANGUAGE = t.LANGUAGE_CODE AND s.ORGN_CODE = b.ORGN_CODE
View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.ITEM_CODE
, B.LANGUAGE
, T.DESCRIPTION
, B.ORGN_CODE
, S.ORGN_NAME
, B.SYNONYM_SEQUENCE_NUMBER
, B.SOURCE_LANG
, B.ITEM_OTHER_NAME
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
FROM GR_OTHER_NAMES_TL B
, FND_LANGUAGES_VL T
, SY_ORGN_MST S
WHERE B.LANGUAGE = T.LANGUAGE_CODE
AND S.ORGN_CODE = B.ORGN_CODE