[Home] [Help] [Dependency Information]
Object Name: | ICX_EDM_PLANNER_TASK_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ICX.ICX_EDM_PLANNER_TASK_V |
Subobject Name: | |
Status: | VALID |
A Web view designed to simplify access from Oracle Self-Service Web Applications.
The ICX_EDM_PLANNER_TASK_V view returns task summary information
associated with manufacturing plans in Oracle Manufacturing by planner
employee.
.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TASK_ID | NUMBER | Task unique identifier | ||
TASK_NUMBER | VARCHAR2 | (25) | Task number | |
TASK_NAME | VARCHAR2 | (20) | 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) | Task owning organization name | |
TASK_ORGANIZATION_ID | NUMBER | (15) | 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 | Project unique identifier | ||
PROJECT_NUMBER | VARCHAR2 | (25) | Project number | |
PROJECT_NAME | VARCHAR2 | (30) | Project name | |
PROJECT_DESCRIPTION | VARCHAR2 | (250) | Project description | |
PLANNER_EMPLOYEE_ID | NUMBER | Manufacturing planner employee unique identifier | ||
PLANNER_NAME | VARCHAR2 | (240) | Manufacturing planner 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
, PLANNER_EMPLOYEE_ID
, PLANNER_NAME
FROM APPS.ICX_EDM_PLANNER_TASK_V;
APPS.ICX_EDM_PLANNER_TASK_V is not referenced by any database object
|
|
|