Skip to content
[Home] [Help]
View: 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 |