VIEW: APPS.IGW_APPLICANT_ORG_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)