VIEW: APPS.OE_NOTES_OBJECT_REFS_VL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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