[Home] [Help] [Dependency Information]
Object Name: | JTF_TASK_UWQ_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | JTF.JTF_TASK_UWQ_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TASK_ID | NUMBER | Yes | ||
TASK_NUMBER | VARCHAR2 | (30) | Yes | |
TASK_NAME | VARCHAR2 | (80) | Yes | |
TASK_TYPE | VARCHAR2 | (30) | Yes | |
TASK_STATUS | VARCHAR2 | (30) | Yes | |
TASK_PRIORITY | VARCHAR2 | (30) | ||
PLANNED_START_DATE | DATE | |||
PLANNED_END_DATE | DATE | |||
SCHEDULED_START_DATE | DATE | |||
SCHEDULED_END_DATE | DATE | |||
ACTUAL_START_DATE | DATE | |||
ACTUAL_END_DATE | DATE | |||
SOURCE_OBJECT_TYPE_CODE | VARCHAR2 | (30) | ||
SOURCE_OBJECT_TYPE | VARCHAR2 | (30) | Yes | |
SOURCE_OBJECT_ID | NUMBER | |||
SOURCE_OBJECT_NUMBER | VARCHAR2 | (80) | Source Object Number | |
OWNER_TYPE_CODE | VARCHAR2 | (0) | ||
OWNER_ID | VARCHAR2 | (0) | ||
OWNER | VARCHAR2 | (4000) | ||
CUSTOMER_NAME | VARCHAR2 | (360) | ||
CUST_ACCOUNT_NUMBER | VARCHAR2 | (0) | ||
GLOBAL_TIMEZONE_NAME | VARCHAR2 | (80) | ||
GMT_DEVIATION_HOURS | NUMBER | |||
DURATION | NUMBER | |||
DURATION_UOM | VARCHAR2 | (3) | ||
ESCALATION_LEVEL | VARCHAR2 | (0) | ||
ESCALATION_OWNER | VARCHAR2 | (0) | ||
RESOURCE_ID | NUMBER | Yes | ||
RESOURCE_TYPE | VARCHAR2 | (30) | Yes | |
OWNED_FLAG | VARCHAR2 | (30) | ||
TASK_STATUS_ID | NUMBER | Yes | ||
TASK_TYPE_ID | NUMBER | Yes | ||
CLOSED_FLAG | CHAR | (1) | ||
OBJECT_FUNCTION | VARCHAR2 | (30) | ||
OBJECT_PARAMETERS | VARCHAR2 | (2000) | ||
ASSIGNEE_ROLE | VARCHAR2 | (30) | Assignee Role | |
ENTER_FROM_TASK | VARCHAR2 | (1) |
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_V;
|
|
|