[Home] [Help]
View: PJM_ORG_PROJECTS_V
Product: | PJM - Project Manufacturing |
Description: | Project Manufacturing enabled Project / Seiban view |
Implementation/DBA Data: |
APPS.PJM_ORG_PROJECTS_V
|
View Text
SELECT P.PROJECT_ID
, P.PROJECT_NUMBER
, P.PROJECT_NAME
, P.PROJECT_DESCRIPTION
, P.START_DATE
, P.COMPLETION_DATE
, P.PROJECT_NUMBER_SORT_ORDER
, MRP_GET_PROJECT.PLANNING_GROUP(P.PROJECT_ID)
FROM PJM_PROJECTS_V P
WHERE EXISTS ( SELECT 1
FROM PJM_PROJECT_PARAMETERS
WHERE PROJECT_ID = P.PROJECT_ID )
Columns
Name |
PROJECT_ID |
PROJECT_NUMBER |
PROJECT_NAME |
PROJECT_DESCRIPTION |
START_DATE |
COMPLETION_DATE |
PROJECT_NUMBER_SORT_ORDER |
PLANNING_GROUP |