View: PAFV_PROJECT_TYPES

Product:	PA - Projects
Description:	Business view to show information about the types of projects.
Implementation/DBA Data:	APPS.PAFV_PROJECT_TYPES

View Text

SELECT PPTA.PROJECT_TYPE
, HOU.ORGANIZATION_ID
, TL.NAME
, PPTA.DESCRIPTION
, '_LA:PROJECT_TYPE_CLASS_CODE:PA_LOOKUPS:PROJECT TYPE CLASS:MEANING'
, '_LA:BURDEN_COST_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, PPTA.START_DATE_ACTIVE
, PPTA.END_DATE_ACTIVE
, '_DF:PA:PA_PROJECT_TYPES_DESC_FLEX:PPTA'
, PPTA.LAST_UPDATE_DATE
, PPTA.LAST_UPDATED_BY
, PPTA.CREATION_DATE
, PPTA.CREATED_BY
FROM PA_PROJECT_TYPES_ALL PPTA
, HR_ALL_ORGANIZATION_UNITS HOU
, HR_ALL_ORGANIZATION_UNITS_TL TL
WHERE PPTA.ORG_ID = HOU.ORGANIZATION_ID(+)
AND PPTA.ORG_ID = TL.ORGANIZATION_ID(+)
AND TL.LANGUAGE = USERENV('LANG')
AND '_SEC:PPTA.ORG_ID' IS NOT NULL WITH READ ONLY

Columns