[Home] [Help] [Dependency Information]
Object Name: | CSF_L_SODS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CSF.CSF_L_SODS_V |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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) |
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;
APPS.CSF_L_SODS_V is not referenced by any database object
|
|
|