[Home] [Help] [Dependency Information]
Object Name: | ICX_EDM_KEY_MEMBER_TASK_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ICX.ICX_EDM_KEY_MEMBER_TASK_V |
Subobject Name: | |
Status: | VALID |
A Web view designed to simplify access from Oracle Self-Service Web Applications.
The ICX_EDM_KEY_MEMBER_TASK_V view returns task summary information by
key member.
.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TASK_ID | NUMBER | (15) | Yes | Task unique identifier |
TASK_NUMBER | VARCHAR2 | (25) | Yes | Task number |
TASK_NAME | VARCHAR2 | (20) | Yes | Task name |
TASK_DESCRIPTION | VARCHAR2 | (250) | Task description | |
TASK_MANAGER | VARCHAR2 | (240) | Task manager name | |
TASK_START_DATE | DATE | Task start date | ||
TASK_END_DATE | DATE | Task end date | ||
TASK_ORGANIZATION | VARCHAR2 | (240) | Yes | Task owning organization name |
TASK_ORGANIZATION_ID | NUMBER | (15) | Yes | Task owning organization unique identifier |
TASK_LOCATION | VARCHAR2 | (60) | Task owning organization location | |
TASK_LOCATION_DESCRIPTION | VARCHAR2 | (240) | Task owning organization location description | |
PROJECT_ID | NUMBER | Yes | Project unique identifier | |
PROJECT_NUMBER | VARCHAR2 | (25) | Yes | Project number |
PROJECT_NAME | VARCHAR2 | (30) | Yes | Project name |
PROJECT_DESCRIPTION | VARCHAR2 | (250) | Project description | |
KEY_MEMBER_ID | NUMBER | (15) | Yes | Project manager / adminstrator employee unique identifier |
KEY_MEMBER_NAME | VARCHAR2 | (240) | Project manager / adminstrator employee name |
Cut, paste (and edit) the following text to query this object:
SELECT TASK_ID
, TASK_NUMBER
, TASK_NAME
, TASK_DESCRIPTION
, TASK_MANAGER
, TASK_START_DATE
, TASK_END_DATE
, TASK_ORGANIZATION
, TASK_ORGANIZATION_ID
, TASK_LOCATION
, TASK_LOCATION_DESCRIPTION
, PROJECT_ID
, PROJECT_NUMBER
, PROJECT_NAME
, PROJECT_DESCRIPTION
, KEY_MEMBER_ID
, KEY_MEMBER_NAME
FROM APPS.ICX_EDM_KEY_MEMBER_TASK_V;
APPS.ICX_EDM_KEY_MEMBER_TASK_V is not referenced by any database object
|
|
|