[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 |