VIEW: APPS.IGW_OH_EXPENDITURE_CAT_TYPES_V

Source

View Text - Preformatted

SELECT expenditure_category, description, expenditure_category, 'C' from pa_expenditure_categories union select expenditure_type, description, expenditure_category, 'T' from pa_expenditure_types

View Text - HTML Formatted

SELECT EXPENDITURE_CATEGORY
, DESCRIPTION
, EXPENDITURE_CATEGORY
, 'C'
FROM PA_EXPENDITURE_CATEGORIES UNION SELECT EXPENDITURE_TYPE
, DESCRIPTION
, EXPENDITURE_CATEGORY
, 'T'
FROM PA_EXPENDITURE_TYPES