[Home] [Help] [Dependency Information]
Object Name: | JTF_TASK_UWQ_ALL_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | JTF.JTF_TASK_UWQ_ALL_V |
Subobject Name: | |
Status: | VALID |
This view is used to get all the tasks which has an open assignments
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 |
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;
APPS.JTF_TASK_UWQ_ALL_V is not referenced by any database object
|
|
|