Product: | IGW - Grants Proposal |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGW_PROP_V |
SELECT IPA.PROPOSAL_ID
, IPA.PROPOSAL_NUMBER
, IPA.PROPOSAL_TYPE_CODE
, IPP.PERSON_ID PI_ID
, PPX.FULL_NAME PI_NAME
, IPA.SPONSOR_ID
, RC.CUSTOMER_NAME SPONSOR_NAME
, IGW_VIEW_PARAMETERS.GET_PROJECT_LOCATION_ID (IPA.PROPOSAL_ID) PROJECT_LOCATION_ID
, IGW_VIEW_PARAMETERS.GET_PROJECT_LOCATION_NAME(IGW_VIEW_PARAMETERS.GET_PROJECT_LOCATION_ID (IPA.PROPOSAL_ID) ) PROJECT_LOCATION_NAME
, IGW_VIEW_PARAMETERS.GET_MAJOR_GOALS(IPA.PROPOSAL_ID) MAJOR_GOALS
, IPA.PROPOSAL_START_DATE
, IPA.PROPOSAL_END_DATE
, IGW_PROP_COSTS.GET_ANNUAL_DIRECT_COSTS ( IPA.PROPOSAL_ID) ANNUAL_DIRECT_COST
, IGW_PROP_COSTS.GET_TOTAL_COSTS (IPA.PROPOSAL_ID) TOTAL_COST
, IPA.PROPOSAL_TITLE
, IPA.SPONSOR_ACTION_CODE
, IPA.LAST_UPDATE_DATE
, IPA.LAST_UPDATED_BY
, IPA.CREATION_DATE
, IPA.CREATED_BY
, IPA.LAST_UPDATE_LOGIN
FROM IGW_PROPOSALS IPA
, IGW_PROP_PERSONS IPP
, PER_PEOPLE_X PPX
, RA_CUSTOMERS RC
WHERE IPP.PROPOSAL_ID = IPA.PROPOSAL_ID
AND IPP.PI_FLAG = 'Y'
AND PPX.PERSON_ID = IPP.PERSON_ID
AND RC.CUSTOMER_ID = IPA.SPONSOR_ID