VIEW: APPS.OKL_LA_INSTALL_SITE_UV

Source

View Text - Preformatted

SELECT hpsu.party_site_use_id party_site_id, cplb.dnz_chr_id chr_id, hps.party_site_name name, substr(arp_addr_label_pkg.format_address(null,l.address1,l.address2,l.address3,l.address4,l.city,l.county,l.state,l.province,l.postal_code,null,l.country,null,null,null,null,null,null,null,'n','n',80,1,1),1,80) description FROM HZ_PARTY_SITE_USES HPSU,HZ_LOCATIONS L,HZ_PARTY_SITES HPS,OKC_K_PARTY_ROLES_B CPLB,OKC_K_HEADERS_B CHRB,HZ_CUST_ACCT_SITES CAS WHERE cplb.rle_code = 'LESSEE' and cplb.jtot_object1_code = 'OKX_PARTY' and cplb.object1_id2 = '#' and cplb.object1_id1 = hps.party_id and hps.location_id = l.location_id and hps.party_site_id = hpsu.party_site_id and hpsu.site_use_type = 'INSTALL_AT' and CPLB.DNZ_CHR_ID = CHRB.ID and hps.party_site_id = CAS.PARTY_SITE_ID and CAS.cust_Account_id = chrb.cust_acct_id

View Text - HTML Formatted

SELECT HPSU.PARTY_SITE_USE_ID PARTY_SITE_ID
, CPLB.DNZ_CHR_ID CHR_ID
, HPS.PARTY_SITE_NAME NAME
, SUBSTR(ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS(NULL
, L.ADDRESS1
, L.ADDRESS2
, L.ADDRESS3
, L.ADDRESS4
, L.CITY
, L.COUNTY
, L.STATE
, L.PROVINCE
, L.POSTAL_CODE
, NULL
, L.COUNTRY
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 'N'
, 'N'
, 80
, 1
, 1)
, 1
, 80) DESCRIPTION
FROM HZ_PARTY_SITE_USES HPSU
, HZ_LOCATIONS L
, HZ_PARTY_SITES HPS
, OKC_K_PARTY_ROLES_B CPLB
, OKC_K_HEADERS_B CHRB
, HZ_CUST_ACCT_SITES CAS
WHERE CPLB.RLE_CODE = 'LESSEE'
AND CPLB.JTOT_OBJECT1_CODE = 'OKX_PARTY'
AND CPLB.OBJECT1_ID2 = '#'
AND CPLB.OBJECT1_ID1 = HPS.PARTY_ID
AND HPS.LOCATION_ID = L.LOCATION_ID
AND HPS.PARTY_SITE_ID = HPSU.PARTY_SITE_ID
AND HPSU.SITE_USE_TYPE = 'INSTALL_AT'
AND CPLB.DNZ_CHR_ID = CHRB.ID
AND HPS.PARTY_SITE_ID = CAS.PARTY_SITE_ID
AND CAS.CUST_ACCOUNT_ID = CHRB.CUST_ACCT_ID