View: PJM_PROJECT_PARAMETERS_V

Product:	PJM - Project Manufacturing
Description:	Project Manufacturing Project Parameters view.
Implementation/DBA Data:	APPS.PJM_PROJECT_PARAMETERS_V

View Text

SELECT PPP.ROWID
, PPP.PROJECT_ID
, PPP.CREATION_DATE
, PPP.CREATED_BY
, PPP.LAST_UPDATE_DATE
, PPP.LAST_UPDATED_BY
, PPP.LAST_UPDATE_LOGIN
, P.PROJECT_NUMBER
, P.PROJECT_NAME
, PPP.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, HOU.NAME
, PPP.PLANNING_GROUP
, NULL
, PPP.COSTING_GROUP_ID
, CG.COST_GROUP
, PPP.WIP_ACCT_CLASS_CODE
, PPP.EAM_ACCT_CLASS_CODE
, PPP.PPV_EXPENDITURE_TYPE
, PPP.DIR_ITEM_EXPENDITURE_TYPE
, PPP.IPV_EXPENDITURE_TYPE
, PPP.ERV_EXPENDITURE_TYPE
, PPP.FREIGHT_EXPENDITURE_TYPE
, PPP.TAX_EXPENDITURE_TYPE
, PPP.MISC_EXPENDITURE_TYPE
, PPP.SEIBAN_NUMBER_FLAG
, PPP.START_DATE_ACTIVE
, PPP.END_DATE_ACTIVE
, PPP.ATTRIBUTE_CATEGORY
, PPP.ATTRIBUTE1
, PPP.ATTRIBUTE2
, PPP.ATTRIBUTE3
, PPP.ATTRIBUTE4
, PPP.ATTRIBUTE5
, PPP.ATTRIBUTE6
, PPP.ATTRIBUTE7
, PPP.ATTRIBUTE8
, PPP.ATTRIBUTE9
, PPP.ATTRIBUTE10
, PPP.ATTRIBUTE11
, PPP.ATTRIBUTE12
, PPP.ATTRIBUTE13
, PPP.ATTRIBUTE14
, PPP.ATTRIBUTE15
FROM PJM_PROJECT_PARAMETERS PPP
, HR_ALL_ORGANIZATION_UNITS_TL HOU
, MTL_PARAMETERS MP
, CST_COST_GROUPS CG
, ( SELECT PROJECT_ID
, SEGMENT1 PROJECT_NUMBER
, NAME PROJECT_NAME
FROM PA_PROJECTS_ALL UNION ALL SELECT PROJECT_ID
, PROJECT_NUMBER
, PROJECT_NAME
FROM PJM_SEIBAN_NUMBERS ) P
WHERE P.PROJECT_ID = PPP.PROJECT_ID
AND CG.COST_GROUP_ID (+) = PPP.COSTING_GROUP_ID
AND MP.ORGANIZATION_ID = PPP.ORGANIZATION_ID
AND HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND HOU.LANGUAGE = USERENV('LANG')

Columns