[Home] [Help]
View: GR_OTHER_NAMES_TL_V
Product: | GR - Process Manufacturing Regulatory Management |
Description: | Contains rows that have a language dependent description for the item/organization combinations for the GR_OTHER_NAMES_TL table. |
Implementation/DBA Data: |
APPS.GR_OTHER_NAMES_TL_V
|
View Text
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
Columns
Name |
ROW_ID |
ITEM_CODE |
LANGUAGE |
LANGUAGE_DESCRIPTION |
ORGN_CODE |
ORGN_NAME |
SYNONYM_SEQUENCE_NUMBER |
SOURCE_LANG |
ITEM_OTHER_NAME |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |