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

Object Details

Object Name:	CSL_LOBS_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

Object View for capturing Signature

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ACCESS_ID	NUMBER		Yes	Access Id
FILE_ID	NUMBER		Yes	File Id in FND_LOBS
TASK_ASSIGNMENT_ID	NUMBER			Task Assignement Id
DESCRIPTION	VARCHAR2	(255)		Description
LANGUAGE	VARCHAR2	(4)	Yes	Language
FILE_DATA	BLOB	(4000)		Actual Blob Data
ENTITY_NAME	VARCHAR2	(40)	Yes	No comments
PK1_VALUE	VARCHAR2	(100)		No comments
PK2_VALUE	VARCHAR2	(100)		No comments
SEQ_NUM	NUMBER		Yes	No comments
FILE_NAME	VARCHAR2	(256)		No comments
FILE_CONTENT_TYPE	VARCHAR2	(256)	Yes	No comments
USER_NAME	VARCHAR2	(13)		No comments

Query Text

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


SELECT ACCESS_ID
,      FILE_ID
,      TASK_ASSIGNMENT_ID
,      DESCRIPTION
,      LANGUAGE
,      FILE_DATA
,      ENTITY_NAME
,      PK1_VALUE
,      PK2_VALUE
,      SEQ_NUM
,      FILE_NAME
,      FILE_CONTENT_TYPE
,      USER_NAME
FROM APPS.CSL_LOBS_V;

Dependencies

[top of page]

APPS.CSL_LOBS_V references the following:

APPS: ASG_BASE - show dependent code; ASG_TEMP_LOB; CSF_DEBRIEF_HEADERS; CSL_CS_INCIDENTS_ALL_ACC; CSL_JTF_TASKS_ACC; CSL_JTF_TASK_ASS_ACC; FND_ATTACHED_DOCUMENTS; FND_DOCUMENTS; FND_DOCUMENTS_TL; FND_DOCUMENT_CATEGORIES_TL; FND_LOBS

APPS.CSL_LOBS_V is not referenced by any database object