View: PA_EXPENDITURE_TYPES_DESC_V

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

View Text

SELECT ET.ROWID ROW_ID
, ET.EXPENDITURE_TYPE
, ET.LAST_UPDATE_DATE
, ET.LAST_UPDATED_BY
, ET.CREATION_DATE
, ET.CREATED_BY
, ET.LAST_UPDATE_LOGIN
, ET.EXPENDITURE_CATEGORY
, CT.DESCRIPTION EXPENDITURE_CATEGORY_DESC
, ET.REVENUE_CATEGORY_CODE
, RC.MEANING REVENUE_CATEGORY_NAME
, ET.SYSTEM_LINKAGE_FUNCTION
, ET.UNIT_OF_MEASURE
, UM.MEANING UOM
, ET.START_DATE_ACTIVE
, ET.COST_RATE_FLAG
, ET.END_DATE_ACTIVE
, ET.DESCRIPTION
, ET.ATTRIBUTE_CATEGORY
, ET.ATTRIBUTE1
, ET.ATTRIBUTE2
, ET.ATTRIBUTE3
, ET.ATTRIBUTE4
, ET.ATTRIBUTE5
, ET.ATTRIBUTE6
, ET.ATTRIBUTE7
, ET.ATTRIBUTE8
, ET.ATTRIBUTE9
, ET.ATTRIBUTE10
, ET.ATTRIBUTE11
, ET.ATTRIBUTE12
, ET.ATTRIBUTE13
, ET.ATTRIBUTE14
, ET.ATTRIBUTE15
FROM PA_EXPENDITURE_CATEGORIES CT
, PA_LOOKUPS RC
, PA_LOOKUPS UM
, PA_EXPENDITURE_TYPES ET
WHERE ET.EXPENDITURE_CATEGORY = CT.EXPENDITURE_CATEGORY
AND RC.LOOKUP_TYPE = 'REVENUE CATEGORY'
AND ET.REVENUE_CATEGORY_CODE = RC.LOOKUP_CODE
AND UM.LOOKUP_TYPE = 'UNIT'
AND ET.UNIT_OF_MEASURE = UM.LOOKUP_CODE

Columns