View: PJMFV_PROJECT_MFG_INFORMATION

Product:	PJM - Project Manufacturing
Description:	Project Manufacturing Information
Implementation/DBA Data:	APPS.PJMFV_PROJECT_MFG_INFORMATION

View Text

SELECT P.PROJECT_NUMBER
, MP.ORGANIZATION_CODE
, OU.NAME
, PP.PLANNING_GROUP
, CG.COST_GROUP
, PP.WIP_ACCT_CLASS_CODE
, '_DF:PJM:PJM_PROJECT_PARAMETERS:PP'
, PP.PROJECT_ID
, PP.ORGANIZATION_ID
, NVL(PP.COSTING_GROUP_ID
, 1)
, 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
, CST_COST_GROUPS CG
WHERE P.PROJECT_ID = PP.PROJECT_ID
AND MP.ORGANIZATION_ID = PP.ORGANIZATION_ID
AND OU.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND CG.COST_GROUP_ID = NVL(PP.COSTING_GROUP_ID
, 1)
AND '_SEC:PP.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns