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: IGWFV_GRANT_PROPOSAL_OVRD_RATE

Product:	IGW - Grants Proposal
Description:
Implementation/DBA Data:	APPS.IGWFV_GRANT_PROPOSAL_OVRD_RATE

View Text

SELECT PR.PROPOSAL_NUMBER
, PRATES.VERSION_ID
, RCLASS.DESCRIPTION
, RTYPE.DESCRIPTION
, PRATES.FISCAL_YEAR
, LKUP2.MEANING
, LKUP1.MEANING
, PRATES.START_DATE
, PRATES.APPLICABLE_RATE
, PRATES.INSTITUTE_RATE
, PR.PROPOSAL_ID
, PRATES.RATE_CLASS_ID
, PRATES.RATE_TYPE_ID
, PRATES.LAST_UPDATE_DATE
, PRATES.LAST_UPDATED_BY
, PRATES.CREATION_DATE
, PRATES.CREATED_BY
FROM IGW_PROP_RATES PRATES
, IGW_PROPOSALS_ALL PR
, IGW_LOOKUPS_V LKUP1
, IGW_RATE_CLASSES RCLASS
, IGW_RATE_TYPES RTYPE
, IGW_LOOKUPS_V LKUP2
WHERE PR.PROPOSAL_ID = PRATES.PROPOSAL_ID
AND LKUP1.LOOKUP_TYPE = 'IGW_ACTIVITY_TYPES'
AND LKUP1.LOOKUP_CODE = PRATES.ACTIVITY_TYPE_CODE
AND RCLASS.RATE_CLASS_ID = PRATES.RATE_CLASS_ID
AND RTYPE.RATE_TYPE_ID = PRATES.RATE_TYPE_ID
AND LKUP2.LOOKUP_TYPE = 'IGW_LOCATION'
AND LKUP2.LOOKUP_CODE = PRATES.LOCATION_CODE WITH READ ONLY

Columns

Name
PROPOSAL_NUMBER
BUDGET_VERSION_ID
RATE_CLASS_DESCRIPTION
RATE_TYPE_DESCRIPTION
FISCAL_YEAR
LOCATION
ACTIVITY_TYPE
START_DATE
APPLICABLE_RATE
INSTITUTE_RATE
PROPOSAL_ID
RATE_CLASS_ID
RATE_TYPE_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY