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

Object Details

Object Name:	CSL_JTF_TASK_ASSIGNMENTS_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

Mobile view on JTF_TASK_ASSIGNMENTS

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ACCESS_ID	NUMBER			Intentifier to CSL_JTF_TASK_ASS_ACC
TASK_ASSIGNMENT_ID	NUMBER		Yes	Unique task assignment identifier
OBJECT_VERSION_NUMBER	NUMBER		Yes	Sequential number used for database locking control when using HTML as a user interface
TASK_ID	NUMBER		Yes	Task identifier (foreign key to JTF_TASKS_VL)
RESOURCE_ID	NUMBER		Yes	Resource ID (foreign key to jtf_rs_resource_extns)
RESOURCE_TYPE_CODE	VARCHAR2	(30)	Yes	Resource type identifier
ASSIGNMENT_STATUS_ID	NUMBER		Yes	Status identifier of the asignee
SCHED_TRAVEL_DISTANCE	NUMBER			Scheduled Travel Distance
SCHED_TRAVEL_DURATION	NUMBER			Scheduled Travel Duration
SCHED_TRAVEL_DURATION_UOM	VARCHAR2	(3)		Unit of measure for Scheduled Travel Duration
ACTUAL_START_DATE	DATE			Actual start date
ACTUAL_END_DATE	DATE			Actual end date
ACTUAL_TRAVEL_DISTANCE	NUMBER			Actual Travel Distance
ACTUAL_TRAVEL_DURATION	NUMBER			Actual Travel Duration
ACTUAL_TRAVEL_DURATION_UOM	VARCHAR2	(3)		Unit of Measure for Actual Travel Duration
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
LAST_UPDATE_DATE	DATE		Yes	Standard who column

Query Text

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


SELECT ACCESS_ID
,      TASK_ASSIGNMENT_ID
,      OBJECT_VERSION_NUMBER
,      TASK_ID
,      RESOURCE_ID
,      RESOURCE_TYPE_CODE
,      ASSIGNMENT_STATUS_ID
,      SCHED_TRAVEL_DISTANCE
,      SCHED_TRAVEL_DURATION
,      SCHED_TRAVEL_DURATION_UOM
,      ACTUAL_START_DATE
,      ACTUAL_END_DATE
,      ACTUAL_TRAVEL_DISTANCE
,      ACTUAL_TRAVEL_DURATION
,      ACTUAL_TRAVEL_DURATION_UOM
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      LAST_UPDATE_DATE
FROM APPS.CSL_JTF_TASK_ASSIGNMENTS_V;

Dependencies

[top of page]

APPS.CSL_JTF_TASK_ASSIGNMENTS_V references the following:

APPS: ASG_BASE - show dependent code; CSL_JTF_TASK_ASS_ACC; JTF_TASK_ASSIGNMENTS

APPS.CSL_JTF_TASK_ASSIGNMENTS_V is not referenced by any database object