[Home] [Help]
View: MSD_CS_CLMN_IDENTIFIERS_VL
View Text
SELECT IDEN.COLUMN_IDENTIFIER
, IDEN_TL.DESCRIPTION
, IDEN.IDENTIFIER_TYPE
, F.MEANING
, IDEN_TL.USER_PROMPT
, IDEN.SYSTEM_FLAG
, IDEN.CREATION_DATE
, IDEN.CREATED_BY
, IDEN.LAST_UPDATE_DATE
, IDEN.LAST_UPDATED_BY
, IDEN.LAST_UPDATE_LOGIN
FROM MSD_CS_CLMN_IDENTIFIERS IDEN
, MSD_CS_CLMN_IDENTIFIERS_TL IDEN_TL
, FND_LOOKUP_VALUES_VL F
WHERE F.LOOKUP_TYPE = 'MSD_CS_IDENTIFIERS'
AND F.LOOKUP_CODE = IDEN.IDENTIFIER_TYPE
AND IDEN.COLUMN_IDENTIFIER = IDEN_TL.COLUMN_IDENTIFIER
AND IDEN_TL.LANGUAGE = USERENV('LANG')
Columns
Name |
COLUMN_IDENTIFIER |
DESCRIPTION |
IDENTIFIER_TYPE |
IDENTIFIER_TYPE_DESC |
USER_PROMPT |
SYSTEM_FLAG |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |