VIEW: APPS.OKL_BPD_CONTRACT_CUSTOMER_UV

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')