View: PAFV_EXPENDITURE_TYPES

Product:	PA - Projects
Description:	Business view to show the classification of the expenditures charged.
Implementation/DBA Data:	APPS.PAFV_EXPENDITURE_TYPES

View Text

SELECT PAT.EXPENDITURE_TYPE
, PAT.DESCRIPTION
, '_LA:PAT.UNIT_OF_MEASURE:PA_LOOKUPS:UNIT:MEANING'
, PAT.REVENUE_CATEGORY_CODE
, PAL.DESCRIPTION
, PAT.EXPENDITURE_CATEGORY
, PEC.DESCRIPTION
, PAT.START_DATE_ACTIVE
, PAT.END_DATE_ACTIVE
, '_LA:COST_RATE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_DF:PA:PA_EXPENDITURE_TYPES_DESC_FLEX:PAT'
, PAT.LAST_UPDATE_DATE
, PAT.LAST_UPDATED_BY
, PAT.CREATION_DATE
, PAT.CREATED_BY
FROM PA_EXPENDITURE_TYPES PAT
, PA_EXPENDITURE_CATEGORIES PEC
, PA_LOOKUPS PAL
WHERE PAT.EXPENDITURE_CATEGORY = PEC.EXPENDITURE_CATEGORY AND PAT.REVENUE_CATEGORY_CODE = PAL.LOOKUP_CODE AND PAL.LOOKUP_TYPE='REVENUE CATEGORY' WITH READ ONLY

Columns