View: IGW_AWARDS_V

Product:	IGW - Grants Proposal
Description:	A view that shows information about all awards and their corresponding proposal identifiers, if any.
Implementation/DBA Data:	APPS.IGW_AWARDS_V

View Text

SELECT GA.AWARD_ID
, GA.AWARD_NUMBER
, GA.FUNDING_SOURCE_AWARD_NUMBER
, GA.STATUS
, GA.AWARD_FULL_NAME
, GA.FUNDING_SOURCE_ID
, RC.CUSTOMER_NAME FUNDING_SOURCE_NAME
, GA.START_DATE_ACTIVE
, GA.END_DATE_ACTIVE
, GA.CLOSE_DATE
, GA.LAST_UPDATE_DATE
, GA.LAST_UPDATED_BY
, GA.CREATION_DATE
, GA.CREATED_BY
, GA.LAST_UPDATE_LOGIN
, GA.PROPOSAL_ID
, IGW_VIEW_PARAMETERS.GET_MAJOR_GOALS(GA.PROPOSAL_ID) MAJOR_GOALS
FROM GMS_AWARDS GA
, RA_CUSTOMERS RC
WHERE RC.CUSTOMER_ID(+) = NVL(GA.FUNDING_SOURCE_ID
, -10)
AND GA.AWARD_TEMPLATE_FLAG = 'DEFERRED'

Columns