Skip to content
[Home] [Help]
View: OE_NOTES_OBJECT_REFS_VL
View Text
SELECT O.OBJECT_REF_ID
, O.OBJECT_REF_TYPE
, TL.DISPLAY_NAME
, TL.DESCRIPTION
, O.DATA_OBJECT_CODE
, FDE.TABLE_NAME
, O.COLUMN_NAME
, O.COLUMN_DATATYPE
, O.CREATION_DATE
, O.CREATED_BY
, O.LAST_UPDATE_DATE
, O.LAST_UPDATED_BY
, O.LAST_UPDATE_LOGIN
FROM OE_NOTES_OBJECT_REFS O
, OE_NOTES_OBJECT_REFS_TL TL
, FND_DOCUMENT_ENTITIES FDE
WHERE O.OBJECT_REF_ID = TL.OBJECT_REF_ID
AND TL.LANGUAGE = USERENV('LANG')
AND O.DATA_OBJECT_CODE = FDE.DATA_OBJECT_CODE
Columns
| Name |
| OBJECT_REF_ID |
| OBJECT_REF_TYPE |
| DISPLAY_NAME |
| DESCRIPTION |
| DATA_OBJECT_CODE |
| TABLE_NAME |
| COLUMN_NAME |
| COLUMN_DATATYPE |
| CREATION_DATE |
| CREATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_LOGIN |
APPS.OE_NOTES_OBJECT_REFS_VL