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_REPORT_BUDGET_V

Product:	IGW - Grants Proposal
Description:	10SC Only
Implementation/DBA Data:	APPS.IGW_REPORT_BUDGET_V

View Text

SELECT DISTINCT PROPOSAL_BUDGET_CATEGORY_CODE
, PROPOSAL_BUDGET_CATEGORY
, ROUND(IGW_REPORT_PROCESSING.GET_PERIOD_TOTAL(PROPOSAL_BUDGET_CATEGORY_CODE
, 1)) PERIOD1_TOTAL
, ROUND(IGW_REPORT_PROCESSING.GET_PERIOD_TOTAL(PROPOSAL_BUDGET_CATEGORY_CODE
, 2)) PERIOD2_TOTAL
, ROUND(IGW_REPORT_PROCESSING.GET_PERIOD_TOTAL(PROPOSAL_BUDGET_CATEGORY_CODE
, 3)) PERIOD3_TOTAL
, ROUND(IGW_REPORT_PROCESSING.GET_PERIOD_TOTAL(PROPOSAL_BUDGET_CATEGORY_CODE
, 4)) PERIOD4_TOTAL
, ROUND(IGW_REPORT_PROCESSING.GET_PERIOD_TOTAL(PROPOSAL_BUDGET_CATEGORY_CODE
, 5)) PERIOD5_TOTAL
FROM IGW_REPORT_BUDGET WHERE PROPOSAL_FORM_NUMBER = 'PHS 398' AND BUDGET_PERIOD_ID = (SELECT MIN(BUDGET_PERIOD_ID)
FROM IGW_REPORT_BUDGET)

Columns

Name
PROPOSAL_BUDGET_CATEGORY_CODE
PROPOSAL_BUDGET_CATEGORY
PERIOD1_TOTAL
PERIOD2_TOTAL
PERIOD3_TOTAL
PERIOD4_TOTAL
PERIOD5_TOTAL