View: IGW_PRPO_CATEGORY_AMTS_V

Product:	IGW - Grants Proposal
Description:	View displays summary information about budget lines grouped by sponsor budget hierarchy
Implementation/DBA Data:	APPS.IGW_PRPO_CATEGORY_AMTS_V

View Text

SELECT IB.PROPOSAL_ID
, IB.BUDGET_PERIOD_ID
, 'CC' PERIOD_TYPE
, IB.START_DATE
, IR.PROPOSAL_BUDGET_CATEGORY_CODE
, IR.PROPOSAL_BUDGET_CATEGORY
, IR.PROPOSAL_BUDGET_CATEGORY DESCRIPTION
, IR.PERIOD_TOTAL_DIRECT_COST
, 12 PERIOD_MONTHS
, NULL PERCENT_DOLLAR_FLAG
, IR.EB_TOTAL
FROM IGW_REPORT_BUDGET IR
, IGW_BUDGET_PERIODS IB
, IGW_BUDGETS IBD
WHERE IBD.PROPOSAL_ID = IB.PROPOSAL_ID AND IBD.VERSION_ID = IB.VERSION_ID AND IB.PROPOSAL_ID = IR.PROPOSAL_ID AND IB.VERSION_ID = IR.VERSION_ID AND IB.BUDGET_PERIOD_ID = IR.BUDGET_PERIOD_ID AND IR.PROPOSAL_FORM_NUMBER = IBD.PROPOSAL_FORM_NUMBER AND IR.PROPOSAL_BUDGET_CATEGORY_CODE IN (SELECT BUDGET_CATEGORY_CODE
FROM IGW_REPORT_BUDGET_SEED
WHERE PROPOSAL_FORM_NUMBER = IBD.PROPOSAL_FORM_NUMBER UNION SELECT DISTINCT PROPOSAL_BUDGET_CATEGORY_CODE
FROM IGW_REPORT_BUDGET_SEED
WHERE PROPOSAL_FORM_NUMBER = IBD.PROPOSAL_FORM_NUMBER) UNION SELECT IBP.PROPOSAL_ID
, IBP.BUDGET_PERIOD_ID
, 'CC' PERIOD_TYPE
, IBP.START_DATE
, IBD.BUDGET_CATEGORY_CODE
, FL.MEANING
, IBD.LINE_ITEM_DESCRIPTION DESCRIPTION
, IBD.LINE_ITEM_COST
, 12 PERIOD_MONTHS
, 'DO' PERCENT_DOLLAR_FLAG
, NULL EB_TOTAL FROM IGW_BUDGETS IB
, IGW_BUDGET_PERIODS IBP
, IGW_BUDGET_DETAILS IBD
, FND_LOOKUPS FL WHERE IB.PROPOSAL_ID = IBP.PROPOSAL_ID AND IB.FINAL_VERSION_FLAG = 'Y' AND IB.VERSION_ID = IBP.VERSION_ID AND IBP.PROPOSAL_ID = IBD.PROPOSAL_ID AND IBP.VERSION_ID = IBD.VERSION_ID AND IBP.BUDGET_PERIOD_ID = IBD.BUDGET_PERIOD_ID AND IBD.BUDGET_CATEGORY_CODE = FL.LOOKUP_CODE AND FL.LOOKUP_TYPE = 'IGW_BUDGET_CATEGORY'

Columns