VIEW: APPS.IGWFV_GRANT_PROPOSAL

Source

View Text - Preformatted

SELECT PR. PROPOSAL_NUMBER , hr2.name , '_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, substrb(p1.party_name,1,50) SPONSOR_NAME , PR.SPONSOR_PROPOSAL_NUMBER , LKUP4.meaning notice_of_opportunity, PR.PROGRAM_NUMBER , PR.PROGRAM_TITLE , LKUP5.meaning SPONSOR_ACTION, PR.SPONSOR_ACTION_DATE , hr3.name , PR.DEADLINE_DATE , PR.DEADLINE_TYPE , LKUP6.meaning NARRATIVE_SUBMISSION, substrb(p2.party_name,1,50) customer_name, 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.lead_organization_id, PR.SUBMITTING_ORGANIZATION_ID , PR.org_id , PR.SPONSOR_ID , PR.ORIGINAL_SPONSOR_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, hr_all_organization_units hr2, hr_all_organization_units hr3, hz_parties p1, hz_cust_accounts c1, hz_parties p2, hz_cust_accounts c2 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 and hr2.organization_id = PR.lead_organization_id and hr3.organization_id = PR.submitting_organization_id and c1.party_id = p1.party_id and c1.cust_account_id = PR.sponsor_id and c1.party_id = p1.party_id(+) and c1.cust_account_id(+) = PR.original_sponsor_id with read only

View Text - HTML Formatted

SELECT PR. PROPOSAL_NUMBER
, HR2.NAME
, '_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
, SUBSTRB(P1.PARTY_NAME
, 1
, 50) SPONSOR_NAME
, PR.SPONSOR_PROPOSAL_NUMBER
, LKUP4.MEANING NOTICE_OF_OPPORTUNITY
, PR.PROGRAM_NUMBER
, PR.PROGRAM_TITLE
, LKUP5.MEANING SPONSOR_ACTION
, PR.SPONSOR_ACTION_DATE
, HR3.NAME
, PR.DEADLINE_DATE
, PR.DEADLINE_TYPE
, LKUP6.MEANING NARRATIVE_SUBMISSION
, SUBSTRB(P2.PARTY_NAME
, 1
, 50) CUSTOMER_NAME
, 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.LEAD_ORGANIZATION_ID
, PR.SUBMITTING_ORGANIZATION_ID
, PR.ORG_ID
, PR.SPONSOR_ID
, PR.ORIGINAL_SPONSOR_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
, HR_ALL_ORGANIZATION_UNITS HR2
, HR_ALL_ORGANIZATION_UNITS HR3
, HZ_PARTIES P1
, HZ_CUST_ACCOUNTS C1
, HZ_PARTIES P2
, HZ_CUST_ACCOUNTS C2
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
AND HR2.ORGANIZATION_ID = PR.LEAD_ORGANIZATION_ID
AND HR3.ORGANIZATION_ID = PR.SUBMITTING_ORGANIZATION_ID
AND C1.PARTY_ID = P1.PARTY_ID
AND C1.CUST_ACCOUNT_ID = PR.SPONSOR_ID
AND C1.PARTY_ID = P1.PARTY_ID(+)
AND C1.CUST_ACCOUNT_ID(+) = PR.ORIGINAL_SPONSOR_ID WITH READ ONLY