VIEW: APPS.PJM_PROJECTS_ORG_V

Source

View Text - Preformatted

SELECT PP.ORGANIZATION_ID , P.PROJECT_ID , P.PROJECT_NUMBER , P.PROJECT_NAME , P.PROJECT_DESCRIPTION , P.PROJECT_NUMBER_SORT_ORDER , P.START_DATE , P.COMPLETION_DATE , PP.COSTING_GROUP_ID , PP.PLANNING_GROUP FROM PJM_PROJECTS_V P , PJM_PROJECT_PARAMETERS PP WHERE PP.PROJECT_ID = P.PROJECT_ID

View Text - HTML Formatted

SELECT PP.ORGANIZATION_ID
, P.PROJECT_ID
, P.PROJECT_NUMBER
, P.PROJECT_NAME
, P.PROJECT_DESCRIPTION
, P.PROJECT_NUMBER_SORT_ORDER
, P.START_DATE
, P.COMPLETION_DATE
, PP.COSTING_GROUP_ID
, PP.PLANNING_GROUP
FROM PJM_PROJECTS_V P
, PJM_PROJECT_PARAMETERS PP
WHERE PP.PROJECT_ID = P.PROJECT_ID