VIEW: APPS.PJMBV_PROJECT_MFG_INFORMATION

Source

View Text - Preformatted

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

View Text - HTML Formatted

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