FND Design Data [Home] [Help]

View: MRP_TASK_V

Product: MRP - Master Scheduling/MRP
Description: Task information view
Implementation/DBA Data: ViewAPPS.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