VIEW: APPS.OE_ATTACHMENT_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_ATTACHMENT_OBJECT_REFS O, OE_ATTACHMENT_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_ATTACHMENT_OBJECT_REFS O
, OE_ATTACHMENT_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