[Home] [Help]
View: IGW_BUDGET_EXPENDITURES_V
| Product: | IGW - Grants Proposal (Obsolete) |
|---|
| Description: | 10SC Only |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT EXPENDITURE_CATEGORY BUDGET_EXPENDITURE
, DESCRIPTION
, BUDGET_CATEGORY_CODE
, EXPENDITURE_CATEGORY
, NULL PARENT_CATEGORY
, PERSONNEL_ATTACHED_FLAG
, 'Y' EXPENDITURE_CATEGORY_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
FROM IGW_EXPENDITURE_CATEGORIES_V UNION SELECT ET.EXPENDITURE_TYPE BUDGET_EXPENDITURE
, ET.DESCRIPTION
, EC.BUDGET_CATEGORY_CODE
, ET.EXPENDITURE_CATEGORY
, ET.EXPENDITURE_CATEGORY PARENT_CATEGORY
, EC.PERSONNEL_ATTACHED_FLAG
, 'N' EXPENDITURE_CATEGORY_FLAG
, ET.START_DATE_ACTIVE
, ET.END_DATE_ACTIVE
FROM IGW_EXPENDITURE_TYPES_V ET
, IGW_EXPENDITURE_CATEGORIES_V EC WHERE EC.EXPENDITURE_CATEGORY = ET.EXPENDITURE_CATEGORY
Columns
| Name |
| BUDGET_EXPENDITURE |
| DESCRIPTION |
| BUDGET_CATEGORY_CODE |
| EXPENDITURE_CATEGORY |
| PARENT_CATEGORY |
| PERSONNEL_ATTACHED_FLAG |
| EXPENDITURE_CATEGORY_FLAG |
| START_DATE_ACTIVE |
| END_DATE_ACTIVE |