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

Object Details

Object Name:	AMS_TASKS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AMS.AMS_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
TASK_ID	NUMBER		Yes	Unique Identifier.
OBJECT_VERSION_NUMBER	NUMBER		Yes	This column is used for locking purposes.
TASK_NAME	VARCHAR2	(80)	Yes	Name of the task.
TASK_TYPE_ID	NUMBER		Yes	Type of the task.
TASK_PRIORITY_ID	NUMBER			Priority of the task.
TASK_STATUS_ID	NUMBER		Yes	Status of the task.
ACTUAL_START_DATE	DATE			Actual start date of the task.
ACTUAL_END_DATE	DATE			Actual end date of the class.
PLANNED_START_DATE	DATE			Planned start date of the task.
PLANNED_END_DATE	DATE			Planned end date of the task.
OWNER_ID	NUMBER		Yes	Unique Identifeir of the owner.
OWNER_TYPE_CODE	VARCHAR2	(30)	Yes	Owner type code.
SOURCE_OBJECT_ID	NUMBER			Unique Identifier of activity associated to the task.
SOURCE_OBJECT_NAME	VARCHAR2	(80)		Source object name.
SOURCE_OBJECT_TYPE_CODE	VARCHAR2	(30)		Activity code of the activity associated to the task.
TASK_ASSIGNMENT_ID	NUMBER		Yes	Unique identifier of task assignment.
ASSIGN_OBJECT_VERSION_NUMBER	NUMBER		Yes	This column is used for locking purposes.
RESOURCE_ID	NUMBER		Yes	Unique identifier of resource.
RESOURCE_TYPE_CODE	VARCHAR2	(30)	Yes	Resource type code.
ASSIGNMENT_STATUS_ID	NUMBER		Yes	Task assignement identifier.
TASK_APPROVER	VARCHAR2	(4000)		Approver of task.
TASK_OWNER	VARCHAR2	(360)		Owner of task.
PRIVATE_FLAG	VARCHAR2	(1)		Indicates whether task is private or not.
ACTIVITY_TYPE	VARCHAR2	(80)		Meaning of source_object_type_code.
CREATION_DATE	DATE		Yes	Date task created on.
OWNER_EMAIL	VARCHAR2	(2000)		Email of the owner of the task.
TASK_STATUS	VARCHAR2	(30)	Yes
TASK_TYPE	VARCHAR2	(30)	Yes
TASK_PRIORITY	VARCHAR2	(30)

Query Text

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


SELECT TASK_ID
,      OBJECT_VERSION_NUMBER
,      TASK_NAME
,      TASK_TYPE_ID
,      TASK_PRIORITY_ID
,      TASK_STATUS_ID
,      ACTUAL_START_DATE
,      ACTUAL_END_DATE
,      PLANNED_START_DATE
,      PLANNED_END_DATE
,      OWNER_ID
,      OWNER_TYPE_CODE
,      SOURCE_OBJECT_ID
,      SOURCE_OBJECT_NAME
,      SOURCE_OBJECT_TYPE_CODE
,      TASK_ASSIGNMENT_ID
,      ASSIGN_OBJECT_VERSION_NUMBER
,      RESOURCE_ID
,      RESOURCE_TYPE_CODE
,      ASSIGNMENT_STATUS_ID
,      TASK_APPROVER
,      TASK_OWNER
,      PRIVATE_FLAG
,      ACTIVITY_TYPE
,      CREATION_DATE
,      OWNER_EMAIL
,      TASK_STATUS
,      TASK_TYPE
,      TASK_PRIORITY
FROM APPS.AMS_TASKS_V;

Dependencies

[top of page]

APPS.AMS_TASKS_V references the following:

APPS: AMS_JTF_RS_EMP_V; AMS_LOOKUPS; JTF_TASKS_V; JTF_TASK_ASSIGNMENTS; JTF_TASK_TYPES_B; JTF_TASK_UTL - show dependent code; JTF_TASK_WORKFLOW_PKG - show dependent code

APPS.AMS_TASKS_V is not referenced by any database object