VIEW: APPS.OKL_AM_PARTY_LOCATION_UV

Source

View Text - Preformatted

SELECT o.party_name party_name, u.primary_per_type primary_per_type, u.site_use_type site_use_type, s.party_id party_id, s.location_id location_id, s.party_site_id party_site_id, u.party_site_use_id party_site_use_id, s.end_date_active end_date_active, s.status status, a.address1 address1, a.address2 address2, a.address3 address3, a.city city, a.state state, a.postal_code postal_code, a.country country, Substr (arp_addr_label_pkg.format_address ( NULL, a.address1, a.address2, a.address3, a.address4, a.city, a.county, a.state, a.province, a.postal_code, NULL, a.country, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'N', 'N', 80, 1, 1), 1, 80) location_address, to_char(NULL) contact, to_number(NULL) contact_party_id FROM HZ_PARTY_SITES S,HZ_LOCATIONS A,HZ_PARTY_SITE_USES U,HZ_PARTIES O WHERE s.status = 'A' AND u.party_site_id = s.party_site_id AND NVL (s.end_date_active, SYSDATE) >= SYSDATE AND s.party_id = o.party_id AND s.location_id = a.location_id

View Text - HTML Formatted

SELECT O.PARTY_NAME PARTY_NAME
, U.PRIMARY_PER_TYPE PRIMARY_PER_TYPE
, U.SITE_USE_TYPE SITE_USE_TYPE
, S.PARTY_ID PARTY_ID
, S.LOCATION_ID LOCATION_ID
, S.PARTY_SITE_ID PARTY_SITE_ID
, U.PARTY_SITE_USE_ID PARTY_SITE_USE_ID
, S.END_DATE_ACTIVE END_DATE_ACTIVE
, S.STATUS STATUS
, A.ADDRESS1 ADDRESS1
, A.ADDRESS2 ADDRESS2
, A.ADDRESS3 ADDRESS3
, A.CITY CITY
, A.STATE STATE
, A.POSTAL_CODE POSTAL_CODE
, A.COUNTRY COUNTRY
, SUBSTR (ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS ( NULL
, A.ADDRESS1
, A.ADDRESS2
, A.ADDRESS3
, A.ADDRESS4
, A.CITY
, A.COUNTY
, A.STATE
, A.PROVINCE
, A.POSTAL_CODE
, NULL
, A.COUNTRY
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 'N'
, 'N'
, 80
, 1
, 1)
, 1
, 80) LOCATION_ADDRESS
, TO_CHAR(NULL) CONTACT
, TO_NUMBER(NULL) CONTACT_PARTY_ID
FROM HZ_PARTY_SITES S
, HZ_LOCATIONS A
, HZ_PARTY_SITE_USES U
, HZ_PARTIES O
WHERE S.STATUS = 'A'
AND U.PARTY_SITE_ID = S.PARTY_SITE_ID
AND NVL (S.END_DATE_ACTIVE
, SYSDATE) >= SYSDATE
AND S.PARTY_ID = O.PARTY_ID
AND S.LOCATION_ID = A.LOCATION_ID