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

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
ROW_ID	ROWID	(10)
SOD_SOD_ID	NUMBER	(15)	Yes
SOD_SOT_ID	NUMBER	(15)	Yes
SOD_SODTYPE	VARCHAR2	(20)	Yes
SOD_SODDESCR	VARCHAR2	(50)	Yes
SOD_FILENAMEHDR	VARCHAR2	(255)	Yes
SOD_FILENAMEFTR	VARCHAR2	(255)
SOD_DEFSOD_ID	NUMBER	(15)	Yes
SOD_TASK_TYPE_ID	NUMBER
SOD_ITEM_PATTERN	VARCHAR2	(240)
SOD_ATTRIBUTE_CATEGORY	VARCHAR2	(30)
SOD_ATTRIBUTE1	VARCHAR2	(150)
SOD_ATTRIBUTE2	VARCHAR2	(150)
SOD_ATTRIBUTE3	VARCHAR2	(150)
SOD_ATTRIBUTE4	VARCHAR2	(150)
SOD_ATTRIBUTE5	VARCHAR2	(150)
SOD_ATTRIBUTE6	VARCHAR2	(150)
SOD_ATTRIBUTE7	VARCHAR2	(150)
SOD_ATTRIBUTE8	VARCHAR2	(150)
SOD_ATTRIBUTE9	VARCHAR2	(150)
SOD_ATTRIBUTE10	VARCHAR2	(150)
SOD_ATTRIBUTE11	VARCHAR2	(150)
SOD_ATTRIBUTE12	VARCHAR2	(150)
SOD_ATTRIBUTE13	VARCHAR2	(150)
SOD_ATTRIBUTE14	VARCHAR2	(150)
SOD_ATTRIBUTE15	VARCHAR2	(150)
SOT_SOT_ID	NUMBER	(15)	Yes
SOT_DESCR	VARCHAR2	(50)	Yes
SOT_ATTRIBUTE_CATEGORY	VARCHAR2	(30)
SOT_ATTRIBUTE1	VARCHAR2	(150)
SOT_ATTRIBUTE2	VARCHAR2	(150)
SOT_ATTRIBUTE3	VARCHAR2	(150)
SOT_ATTRIBUTE4	VARCHAR2	(150)
SOT_ATTRIBUTE5	VARCHAR2	(150)
SOT_ATTRIBUTE6	VARCHAR2	(150)
SOT_ATTRIBUTE7	VARCHAR2	(150)
SOT_ATTRIBUTE8	VARCHAR2	(150)
SOT_ATTRIBUTE9	VARCHAR2	(150)
SOT_ATTRIBUTE10	VARCHAR2	(150)
SOT_ATTRIBUTE11	VARCHAR2	(150)
SOT_ATTRIBUTE12	VARCHAR2	(150)
SOT_ATTRIBUTE13	VARCHAR2	(150)
SOT_ATTRIBUTE14	VARCHAR2	(150)
SOT_ATTRIBUTE15	VARCHAR2	(150)
JTT_TASK_TYPE_ID	NUMBER
JTT_NAME	VARCHAR2	(30)
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes
SOD_ORDER	VARCHAR2	(68)

Query Text

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


SELECT ROW_ID
,      SOD_SOD_ID
,      SOD_SOT_ID
,      SOD_SODTYPE
,      SOD_SODDESCR
,      SOD_FILENAMEHDR
,      SOD_FILENAMEFTR
,      SOD_DEFSOD_ID
,      SOD_TASK_TYPE_ID
,      SOD_ITEM_PATTERN
,      SOD_ATTRIBUTE_CATEGORY
,      SOD_ATTRIBUTE1
,      SOD_ATTRIBUTE2
,      SOD_ATTRIBUTE3
,      SOD_ATTRIBUTE4
,      SOD_ATTRIBUTE5
,      SOD_ATTRIBUTE6
,      SOD_ATTRIBUTE7
,      SOD_ATTRIBUTE8
,      SOD_ATTRIBUTE9
,      SOD_ATTRIBUTE10
,      SOD_ATTRIBUTE11
,      SOD_ATTRIBUTE12
,      SOD_ATTRIBUTE13
,      SOD_ATTRIBUTE14
,      SOD_ATTRIBUTE15
,      SOT_SOT_ID
,      SOT_DESCR
,      SOT_ATTRIBUTE_CATEGORY
,      SOT_ATTRIBUTE1
,      SOT_ATTRIBUTE2
,      SOT_ATTRIBUTE3
,      SOT_ATTRIBUTE4
,      SOT_ATTRIBUTE5
,      SOT_ATTRIBUTE6
,      SOT_ATTRIBUTE7
,      SOT_ATTRIBUTE8
,      SOT_ATTRIBUTE9
,      SOT_ATTRIBUTE10
,      SOT_ATTRIBUTE11
,      SOT_ATTRIBUTE12
,      SOT_ATTRIBUTE13
,      SOT_ATTRIBUTE14
,      SOT_ATTRIBUTE15
,      JTT_TASK_TYPE_ID
,      JTT_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SOD_ORDER
FROM APPS.CSF_L_SODS_V;

Dependencies

[top of page]

APPS.CSF_L_SODS_V references the following:

APPS: CSF_L_SODS; CSF_L_SOTS; JTF_TASK_TYPES_VL

APPS.CSF_L_SODS_V is not referenced by any database object