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.FND_DOC_CATEGORY_USAGES_VL

Object Details

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

View Type

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

This view resolves issues regarding which language of a category is
used when viewing an assignment of a category to a form or form
function.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row identifier
DOC_CATEGORY_USAGE_ID	NUMBER		Yes	Unique identifier
CATEGORY_ID	NUMBER		Yes	Unique identifier sourced from the FND_DOCUMENTS_CATEGORIES_S sequence
ATTACHMENT_FUNCTION_ID	NUMBER		Yes	Attachment function identifier
FUNCTION_NAME	VARCHAR2	(30)	Yes	Developer name from FND_FORM_FUNCTIONS or FND_FORM, depending on the value of FUNCTION_TYPE
FUNCTION_TYPE	VARCHAR2	(1)	Yes	Function type
USER_FUNCTION_NAME	VARCHAR2	(4000)		Username for the form or form function
ENABLED_FLAG	VARCHAR2	(1)	Yes	Flag indicating whether attachment functionality is enabled for the form or form function
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
NAME	VARCHAR2	(30)	Yes	Developer name for the category
USER_NAME	VARCHAR2	(255)	Yes	Username for the category (language-dependent)
START_DATE_ACTIVE	DATE			The date when the category becomes active
END_DATE_ACTIVE	DATE			The date when the category becomes inactive
FORMAT	VARCHAR2	(1)

Query Text

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


SELECT ROW_ID
,      DOC_CATEGORY_USAGE_ID
,      CATEGORY_ID
,      ATTACHMENT_FUNCTION_ID
,      FUNCTION_NAME
,      FUNCTION_TYPE
,      USER_FUNCTION_NAME
,      ENABLED_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      NAME
,      USER_NAME
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      FORMAT
FROM APPS.FND_DOC_CATEGORY_USAGES_VL;

Dependencies

[top of page]

APPS.FND_DOC_CATEGORY_USAGES_VL references the following:

APPS: FND_ATTACHMENT_FUNCTIONS; FND_ATTACHMENT_UTIL_PKG - show dependent code; FND_DOCUMENT_CATEGORIES; FND_DOCUMENT_CATEGORIES_TL; FND_DOC_CATEGORY_USAGES

APPS.FND_DOC_CATEGORY_USAGES_VL is referenced by following:

APPS: GR_ATTACH_DOCUMENTS_PKG - show dependent code