VIEW: APPS.MRP_PROJECT_V

Source

View Text - Preformatted

SELECT PROJECT_ID , PROJECT_NUMBER , PROJECT_NAME , PLANNING_GROUP , TO_NUMBER(NULL) FROM MTL_PROJECT_V UNION ALL SELECT TO_NUMBER(NULL), TO_CHAR(NULL), TO_CHAR(NULL), TO_CHAR(NULL), 1 FROM DUAL

View Text - HTML Formatted

SELECT PROJECT_ID
, PROJECT_NUMBER
, PROJECT_NAME
, PLANNING_GROUP
, TO_NUMBER(NULL)
FROM MTL_PROJECT_V UNION ALL SELECT TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, 1
FROM DUAL