[Home] [Help] [Dependency Information]
Object Name: | ICX_EDM_PROJECT_TASK_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ICX.ICX_EDM_PROJECT_TASK_V |
Subobject Name: | |
Status: | VALID |
A Web view designed to simplify access from Oracle Self-Service Web Applications.
The ICX_EDM_PROJECT_TASK_V view returns all tasks.
.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TASK_ID | NUMBER | (15) | Yes | Task unique identifier |
TASK_NUMBER | VARCHAR2 | (25) | Yes | Task number |
NAME | VARCHAR2 | (20) | Yes | Task name |
DESCRIPTION | VARCHAR2 | (250) | Task description | |
MANAGER | VARCHAR2 | (240) | Task manager | |
START_DATE | DATE | Task start date | ||
END_DATE | DATE | Task end date | ||
ORGANIZATION_NAME | VARCHAR2 | (240) | Yes | Task owning organization name |
ORGANIZATION_ID | NUMBER | (15) | Yes | Task owning organization unique identifier |
LOCATION_CODE | VARCHAR2 | (60) | Task owning orgniazation location | |
LOCATION_DESCRIPTION | VARCHAR2 | (240) | Task owning organization location description | |
PROJECT_ID | NUMBER | (15) | Yes | Project unique identifier |
PROJECT_NUMBER | VARCHAR2 | (25) | Yes | Project number |
PROJECT_NAME | VARCHAR2 | (30) | Yes | Project name |
PROJECT_DESCRIPTION | VARCHAR2 | (250) | Project description |
Cut, paste (and edit) the following text to query this object:
SELECT TASK_ID
, TASK_NUMBER
, NAME
, DESCRIPTION
, MANAGER
, START_DATE
, END_DATE
, ORGANIZATION_NAME
, ORGANIZATION_ID
, LOCATION_CODE
, LOCATION_DESCRIPTION
, PROJECT_ID
, PROJECT_NUMBER
, PROJECT_NAME
, PROJECT_DESCRIPTION
FROM APPS.ICX_EDM_PROJECT_TASK_V;
APPS.ICX_EDM_PROJECT_TASK_V is not referenced by any database object
|
|
|