VIEW: APPS.IGW_PROP_LOCATIONS_V

Source

View Text - Preformatted

SELECT l.rowid, l.proposal_id, l.performing_organization_id, name performing_org_name, replace(replace(loc.address_line_1||','|| loc.address_line_2||','|| loc.address_line_3||','|| loc.town_or_city||','|| loc.region_2||','|| loc.postal_code,',,',','),',,',',') performing_org_address, l.last_update_date, l.last_updated_by, l.creation_date, l.created_by, l.last_update_login from IGW_prop_locations l, hr_organization_units h, hr_locations loc WHERE h.organization_id = l.performing_organization_id and loc.location_id(+) = h.location_id

View Text - HTML Formatted

SELECT L.ROWID
, L.PROPOSAL_ID
, L.PERFORMING_ORGANIZATION_ID
, NAME PERFORMING_ORG_NAME
, REPLACE(REPLACE(LOC.ADDRESS_LINE_1||'
, '|| LOC.ADDRESS_LINE_2||'
, '|| LOC.ADDRESS_LINE_3||'
, '|| LOC.TOWN_OR_CITY||'
, '|| LOC.REGION_2||'
, '|| LOC.POSTAL_CODE
, '
,
, '
, '
, ')
, '
,
, '
, '
, ') PERFORMING_ORG_ADDRESS
, L.LAST_UPDATE_DATE
, L.LAST_UPDATED_BY
, L.CREATION_DATE
, L.CREATED_BY
, L.LAST_UPDATE_LOGIN
FROM IGW_PROP_LOCATIONS L
, HR_ORGANIZATION_UNITS H
, HR_LOCATIONS LOC
WHERE H.ORGANIZATION_ID = L.PERFORMING_ORGANIZATION_ID
AND LOC.LOCATION_ID(+) = H.LOCATION_ID