View: PJMBV_PROJECT_MFG_INFORMATION

Product:	PJM - Project Manufacturing
Description:	Project Manufacturing Information
Implementation/DBA Data:	APPS.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