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

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row Identifier
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Descriptive flexfield structure defining column
TASK_ID	NUMBER		Yes	Unique task identifier (PK)
CREATED_BY	NUMBER	(15)	Yes	Standard Who column - with the user id from FND_USER
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column - with the user id from FND_USER
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
TASK_NUMBER	VARCHAR2	(30)	Yes	Task Number
TASK_TYPE_ID	NUMBER		Yes	Task type (foreign key to JTF_TASK_TYPES)
TASK_TYPE	VARCHAR2	(30)	Yes	Task Type
RULE	VARCHAR2	(30)		Rule Name
TASK_STATUS_ID	NUMBER		Yes	Task status (foreign key to JTF_TASK_STATUSES)
TASK_STATUS	VARCHAR2	(30)	Yes	Task status
TASK_PRIORITY_ID	NUMBER			Task priority (foreign key to JTF_TASK_PRIORITIES)
TASK_PRIORITY	VARCHAR2	(30)		Task priority
OWNER_ID	NUMBER		Yes	Owner of the task
OWNER	VARCHAR2	(4000)		Owner
OWNER_TYPE_CODE	VARCHAR2	(30)	Yes	Resource type identifier of task owner
OWNER_TYPE	VARCHAR2	(30)	Yes	Resource Type description of the Task Owner
ASSIGNED_BY_ID	NUMBER			User who assigned the task to current owner
CUST_ACCOUNT_ID	NUMBER			User Name who assigned the task to current owner
CUSTOMER_ID	NUMBER			Customer associated with task
ADDRESS_ID	NUMBER			Address Identifier
PLANNED_START_DATE	DATE			Planned start date
PALM_FLAG	VARCHAR2	(1)		Used by Mobile Device
WINCE_FLAG	VARCHAR2	(1)		Used by Mobile Device
LAPTOP_FLAG	VARCHAR2	(1)		Used by Mobile Device
DEVICE1_FLAG	VARCHAR2	(1)		Used by Mobile Device
DEVICE2_FLAG	VARCHAR2	(1)		Used by Mobile Device
DEVICE3_FLAG	VARCHAR2	(1)		Used by Mobile Device
COSTS	NUMBER			Used by Marketing
CURRENCY_CODE	VARCHAR2	(15)		Used by Marketing
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment column
NOTIFICATION_PERIOD	NUMBER			Time before the scheduled start date that a notification is sent to the assignees
NOTIFICATION_PERIOD_UOM	VARCHAR2	(3)		Unit of measure for notification period
PARENT_TASK_ID	NUMBER			Parent Task's ID
RECURRENCE_RULE_ID	NUMBER			Recurrence rule identifier
ALARM_START	NUMBER			Indicates when the first alarm should be fired
ALARM_START_UOM	VARCHAR2	(3)		Unit of measure for ALARM_START
ALARM_ON	VARCHAR2	(1)		Indicates whether the alarm is on
ALARM_COUNT	NUMBER			Total number of alarms to fire
ALARM_FIRED_COUNT	NUMBER			Number of alarms fired
ALARM_INTERVAL	NUMBER			Alarm interval
ALARM_INTERVAL_UOM	VARCHAR2	(3)		Unit of measure for Alarm Interva
DELETED_FLAG	VARCHAR2	(1)		Flag indicating the task has been deleted
ACTUAL_START_DATE	DATE			Actual start date
ACTUAL_END_DATE	DATE			Actual end date
SOURCE_OBJECT_TYPE_CODE	VARCHAR2	(30)		Type of source object (foreign key to JTF_TASK_OBJECT_TYPES)
TIMEZONE_ID	NUMBER			Time zone identifier
SOURCE_OBJECT_ID	NUMBER			Internal ID of source object
SOURCE_OBJECT_NAME	VARCHAR2	(80)		User-visible source object identifier
DURATION	NUMBER			Duration of task
DURATION_UOM	VARCHAR2	(3)		Unit of measure for duration
PLANNED_EFFORT	NUMBER			Planned effort
PLANNED_EFFORT_UOM	VARCHAR2	(3)		Unit of measure for planned effort
ACTUAL_EFFORT	NUMBER			Actual amount of effort spent on a task by all assignees
ACTUAL_EFFORT_UOM	VARCHAR2	(3)		Unit of measure for actual work
PERCENTAGE_COMPLETE	NUMBER			Percentage completion of the task.
REASON_CODE	VARCHAR2	(30)		Reason for rejecting a task, reassigning a task, etc.
PRIVATE_FLAG	VARCHAR2	(1)		Indicates whether the task is private or publi
PUBLISH_FLAG	VARCHAR2	(1)		Indicates whether the task should be published.
RESTRICT_CLOSURE_FLAG	VARCHAR2	(1)		Indicates whether completing the task is necessary for thesource object to be deemed complete
MULTI_BOOKED_FLAG	VARCHAR2	(1)		Indicates whether the task can book resources that are already assigned to other tasks
MILESTONE_FLAG	VARCHAR2	(1)		Indicates whether the task is a milestone delivery date
HOLIDAY_FLAG	VARCHAR2	(1)		Indicates whether the task is to be performed on holidays.
BILLABLE_FLAG	VARCHAR2	(1)		Indicates whether the task is billable.
BOUND_MODE_CODE	VARCHAR2	(30)		Used for Scheduling.
SOFT_BOUND_FLAG	VARCHAR2	(1)		Used for Scheduling.
WORKFLOW_PROCESS_ID	NUMBER			Identifier of las workflow process launched for this task
NOTIFICATION_FLAG	VARCHAR2	(1)		Flag indicating whether notification workflow will be automatically launched.
PLANNED_END_DATE	DATE			Planned end date
SCHEDULED_START_DATE	DATE			Scheduled start date
SCHEDULED_END_DATE	DATE			Scheduled end date
TASK_NAME	VARCHAR2	(80)	Yes	Task Name
DESCRIPTION	VARCHAR2	(4000)		Task description
OBJECT_VERSION_NUMBER	NUMBER		Yes	Sequential number used for database locking control when using HTML as a user interface
OWNER_TERRITORY_ID	NUMBER			Territory identifier of the Owner
ESCALATION_LEVEL	VARCHAR2	(30)		Escalation Level
PARENT_TASK_NUMBER	VARCHAR2	(30)		Parent Task's Number
TASK_CONFIRMATION_STATUS	VARCHAR2	(1)		Task Confirmation Status

Query Text

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


SELECT ROW_ID
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      TASK_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      TASK_NUMBER
,      TASK_TYPE_ID
,      TASK_TYPE
,      RULE
,      TASK_STATUS_ID
,      TASK_STATUS
,      TASK_PRIORITY_ID
,      TASK_PRIORITY
,      OWNER_ID
,      OWNER
,      OWNER_TYPE_CODE
,      OWNER_TYPE
,      ASSIGNED_BY_ID
,      CUST_ACCOUNT_ID
,      CUSTOMER_ID
,      ADDRESS_ID
,      PLANNED_START_DATE
,      PALM_FLAG
,      WINCE_FLAG
,      LAPTOP_FLAG
,      DEVICE1_FLAG
,      DEVICE2_FLAG
,      DEVICE3_FLAG
,      COSTS
,      CURRENCY_CODE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      NOTIFICATION_PERIOD
,      NOTIFICATION_PERIOD_UOM
,      PARENT_TASK_ID
,      RECURRENCE_RULE_ID
,      ALARM_START
,      ALARM_START_UOM
,      ALARM_ON
,      ALARM_COUNT
,      ALARM_FIRED_COUNT
,      ALARM_INTERVAL
,      ALARM_INTERVAL_UOM
,      DELETED_FLAG
,      ACTUAL_START_DATE
,      ACTUAL_END_DATE
,      SOURCE_OBJECT_TYPE_CODE
,      TIMEZONE_ID
,      SOURCE_OBJECT_ID
,      SOURCE_OBJECT_NAME
,      DURATION
,      DURATION_UOM
,      PLANNED_EFFORT
,      PLANNED_EFFORT_UOM
,      ACTUAL_EFFORT
,      ACTUAL_EFFORT_UOM
,      PERCENTAGE_COMPLETE
,      REASON_CODE
,      PRIVATE_FLAG
,      PUBLISH_FLAG
,      RESTRICT_CLOSURE_FLAG
,      MULTI_BOOKED_FLAG
,      MILESTONE_FLAG
,      HOLIDAY_FLAG
,      BILLABLE_FLAG
,      BOUND_MODE_CODE
,      SOFT_BOUND_FLAG
,      WORKFLOW_PROCESS_ID
,      NOTIFICATION_FLAG
,      PLANNED_END_DATE
,      SCHEDULED_START_DATE
,      SCHEDULED_END_DATE
,      TASK_NAME
,      DESCRIPTION
,      OBJECT_VERSION_NUMBER
,      OWNER_TERRITORY_ID
,      ESCALATION_LEVEL
,      PARENT_TASK_NUMBER
,      TASK_CONFIRMATION_STATUS
FROM APPS.CS_SR_TASKS_V;

Dependencies

[top of page]

APPS.CS_SR_TASKS_V references the following:

APPS: JTF_OBJECTS_VL; JTF_TASKS_B; JTF_TASKS_VL; JTF_TASK_PRIORITIES_VL; JTF_TASK_STATUSES_VL; JTF_TASK_TYPES_VL; JTF_TASK_UTL - show dependent code

APPS.CS_SR_TASKS_V is referenced by following:

APPS: CSD_SOO_PVT - show dependent code; CS_SERVICEREQUEST_PUB - show dependent code; CS_SERVICEREQUEST_PUB - show dependent code