View: IGW_PRPO_PERF_SITES_V

Product:	IGW - Grants Proposal
Description:	View displays performing sites where the proposal activity is conducted
Implementation/DBA Data:	APPS.IGW_PRPO_PERF_SITES_V

View Text

SELECT PRFM.PROPOSAL_ID
, PRFM.PERFORMING_ORGANIZATION_ID
, PRFM.PARTY_ID
, HRORG.NAME PERFORMING_ORGANIZATION_NAME
, HRLOC.ADDRESS_LINE_1
, HRLOC.ADDRESS_LINE_2
, HRLOC.ADDRESS_LINE_3
, HRLOC.TOWN_OR_CITY
, HRLOC.REGION_1
, HRLOC.REGION_2
, HRLOC.POSTAL_CODE
, HRLOC.COUNTRY
, ORGDT.DUNS_NUMBER
, ORGDT.DUNS4_NUMBER
, ORGDT.DODAAC_NUMBER
, ORGDT.CAGE_NUMBER
FROM IGW_PROP_LOCATIONS PRFM
, IGW_ORG_DETAILS ORGDT
, HR_ORGANIZATION_UNITS HRORG
, HR_LOCATIONS HRLOC
WHERE HRORG.ORGANIZATION_ID = PRFM.PERFORMING_ORGANIZATION_ID
AND HRORG.LOCATION_ID = HRLOC.LOCATION_ID(+)
AND PRFM.PERFORMING_ORGANIZATION_ID = ORGDT.ORGANIZATION_ID(+) UNION SELECT PRFM.PROPOSAL_ID
, PRFM.PERFORMING_ORGANIZATION_ID
, PRFM.PARTY_ID
, HP.PARTY_NAME PERFORMING_ORGANIZATION_NAME
, HP.ADDRESS1 ADDRESS_LINE_1
, HP.ADDRESS2 ADDRESS_LINE_2
, HP.ADDRESS3 ADDRESS_LINE_3
, HP.CITY TOWN_OR_CITY
, HP.COUNTY REGION_1
, HP.STATE REGION_2
, HP.POSTAL_CODE
, HP.COUNTRY
, TO_CHAR(HP.DUNS_NUMBER) DUNS_NUMBER
, NULL DUNS4_NUMBER
, NULL DODAAC_NUMBER
, NULL CAGE_NUMBER
FROM IGW_PROP_LOCATIONS PRFM
, HZ_PARTIES HP
WHERE PRFM.PARTY_ID = HP.PARTY_ID
AND PRFM.PERFORMING_ORGANIZATION_ID IS NULL

Columns