DBA Data[Home] [Help]

VIEW: APPS.PJI_EXP_EVT_TYPES_V

Source

View Text - Preformatted

SELECT expenditure_type_id , expenditure_type , revenue_category_code FROM pa_expenditure_types UNION ALL Select event_type_id , event_type , revenue_category_code FROM pa_event_types
View Text - HTML Formatted

SELECT EXPENDITURE_TYPE_ID
, EXPENDITURE_TYPE
, REVENUE_CATEGORY_CODE
FROM PA_EXPENDITURE_TYPES UNION ALL SELECT EVENT_TYPE_ID
, EVENT_TYPE
, REVENUE_CATEGORY_CODE
FROM PA_EVENT_TYPES