View: OKL_BPD_CONTRACT_CUSTOMER_UV

Product:	OKL - Lease and Finance Management
Description:	Contract for Customer Search
Implementation/DBA Data:	APPS.OKL_BPD_CONTRACT_CUSTOMER_UV

View Text

SELECT ACCT.ID1 CUSTOMER_ACCOUNT_ID
, PARTY.NAME CUSTOMER_NAME
, PARTY.PARTY_NUMBER CUSTOMER_NUMBER
, KHR.ID CONTRACT_ID
, KHR.CONTRACT_NUMBER CONTRACT_NUMBER
, SITE.CUST_ACCT_SITE_ID CUST_ACCT_SITE_ID
, SITE.LOCATION_ID LOCATION_ID
, RLE.OBJECT1_ID1 PARTY_ID
, SITE.NAME BILL_TO_SITE_NAME
, KHR.CURRENCY_CODE
FROM OKX_PARTIES_V PARTY
, OKX_CUST_SITE_USES_V SITE
, OKC_K_HEADERS_B KHR
, OKX_CUSTOMER_ACCOUNTS_V ACCT
, OKC_K_PARTY_ROLES_B RLE
WHERE KHR.BILL_TO_SITE_USE_ID = TO_CHAR(SITE.ID1)
AND KHR.CUST_ACCT_ID = TO_CHAR(ACCT.ID1)
AND KHR.ID = RLE.DNZ_CHR_ID
AND RLE.RLE_CODE = 'LESSEE'
AND RLE.OBJECT1_ID1 = PARTY.ID1
AND KHR.STS_CODE IN ('BOOKED'
, 'TERMINATED'
, 'EXPIRED'
, 'EVERGREEN')

Columns