eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: OKR_ATTACHMENTS_V

Product:	OKR - Contracts for Rights (Obsolete)
Description:	View on FND_ATTACHED_DOCUMENTS,FND_DOCUMENTS,FND_DOCUMENTS_TL,FND_DOCUMENT_DATATYPES ,FND_DOCUMENT_CATEGORIES_TL
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT FAD.ROWID ROW_ID
, FAD.ATTACHED_DOCUMENT_ID ATTACHED_DOCUMENT_ID
, FAD.DOCUMENT_ID DOCUMENT_ID
, FAD.ENTITY_NAME ENTITY_NAME
, FAD.PK1_VALUE ENTITY_ID
, FAD.SEQ_NUM SEQ_NUM
, FAD.AUTOMATICALLY_ADDED_FLAG AUTOMATICALLY_ADDED_FLAG
, FDOB.DATATYPE_ID DATATYPE_ID
, FDD.USER_NAME DATATYPE_NAME
, FDOB.CATEGORY_ID CATEGORY_ID
, FDCT.USER_NAME CATEGORY_NAME
, FDOB.PUBLISH_FLAG PUBLISH_FLAG
, FDOT.DESCRIPTION DESCRIPTION
, FDOT.FILE_NAME FILE_NAME
, FDOT.MEDIA_ID MEDIA_ID
FROM FND_ATTACHED_DOCUMENTS FAD
, FND_DOCUMENTS FDOB
, FND_DOCUMENTS_TL FDOT
, FND_DOCUMENT_DATATYPES FDD
, FND_DOCUMENT_CATEGORIES_TL FDCT
WHERE FAD.DOCUMENT_ID = FDOB.DOCUMENT_ID
AND FAD.DOCUMENT_ID = FDOT.DOCUMENT_ID
AND FDOB.DOCUMENT_ID = FDOT.DOCUMENT_ID
AND FDOB.DATATYPE_ID = FDD.DATATYPE_ID
AND FDOB.CATEGORY_ID = FDCT.CATEGORY_ID

Columns

Name
ROW_ID
ATTACHED_DOCUMENT_ID
DOCUMENT_ID
ENTITY_NAME
ENTITY_ID
SEQ_NUM
AUTOMATICALLY_ADDED_FLAG
DATATYPE_ID
DATATYPE_NAME
CATEGORY_ID
CATEGORY_NAME
PUBLISH_FLAG
DESCRIPTION
FILE_NAME
MEDIA_ID