[Home] [Help]
View: MRP_TASK_V
| Product: | MRP - Master Scheduling/MRP |
| Description: | Task information view |
| Implementation/DBA Data: |
APPS.MRP_TASK_V
|
View Text
SELECT PROJECT_ID
, PROJECT_NUMBER
, PROJECT_NAME
, TASK_ID
, TASK_NUMBER
, TASK_NAME
FROM MTL_TASK_V UNION ALL SELECT TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
FROM DUAL
Columns
| Name |
| PROJECT_ID |
| PROJECT_NUMBER |
| PROJECT_NAME |
| TASK_ID |
| TASK_NUMBER |
| TASK_NAME |