DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.JTF_TASK_UWQ_ALL_V

Object Details
Object Name: JTF_TASK_UWQ_ALL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJTF.JTF_TASK_UWQ_ALL_V
Subobject Name:
Status: VALID


This view is used to get all the tasks which has an open assignments


[View Source]

Columns
Name Datatype Length Mandatory Comments
TASK_ID NUMBER
Yes Task identifier
TASK_NUMBER VARCHAR2 (30) Yes Task number
TASK_NAME VARCHAR2 (80) Yes Task name
TASK_TYPE VARCHAR2 (30) Yes Task type
TASK_STATUS VARCHAR2 (30) Yes Task status
TASK_PRIORITY VARCHAR2 (30)
Task priority
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
SOURCE_OBJECT_TYPE_CODE VARCHAR2 (30)
Source object type code (foreign key to JTF_OBJECTS_VL)
SOURCE_OBJECT_TYPE VARCHAR2 (30) Yes Name of the source object type.
SOURCE_OBJECT_ID NUMBER

Internal identifier of source object
SOURCE_OBJECT_NUMBER VARCHAR2 (80)
User-visible source object number
OWNER_TYPE_CODE VARCHAR2 (0)
Not currently used
OWNER_ID VARCHAR2 (0)
Not currently used
OWNER VARCHAR2 (4000)
Name of the owner
CUSTOMER_NAME VARCHAR2 (360)
Customer name
CUST_ACCOUNT_NUMBER VARCHAR2 (0)
Customer's account number
GLOBAL_TIMEZONE_NAME VARCHAR2 (80)
Global time zone name
GMT_DEVIATION_HOURS NUMBER

GMT deviation in hours
DURATION NUMBER

Duration of the task
DURATION_UOM VARCHAR2 (3)
Unit of measure for duration
ESCALATION_LEVEL VARCHAR2 (0)
Escalation Level
ESCALATION_OWNER VARCHAR2 (0)
Owner of the escalation
RESOURCE_ID NUMBER
Yes Resource identifier associated to this task.
RESOURCE_TYPE VARCHAR2 (30) Yes Resource type of the associated resource.
OWNED_FLAG VARCHAR2 (30)
An indicator to determine an assignee's role. The possible values are 'A' - ASSIGNEE and 'O' - OWNER.
TASK_STATUS_ID NUMBER
Yes Task status identifier (foreign key to JTF_TASK_STATUSES_VL)
TASK_TYPE_ID NUMBER
Yes Task type identifier (foreign key to JTF_TASK_TYPES_VL )
CLOSED_FLAG CHAR (1)
A flag to indicate whether the task has been closed or not.
OBJECT_FUNCTION VARCHAR2 (30)
Oracle Applications internal function name of a form
OBJECT_PARAMETERS VARCHAR2 (2000)
Any optional parameters
ASSIGNEE_ROLE VARCHAR2 (30)
An indicator to determine an assignee's role. The possible values are ASSIGNEE and OWNER.
ENTER_FROM_TASK VARCHAR2 (1)
Task entered from FORM
Query Text

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


SELECT TASK_ID
,      TASK_NUMBER
,      TASK_NAME
,      TASK_TYPE
,      TASK_STATUS
,      TASK_PRIORITY
,      PLANNED_START_DATE
,      PLANNED_END_DATE
,      SCHEDULED_START_DATE
,      SCHEDULED_END_DATE
,      ACTUAL_START_DATE
,      ACTUAL_END_DATE
,      SOURCE_OBJECT_TYPE_CODE
,      SOURCE_OBJECT_TYPE
,      SOURCE_OBJECT_ID
,      SOURCE_OBJECT_NUMBER
,      OWNER_TYPE_CODE
,      OWNER_ID
,      OWNER
,      CUSTOMER_NAME
,      CUST_ACCOUNT_NUMBER
,      GLOBAL_TIMEZONE_NAME
,      GMT_DEVIATION_HOURS
,      DURATION
,      DURATION_UOM
,      ESCALATION_LEVEL
,      ESCALATION_OWNER
,      RESOURCE_ID
,      RESOURCE_TYPE
,      OWNED_FLAG
,      TASK_STATUS_ID
,      TASK_TYPE_ID
,      CLOSED_FLAG
,      OBJECT_FUNCTION
,      OBJECT_PARAMETERS
,      ASSIGNEE_ROLE
,      ENTER_FROM_TASK
FROM APPS.JTF_TASK_UWQ_ALL_V;

Dependencies

[top of page]

APPS.JTF_TASK_UWQ_ALL_V references the following:

SchemaAPPS
SynonymHZ_PARTIES
SynonymHZ_TIMEZONES
SynonymHZ_TIMEZONES_TL
SynonymJTF_OBJECTS_B
SynonymJTF_OBJECTS_TL
SynonymJTF_TASKS_B
SynonymJTF_TASKS_TL
SynonymJTF_TASK_ALL_ASSIGNMENTS
SynonymJTF_TASK_PRIORITIES_TL
ViewJTF_TASK_STATUSES_VL
SynonymJTF_TASK_TYPES_TL
PL/SQL PackageJTF_TASK_UTL - show dependent code

APPS.JTF_TASK_UWQ_ALL_V is not referenced by any database object