eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGW_BUDGET_LINE_CATEGORY_V

Product:	IGW - Grants Proposal (Obsolete)
Description:	View to display expenditure type, its budget category and line item cost for budget lines
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT PBD.PROPOSAL_ID
, PBD.VERSION_ID
, PBD.BUDGET_PERIOD_ID
, PBD.LINE_ITEM_ID
, PBD.LINE_ITEM_COST
, PBD.EXPENDITURE_TYPE
, PBD.LINE_ITEM_DESCRIPTION
, PBD.BUDGET_CATEGORY_CODE
, FL.MEANING BUDGET_CATEGORY
, PBD.BUDGET_JUSTIFICATION
FROM IGW_BUDGET_DETAILS PBD
, IGW_BUDGET_EXPENDITURES_V ET
, IGW_LOOKUPS_V FL
WHERE PBD.EXPENDITURE_TYPE = NVL(ET.BUDGET_EXPENDITURE
, PBD.EXPENDITURE_TYPE) AND PBD.EXPENDITURE_CATEGORY_FLAG = ET.EXPENDITURE_CATEGORY_FLAG
AND PBD.BUDGET_CATEGORY_CODE = FL.LOOKUP_CODE
AND FL.LOOKUP_TYPE = 'IGW_BUDGET_CATEGORY'

Columns

Name
PROPOSAL_ID
VERSION_ID
BUDGET_PERIOD_ID
LINE_ITEM_ID
LINE_ITEM_COST
EXPENDITURE_TYPE
LINE_ITEM_DESCRIPTION
BUDGET_CATEGORY_CODE
BUDGET_CATEGORY
BUDGET_JUSTIFICATION