VIEW: APPS.IGWBV_GRANT_PROPOSAL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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