VIEW: APPS.IGW_AWARDS_V

Source

View Text - Preformatted

SELECT ga.award_id, ga.award_number, ga.funding_source_award_number, ga.status, ga.award_full_name, ga.funding_source_id, substrb(p.party_name,1,50) 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, hz_parties p, hz_cust_accounts c WHERE p.party_id(+) = c.party_id and c.cust_account_id(+) = nvl(ga.funding_source_id, -10) AND ga.award_template_flag = 'DEFERRED'

View Text - HTML Formatted

SELECT GA.AWARD_ID
, GA.AWARD_NUMBER
, GA.FUNDING_SOURCE_AWARD_NUMBER
, GA.STATUS
, GA.AWARD_FULL_NAME
, GA.FUNDING_SOURCE_ID
, SUBSTRB(P.PARTY_NAME
, 1
, 50) 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
, HZ_PARTIES P
, HZ_CUST_ACCOUNTS C
WHERE P.PARTY_ID(+) = C.PARTY_ID
AND C.CUST_ACCOUNT_ID(+) = NVL(GA.FUNDING_SOURCE_ID
, -10)
AND GA.AWARD_TEMPLATE_FLAG = 'DEFERRED'