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

Object Details

Object Name:	CSC_TASKS_V
Object Type:	VIEW
Owner:	APPS
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
TASK_ID	NUMBER		Yes	Unique task identifier (PK)
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
TASK_PRIORITY_ID	NUMBER			Task priority (foreign key to JTF_TASK_PRIORITIES)
TASK_PRIORITY	VARCHAR2	(30)		Task Priority
TASK_STATUS_ID	NUMBER		Yes	Task status (foreign key to JTF_TASK_STATUSES)
TASK_STATUS	VARCHAR2	(30)	Yes	Task Status
TASK_NAME	VARCHAR2	(80)	Yes	Task Name
DESCRIPTION	VARCHAR2	(4000)		Task Description
OWNER_ID	NUMBER		Yes	Task Owner Identifier
OWNER	VARCHAR2	(4000)		Task Owner
OWNER_TYPE_CODE	VARCHAR2	(30)	Yes	Task Owner Type Code
OWNER_TYPE	VARCHAR2	(30)	Yes	Task Owner Type
SOURCE_OBJECT_TYPE_CODE	VARCHAR2	(30)		Source Object Type Code
SOURCE_OBJECT_ID	NUMBER			Source Object Identifier
SOURCE_OBJECT_NAME	VARCHAR2	(80)		Source Object Name
ASSIGNED_BY_ID	NUMBER			User who assigned the task to current owner
CUST_ACCOUNT_ID	NUMBER			Customer Account
CUSTOMER_ID	NUMBER			Customer Id
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Creation Date
LAST_UPDATED_BY	NUMBER	(15)	Yes	Last Updated By
LAST_UPDATE_DATE	DATE		Yes	Last Update Date
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column - with the user id from FND_USER
ADDRESS_ID	NUMBER			Address Identifier
PLANNED_START_DATE	DATE			Planned Start Date
PLANNED_END_DATE	DATE			Planned End Date
SCHEDULED_START_DATE	DATE			Scheduled Start Date
SCHEDULED_END_DATE	DATE			Scheduled End Date
ACTUAL_START_DATE	DATE			Actual Start Date
ACTUAL_END_DATE	DATE			Actual End Date
PARENT_TASK_ID	NUMBER			Parent Task Identifier
DURATION	NUMBER			Duration
DURATION_UOM	VARCHAR2	(3)		Durations unit of measurement
PLANNED_EFFORT	NUMBER			Planned Effort
PLANNED_EFFORT_UOM	VARCHAR2	(3)		Planned Effort Unit of Measurement
ACTUAL_EFFORT	NUMBER			Actual amount of effort spent on a task by all assignees
ACTUAL_EFFORT_UOM	VARCHAR2	(3)		Unit of Measurement for actual effort
PRIVATE_FLAG	VARCHAR2	(1)		Private Flag
PUBLISH_FLAG	VARCHAR2	(1)		Publish Flag
TIMEZONE_ID	NUMBER			Timezone Identifier
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
OBJECT_VERSION_NUMBER	NUMBER		Yes	Object Version Number
OWNER_TERRITORY_ID	NUMBER			Owner Territory Identifier
ESCALATION_LEVEL	VARCHAR2	(30)		Escalation Level
CURRENCY_CODE	VARCHAR2	(15)		Currency Code
NOTIFICATION_FLAG	VARCHAR2	(1)		Flag indicating whether notification workflow will be automatically launched.
NOTIFICATION_PERIOD	NUMBER			Notification Period
NOTIFICATION_PERIOD_UOM	VARCHAR2	(3)		Unit of Measurement for Notification period
RECURRENCE_RULE_ID	NUMBER			Task recurrence rule identifier
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment column
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
RULE	VARCHAR2	(30)		Rule Used for Field Service Related Tasks
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
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 Alarm to fire.
ALARM_FIRED_COUNT	NUMBER			Total Number of Alarm Fired
ALARM_INTERVAL	NUMBER			Alarm Interval
ALARM_INTERVAL_UOM	VARCHAR2	(3)		Unit Of Measurement for Alarm Interval
DELETED_FLAG	VARCHAR2	(1)		Flag indicating the task has been deleted
PERCENTAGE_COMPLETE	NUMBER			Indicates the percentage of task completion
REASON_CODE	VARCHAR2	(30)		Reason for rejecting a task, reassigning a task, etc.
RESTRICT_CLOSURE_FLAG	VARCHAR2	(1)		Indicates whether completing the task is necessary for the source 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.
PARENT_TASK_NUMBER	VARCHAR2	(30)		Parent Task Number
CLOSED_FLAG	VARCHAR2	(1)		Parent Task Number

Query Text

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


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

Dependencies

[top of page]

APPS.CSC_TASKS_V references the following:

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

APPS.CSC_TASKS_V is not referenced by any database object