eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: APPS.IGW_PRPO_PERF_SITES_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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