VIEW: APPS.MRP_TASK_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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