View: IGW_PROP_LOCATIONS_V

Product:	IGW - Grants Proposal
Description:	10SC Only
Implementation/DBA Data:	APPS.IGW_PROP_LOCATIONS_V

View Text

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

Columns