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