View: IGW_APPLICANT_ORG_V

Product:	IGW - Grants Proposal
Description:	View displays details of the organization submitting the proposal
Implementation/DBA Data:	APPS.IGW_APPLICANT_ORG_V

View Text

SELECT PA.PROPOSAL_ID
, PA.PROPOSAL_NUMBER
, PD.ORGANIZATION_ID
, IGW_EXTENSION_PKG.PERSON_GOVT_ID(PD2.ADMIN_OFFICIAL_ID)
, IGW_EXTENSION_PKG.PERSON_GOVT_ID(PD.SIGNING_OFFICIAL_ID)
, PD.AGREEMENT_DATE
, PD.NEGOTIATING_AGREEMENT_WITH
, PD.RATE_ESTABLISHED_WITH
, PD.RATE_ESTABLISHED_DATE
, PD.ORG_IPF_CODE
, PD.CONGRESS_DISTRICT
, PD.EIN
, PD.TIN
, PD.DUNS_NUMBER
, PD.DUNS4_NUMBER
, PD.DODAAC_NUMBER
, PD.CAGE_NUMBER
, PD.HUMAN_EXEMPTION_NUMBER
, PD.HUMAN_ASSURANCE_NUMBER
, PD.ANIMAL_ASSURANCE_NUMBER
, PD.NSF_INSTITUTIONAL_CODE
, OU.NAME
, LO.ADDRESS_LINE_1
, LO.ADDRESS_LINE_2
, LO.ADDRESS_LINE_3
, LO.POSTAL_CODE
, LO.REGION_1
, LO.REGION_2
, LO.REGION_3
, LO.TELEPHONE_NUMBER_1 PHONE_NUMBER
, LO.TELEPHONE_NUMBER_2 FAX_NUMBER
, LO.TOWN_OR_CITY
, LO.COUNTRY
FROM HR_ALL_ORGANIZATION_UNITS OU
, HR_LOCATIONS LO
, IGW_ORG_DETAILS PD
, IGW_ORG_DETAILS PD2
, IGW_PROPOSALS_ALL PA
WHERE PA.SUBMITTING_ORGANIZATION_ID = PD.ORGANIZATION_ID(+)
AND PA.LEAD_ORGANIZATION_ID = PD2.ORGANIZATION_ID(+)
AND PA.SUBMITTING_ORGANIZATION_ID = OU.ORGANIZATION_ID(+)
AND OU.LOCATION_ID = LO.LOCATION_ID(+)

Columns