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