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_ESC_TASKS_V

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
OBJECT_ID	NUMBER		Yes	Object
TASK_ID	NUMBER		Yes	Task id
TASK_NUMBER	VARCHAR2	(30)	Yes	Number of the task
OBJECT_VERSION_NUMBER	NUMBER		Yes	Object version
OWNER_ID	NUMBER		Yes	Owner
OWNER_TYPE_CODE	VARCHAR2	(30)	Yes	Owner type
OWNER_TERRITORY_ID	NUMBER			Owner territory
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard creation date
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
TASK_NAME	VARCHAR2	(80)	Yes	Name of the task
DESCRIPTION	VARCHAR2	(4000)		Description
TASK_TYPE_ID	NUMBER		Yes	Task type
TASK_STATUS_ID	NUMBER		Yes	Task status
STATUS_NAME	VARCHAR2	(30)		status name
CLOSED_FLAG	VARCHAR2	(1)		Closed flag
ESCALATION_LEVEL	VARCHAR2	(30)		Escalation level
ESC_LEVEL_NAME	VARCHAR2	(80)		Name of escalation
REASON_CODE	VARCHAR2	(30)		Reason code
REASON_NAME	VARCHAR2	(80)		Name of the reason
CUSTOMER_ID	NUMBER			Customer
CUST_ACCOUNT_ID	NUMBER			Customer Acccount
ADDRESS_ID	NUMBER			Address
PARENT_TASK_ID	NUMBER			Parent task
DELETED_FLAG	VARCHAR2	(1)		Deleted flag
ACTUAL_START_DATE	DATE			Actual start date
ACTUAL_END_DATE	DATE			Actual end date
SOURCE_OBJECT_TYPE_CODE	VARCHAR2	(30)		Source Object type
SOURCE_OBJECT_ID	NUMBER			Source object
SOURCE_OBJECT_NAME	VARCHAR2	(80)		Source object name
TASK_PRIORITY_ID	NUMBER			Task priority
ASSIGNED_BY_ID	NUMBER			Assigned by
PRIVATE_FLAG	VARCHAR2	(1)		Private flag
PUBLISH_FLAG	VARCHAR2	(1)		Publish flag
WORKFLOW_PROCESS_ID	NUMBER			Workflow process
PLANNED_END_DATE	DATE			Planned end date
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment for attribute 1
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment for attribute 2
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment for attribute 3
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment for attribute 4
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment for attribute 5
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment for attribute 6
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment for attribute 7
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment for attribute 8
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment for attribute 9
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment for attribute 10
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment for attribute 11
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment for attribute 12
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment for attribute 13
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment for attribute 14
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment for attribute 15
ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Descriptive flexfield structure defining column

Query Text

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


SELECT OBJECT_ID
,      TASK_ID
,      TASK_NUMBER
,      OBJECT_VERSION_NUMBER
,      OWNER_ID
,      OWNER_TYPE_CODE
,      OWNER_TERRITORY_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      TASK_NAME
,      DESCRIPTION
,      TASK_TYPE_ID
,      TASK_STATUS_ID
,      STATUS_NAME
,      CLOSED_FLAG
,      ESCALATION_LEVEL
,      ESC_LEVEL_NAME
,      REASON_CODE
,      REASON_NAME
,      CUSTOMER_ID
,      CUST_ACCOUNT_ID
,      ADDRESS_ID
,      PARENT_TASK_ID
,      DELETED_FLAG
,      ACTUAL_START_DATE
,      ACTUAL_END_DATE
,      SOURCE_OBJECT_TYPE_CODE
,      SOURCE_OBJECT_ID
,      SOURCE_OBJECT_NAME
,      TASK_PRIORITY_ID
,      ASSIGNED_BY_ID
,      PRIVATE_FLAG
,      PUBLISH_FLAG
,      WORKFLOW_PROCESS_ID
,      PLANNED_END_DATE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
FROM APPS.CSF_ESC_TASKS_V;

Dependencies

[top of page]

APPS.CSF_ESC_TASKS_V references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUPS; JTF_TASKS_B; JTF_TASKS_TL; JTF_TASK_REFERENCES_B; JTF_TASK_STATUSES_B; JTF_TASK_STATUSES_TL

APPS.CSF_ESC_TASKS_V is not referenced by any database object