[Home] [Help]
View: MRP_PROJECT_V
| Product: | MRP - Master Scheduling/MRP |
| Description: | Project information view |
| Implementation/DBA Data: |
APPS.MRP_PROJECT_V
|
View Text
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
Columns
| Name |
| PROJECT_ID |
| PROJECT_NUMBER |
| PROJECT_NAME |
| PLANNING_GROUP |
| DUMMY |