[Home] [Help]
View: PJI_EXP_TYPES_V
Product: | PJI - Project Intelligence(Obsolete) |
Description: | This is an internal summarization view. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
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
Columns
Name |
ID |
VALUE |
EXPENDITURE_CATEGORY |