[Home] [Help]
View: PJM_PROJECTS_ORG_V
Product: | PJM - Project Manufacturing |
Description: | Project Manufacturing enabled Project / Seiban view |
Implementation/DBA Data: |
APPS.PJM_PROJECTS_ORG_V
|
View Text
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
Columns
Name |
INVENTORY_ORGANIZATION_ID |
PROJECT_ID |
PROJECT_NUMBER |
PROJECT_NAME |
PROJECT_DESCRIPTION |
PROJECT_NUMBER_SORT_ORDER |
START_DATE |
COMPLETION_DATE |
COST_GROUP_ID |
PLANNING_GROUP |