VIEW: APPS.CS_BILL_TO_SHIP_TO_ADDR_V

Source

View Text - Preformatted

SELECT DISTINCT(substr(l.ADDRESS1, 1, 50) || ',' || substr(l.ADDRESS2, 1, 50) || ',' || substr(l.ADDRESS3, 1, 50) || ',' || substr(l.ADDRESS4, 1, 50) || ',' || substr(l.COUNTY, 1, 20) || ',' || substr(l.city, 1, 20) || ',' || substr(l.POSTAL_CODE, 1, 20) || ',' || substr(l.PROVINCE, 1, 30) || ',' || substr(l.STATE, 1, 20) || ',' || substr(l.COUNTRY, 1, 30) || ',' || s.party_site_number) Address, l.location_id location_id, s.party_site_id party_site_id, u.site_use_type site_use_type, s.party_id party_id FROM hz_locations l, hz_party_sites s, hz_parties p, hz_party_site_uses u WHERE l.location_id = s.location_id AND s.party_site_id = u.party_site_id AND s.status = 'A' AND NVL(u.status, 'A')= 'A' AND s.party_id = p.party_id AND trunc(SYSDATE) BETWEEN trunc(nvl(u.begin_date, SYSDATE)) AND trunc(nvl(u.end_date, SYSDATE))

View Text - HTML Formatted

SELECT DISTINCT(SUBSTR(L.ADDRESS1
, 1
, 50) || '
, ' || SUBSTR(L.ADDRESS2
, 1
, 50) || '
, ' || SUBSTR(L.ADDRESS3
, 1
, 50) || '
, ' || SUBSTR(L.ADDRESS4
, 1
, 50) || '
, ' || SUBSTR(L.COUNTY
, 1
, 20) || '
, ' || SUBSTR(L.CITY
, 1
, 20) || '
, ' || SUBSTR(L.POSTAL_CODE
, 1
, 20) || '
, ' || SUBSTR(L.PROVINCE
, 1
, 30) || '
, ' || SUBSTR(L.STATE
, 1
, 20) || '
, ' || SUBSTR(L.COUNTRY
, 1
, 30) || '
, ' || S.PARTY_SITE_NUMBER) ADDRESS
, L.LOCATION_ID LOCATION_ID
, S.PARTY_SITE_ID PARTY_SITE_ID
, U.SITE_USE_TYPE SITE_USE_TYPE
, S.PARTY_ID PARTY_ID
FROM HZ_LOCATIONS L
, HZ_PARTY_SITES S
, HZ_PARTIES P
, HZ_PARTY_SITE_USES U
WHERE L.LOCATION_ID = S.LOCATION_ID
AND S.PARTY_SITE_ID = U.PARTY_SITE_ID
AND S.STATUS = 'A'
AND NVL(U.STATUS
, 'A')= 'A'
AND S.PARTY_ID = P.PARTY_ID
AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(U.BEGIN_DATE
, SYSDATE))
AND TRUNC(NVL(U.END_DATE
, SYSDATE))