[Home] [Help]
VIEW: APPS.PJI_EXP_TYPES_V
Source
View Text - Preformatted
SELECT expenditure_type_id , expenditure_type , expenditure_category_id FROM pa_expenditure_types pet, pa_expenditure_categories pec WHERE pet.expenditure_category = pec.expenditure_category
View Text - HTML Formatted
SELECT EXPENDITURE_TYPE_ID
, EXPENDITURE_TYPE
, EXPENDITURE_CATEGORY_ID
FROM PA_EXPENDITURE_TYPES PET
, PA_EXPENDITURE_CATEGORIES PEC
WHERE PET.EXPENDITURE_CATEGORY = PEC.EXPENDITURE_CATEGORY