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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.EDR_FILES_LATEST_VERSION_V

Object Details

Object Name:	EDR_FILES_LATEST_VERSION_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	EDR.EDR_FILES_LATEST_VERSION_V
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

The latest version of the files in the File Upload System

[View Source]

Columns

Name	Datatype	Length	Comments
ORIGINAL_FILE_NAME	VARCHAR2	(255)	Original file name of the file
ATTRIBUTE_CATEGORY	VARCHAR2	(30)	Category Name of the File
VERSION_NUMBER	NUMBER		Latest Version Number of the file
COUNT	NUMBER		Number of versions of the file

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ORIGINAL_FILE_NAME
,      ATTRIBUTE_CATEGORY
,      VERSION_NUMBER
,      COUNT
FROM APPS.EDR_FILES_LATEST_VERSION_V;

Dependencies

[top of page]

APPS.EDR_FILES_LATEST_VERSION_V references the following:

APPS: EDR_FILES_VL

APPS.EDR_FILES_LATEST_VERSION_V is not referenced by any database object