VIEW: APPS.PJM_PROJECT_PARAMETERS_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')