VIEW: APPS.PA_EXPENDITURE_TYPES_DESC_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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