FND Design Data [Home] [Help]

View: MRP_PROJECT_V

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