View: OKL_LA_INSTALL_SITE_UV

Product:	OKL - Lease and Finance Management
Description:	User interface view for party install_at site list of value page
Implementation/DBA Data:	APPS.OKL_LA_INSTALL_SITE_UV

View Text

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

Columns