View: IGW_BUDGET_LINE_CATEGORY_V

Product:	IGW - Grants Proposal
Description:	View to display expenditure type, its budget category and line item cost for budget lines
Implementation/DBA Data:	APPS.IGW_BUDGET_LINE_CATEGORY_V

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