View: PABV_PROJECT_TYPES

Product:	PA - Projects
Description:	- Retrofitted
Implementation/DBA Data:	APPS.PABV_PROJECT_TYPES

View Text

SELECT PPTA.PROJECT_TYPE
, HOU.ORGANIZATION_ID
, T.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 T
WHERE PPTA.ORG_ID = HOU.ORGANIZATION_ID(+)
AND PPTA.ORG_ID = T.ORGANIZATION_ID(+)
AND T.LANGUAGE(+) = USERENV('LANG')
AND '_SEC:PPTA.ORG_ID' IS NOT NULL WITH READ ONLY

Columns