VIEW: APPS.WSH_LOCATIONS_REGIONS_V

Source

View Text - Preformatted

SELECT wrl.region_id, wrl.location_id, hl.address1||','||hl.address2||','||hl.address3||','||hl.address4||','||hl.city||','||hl.state||','||hl.postal_code|| ','||hl.country , wlo.owner_type, wrl.EXCEPTION_TYPE, hp.party_name, hp.party_number, wrl.CREATED_BY, wrl.CREATION_DATE, wrl.LAST_UPDATED_BY, wrl.LAST_UPDATE_DATE, wrl.LAST_UPDATE_LOGIN FROM wsh_locations hl, hz_parties hp, wsh_location_owners wlo, wsh_region_locations wrl WHERE wrl.location_id = hl.source_location_id and wlo.wsh_location_id = hl.source_location_id and hp.party_id = wlo.owner_party_id and wlo.owner_type <> 1 UNION SELECT distinct wrl.region_id, wrl.location_id, hl.address1||','||hl.address2||','||hl.address3||','||hl.address4||','||hl.city||','||hl.state||','||hl.postal_code|| ','||hl.country, wlo.owner_type, wrl.exception_type, hl.location_code, NULL, wrl.created_by, wrl.creation_date, wrl.last_updated_by, wrl.last_update_date, wrl.last_update_login FROM wsh_locations hl, wsh_location_owners wlo, wsh_region_locations wrl WHERE wrl.location_id = hl.source_location_id and wlo.wsh_location_id = hl.source_location_id and wlo.owner_party_id <> -1 and wlo.owner_type = 1 UNION SELECT wrl.region_id, wrl.location_id, hl.address1||','||hl.address2||','||hl.address3||','||hl.address4||','||hl.city||','||hl.state||','||hl.postal_code|| ','||hl.country, wlo.owner_type, wrl.exception_type, NULL, NULL, wrl.created_by, wrl.creation_date, wrl.last_updated_by, wrl.last_update_date, wrl.last_update_login FROM wsh_locations hl, wsh_location_owners wlo, wsh_region_locations wrl WHERE wrl.location_id = hl.source_location_id and wlo.wsh_location_id = hl.source_location_id and wlo.owner_party_id = -1 and wlo.owner_type = 1

View Text - HTML Formatted

SELECT WRL.REGION_ID
, WRL.LOCATION_ID
, HL.ADDRESS1||'
, '||HL.ADDRESS2||'
, '||HL.ADDRESS3||'
, '||HL.ADDRESS4||'
, '||HL.CITY||'
, '||HL.STATE||'
, '||HL.POSTAL_CODE|| '
, '||HL.COUNTRY
, WLO.OWNER_TYPE
, WRL.EXCEPTION_TYPE
, HP.PARTY_NAME
, HP.PARTY_NUMBER
, WRL.CREATED_BY
, WRL.CREATION_DATE
, WRL.LAST_UPDATED_BY
, WRL.LAST_UPDATE_DATE
, WRL.LAST_UPDATE_LOGIN
FROM WSH_LOCATIONS HL
, HZ_PARTIES HP
, WSH_LOCATION_OWNERS WLO
, WSH_REGION_LOCATIONS WRL
WHERE WRL.LOCATION_ID = HL.SOURCE_LOCATION_ID
AND WLO.WSH_LOCATION_ID = HL.SOURCE_LOCATION_ID
AND HP.PARTY_ID = WLO.OWNER_PARTY_ID
AND WLO.OWNER_TYPE <> 1 UNION SELECT DISTINCT WRL.REGION_ID
, WRL.LOCATION_ID
, HL.ADDRESS1||'
, '||HL.ADDRESS2||'
, '||HL.ADDRESS3||'
, '||HL.ADDRESS4||'
, '||HL.CITY||'
, '||HL.STATE||'
, '||HL.POSTAL_CODE|| '
, '||HL.COUNTRY
, WLO.OWNER_TYPE
, WRL.EXCEPTION_TYPE
, HL.LOCATION_CODE
, NULL
, WRL.CREATED_BY
, WRL.CREATION_DATE
, WRL.LAST_UPDATED_BY
, WRL.LAST_UPDATE_DATE
, WRL.LAST_UPDATE_LOGIN
FROM WSH_LOCATIONS HL
, WSH_LOCATION_OWNERS WLO
, WSH_REGION_LOCATIONS WRL
WHERE WRL.LOCATION_ID = HL.SOURCE_LOCATION_ID
AND WLO.WSH_LOCATION_ID = HL.SOURCE_LOCATION_ID
AND WLO.OWNER_PARTY_ID <> -1
AND WLO.OWNER_TYPE = 1 UNION SELECT WRL.REGION_ID
, WRL.LOCATION_ID
, HL.ADDRESS1||'
, '||HL.ADDRESS2||'
, '||HL.ADDRESS3||'
, '||HL.ADDRESS4||'
, '||HL.CITY||'
, '||HL.STATE||'
, '||HL.POSTAL_CODE|| '
, '||HL.COUNTRY
, WLO.OWNER_TYPE
, WRL.EXCEPTION_TYPE
, NULL
, NULL
, WRL.CREATED_BY
, WRL.CREATION_DATE
, WRL.LAST_UPDATED_BY
, WRL.LAST_UPDATE_DATE
, WRL.LAST_UPDATE_LOGIN
FROM WSH_LOCATIONS HL
, WSH_LOCATION_OWNERS WLO
, WSH_REGION_LOCATIONS WRL
WHERE WRL.LOCATION_ID = HL.SOURCE_LOCATION_ID
AND WLO.WSH_LOCATION_ID = HL.SOURCE_LOCATION_ID
AND WLO.OWNER_PARTY_ID = -1
AND WLO.OWNER_TYPE = 1