[Home] [Help]
View: PJMBV_PROJECT_MFG_INFORMATION
View Text
SELECT P.PROJECT_NUMBER
, MP.ORGANIZATION_CODE
, OU.NAME
, PP.PLANNING_GROUP
, NVL(PP.COSTING_GROUP_ID
, 1)
, PP.WIP_ACCT_CLASS_CODE
, PP.PROJECT_ID
, PP.ORGANIZATION_ID
, PP.CREATION_DATE
, PP.CREATED_BY
, PP.LAST_UPDATE_DATE
, PP.LAST_UPDATED_BY
FROM PJM_PROJECT_PARAMETERS PP
, PJMBV_PROJECT_MFG_PROJECTS P
, MTL_PARAMETERS MP
, HR_ORGANIZATION_UNITS OU
WHERE P.PROJECT_ID = PP.PROJECT_ID
AND MP.ORGANIZATION_ID = PP.ORGANIZATION_ID
AND OU.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND '_SEC:PP.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY
Columns
Name |
PROJECT_NUMBER |
ORGANIZATION_CODE |
ORGANIZATION_NAME |
PLANNING_GROUP |
COST_GROUP_ID |
WIP_ACCT_CLASS_CODE |
PROJECT_ID |
ORGANIZATION_ID |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |