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

Object Details

Object Name:	JTF_AM_TASK_DTLS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	JTF.JTF_AM_TASK_DTLS_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
ROW_ID	ROWID	(10)		Unique row identifier
RESOURCE_TYPE_CODE	VARCHAR2	(30)	Yes	Resource type code for the task assignment
RESOURCE_ID	NUMBER		Yes	Resource Id for the task assignment
TASK_ID	NUMBER		Yes	Unique task identifier
TASK_ASSIGNMENT_ID	NUMBER		Yes	Unique Task Assignment identifier
SCHEDULED_START_DATE	DATE			Scheduled start date of the task
SCHEDULED_END_DATE	DATE			Scheduled end date of the task
TIMEZONE_ID	NUMBER
SCHED_TRAVEL_DURATION	NUMBER			Travel duration
SOURCE_OBJECT_TYPE_CODE	VARCHAR2	(30)		The source object type code for the task
SOURCE_OBJECT_ID	NUMBER			The source object identifier for the task
SOURCE_OBJECT_NAME	VARCHAR2	(80)		The source object name for the task
TASK_NUMBER	VARCHAR2	(30)	Yes	The task number that uniquely identifies the task
TASK_TYPE_ID	NUMBER		Yes	The task type
TASK_STATUS_ID	NUMBER		Yes	The Task status
ASSIGNMENT_STATUS_ID	NUMBER		Yes	The Resource assignment status for the task
TASK_PRIORITY_ID	NUMBER			The assigned task priority
TASK_NAME	VARCHAR2	(80)	Yes	Task name of the assigned task
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign
ESCALATION_FLAG	VARCHAR2	(1)		This indicates whether the task has been escalated.

Query Text

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


SELECT ROW_ID
,      RESOURCE_TYPE_CODE
,      RESOURCE_ID
,      TASK_ID
,      TASK_ASSIGNMENT_ID
,      SCHEDULED_START_DATE
,      SCHEDULED_END_DATE
,      TIMEZONE_ID
,      SCHED_TRAVEL_DURATION
,      SOURCE_OBJECT_TYPE_CODE
,      SOURCE_OBJECT_ID
,      SOURCE_OBJECT_NAME
,      TASK_NUMBER
,      TASK_TYPE_ID
,      TASK_STATUS_ID
,      ASSIGNMENT_STATUS_ID
,      TASK_PRIORITY_ID
,      TASK_NAME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ESCALATION_FLAG
FROM APPS.JTF_AM_TASK_DTLS_V;

Dependencies

[top of page]

APPS.JTF_AM_TASK_DTLS_V references the following:

APPS: JTF_TASKS_B; JTF_TASKS_VL; JTF_TASK_ASSIGNMENTS; JTF_TASK_REFERENCES_B; JTF_TASK_STATUSES_B

APPS.JTF_AM_TASK_DTLS_V is not referenced by any database object