View: IGWBV_GRANT_PROPOSAL

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

View Text

SELECT PR.PROPOSAL_NUMBER
, PR.LEAD_ORGANIZATION_ID
, PR.ORG_ID
, '_LA:PROPOSAL_STATUS:IGW_LOOKUPS_V:IGW_PROPOSAL_STATUS:MEANING'
, PR.PROPOSAL_START_DATE
, PR.PROPOSAL_END_DATE
, PR.PROPOSAL_TITLE
, LKUP2.MEANING PROPOSAL_TYPE
, PR.AWARD_NUMBER
, PR.AWARD_AMOUNT
, PR.ORIGINAL_PROPOSAL_NUMBER
, PR.ORIGINAL_AWARD_NUMBER
, PR.ORIGINAL_PROPOSAL_START_DATE
, PR.ORIGINAL_PROPOSAL_END_DATE
, LKUP3.MEANING ACTIVITY_TYPE
, PR.SPONSOR_ID
, PR.SPONSOR_PROPOSAL_NUMBER
, LKUP4.MEANING
, PR.PROGRAM_NUMBER
, PR.PROGRAM_TITLE
, LKUP5.MEANING
, PR.SPONSOR_ACTION_DATE
, PR.SUBMITTING_ORGANIZATION_ID
, PR.DEADLINE_DATE
, PR.DEADLINE_TYPE
, LKUP6.MEANING NARRATIVE_SUBMISSION
, PR.ORIGINAL_SPONSOR_ID
, PR.LETTER_OF_INTENT_DUE_DATE
, PR.PROGRAM_URL
, PR.FUNDING_SPONSOR_UNIT
, PR.EDI_GENERATED_DATE
, '_DF:IGW:IGW_PROPOSALS_DESC_FLEX:PR'
, IGW_PROP.GET_NARRATIVE_STATUS(PR.PROPOSAL_ID) NARRATIVE_STATUS
, PR.NARRATIVE_TYPE_CODE
, PR.PROPOSAL_ID
, PR.LAST_UPDATE_DATE
, PR.LAST_UPDATED_BY
, PR.CREATION_DATE
, PR.CREATED_BY
FROM IGW_PROPOSALS_ALL PR
, IGW_LOOKUPS_V LKUP2
, IGW_LOOKUPS_V LKUP3
, IGW_LOOKUPS_V LKUP4
, IGW_LOOKUPS_V LKUP5
, IGW_LOOKUPS_V LKUP6
WHERE LKUP2.LOOKUP_TYPE = 'IGW_PROPOSAL_TYPES'
AND PR.PROPOSAL_TYPE_CODE = LKUP2.LOOKUP_CODE
AND LKUP3.LOOKUP_TYPE = 'IGW_ACTIVITY_TYPES'
AND PR.ACTIVITY_TYPE_CODE = LKUP3.LOOKUP_CODE
AND LKUP4.LOOKUP_TYPE(+) = 'IGW_OPPORTUNITY_NOTICE_TYPES'
AND LKUP4.LOOKUP_CODE(+) = PR.NOTICE_OF_OPPORTUNITY_CODE
AND LKUP5.LOOKUP_TYPE(+) = 'IGW_SPONSOR_ACTION_CODE'
AND LKUP5.LOOKUP_CODE(+) = PR.SPONSOR_ACTION_CODE
AND LKUP6.LOOKUP_TYPE(+) = 'IGW_NARRATIVE_SUBMISS_TYPES'
AND LKUP6.LOOKUP_CODE(+) = PR.NARRATIVE_SUBMISSION_CODE WITH READ ONLY

Columns