VIEW: APPS.OKL_K_HDR_CRDTLN_UV

Source

View Text - Preformatted

SELECT chr.id id, chr.contract_number contract_number, chrt.short_description short_description, chrt.description description, chr.scs_code scs_code, chr.currency_code currency_code, chr.sts_code sts_code, chr.template_yn template_yn, chr.buy_or_sell buy_or_sell, chr.start_date start_date, chr.end_date end_date, khr.revolving_credit_yn revolving_credit_yn, rle.object1_id1 cust_object1_id1, rle.object1_id2 cust_object1_id2, rle.jtot_object1_code cust_jtot_object1_code , hz_p.party_name cust_name, hz_CA.ACCOUNT_NUMBER cust_acc_number FROM OKC_K_HEADERS_B CHR,OKC_K_HEADERS_TL CHRT,OKL_K_HEADERS KHR,OKC_K_PARTY_ROLES_B RLE,HZ_PARTIES HZ_P,HZ_CUST_ACCOUNTS HZ_CA WHERE chr.id = khr.id and CHR.ID = CHRT.ID and CHRT.LANGUAGE = USERENV('LANG') and chr.id = rle.dnz_chr_id and chr.id = rle.chr_id and rle.rle_code = 'LESSEE' and chr.scs_code = 'CREDITLINE_CONTRACT' and chr.sts_code = 'ACTIVE' and chr.template_yn = 'N' and chr.buy_or_sell = 'S' and rle.object1_id1 = hz_p.party_id and rle.object1_id2 = '#' and hz_p.PARTY_TYPE IN ( 'PERSON','ORGANIZATION') and hz_CA.PARTY_ID = hz_P.PARTY_ID and chr.cust_acct_id = hz_ca.CUST_ACCOUNT_ID

View Text - HTML Formatted

SELECT CHR.ID ID
, CHR.CONTRACT_NUMBER CONTRACT_NUMBER
, CHRT.SHORT_DESCRIPTION SHORT_DESCRIPTION
, CHRT.DESCRIPTION DESCRIPTION
, CHR.SCS_CODE SCS_CODE
, CHR.CURRENCY_CODE CURRENCY_CODE
, CHR.STS_CODE STS_CODE
, CHR.TEMPLATE_YN TEMPLATE_YN
, CHR.BUY_OR_SELL BUY_OR_SELL
, CHR.START_DATE START_DATE
, CHR.END_DATE END_DATE
, KHR.REVOLVING_CREDIT_YN REVOLVING_CREDIT_YN
, RLE.OBJECT1_ID1 CUST_OBJECT1_ID1
, RLE.OBJECT1_ID2 CUST_OBJECT1_ID2
, RLE.JTOT_OBJECT1_CODE CUST_JTOT_OBJECT1_CODE
, HZ_P.PARTY_NAME CUST_NAME
, HZ_CA.ACCOUNT_NUMBER CUST_ACC_NUMBER
FROM OKC_K_HEADERS_B CHR
, OKC_K_HEADERS_TL CHRT
, OKL_K_HEADERS KHR
, OKC_K_PARTY_ROLES_B RLE
, HZ_PARTIES HZ_P
, HZ_CUST_ACCOUNTS HZ_CA
WHERE CHR.ID = KHR.ID
AND CHR.ID = CHRT.ID
AND CHRT.LANGUAGE = USERENV('LANG')
AND CHR.ID = RLE.DNZ_CHR_ID
AND CHR.ID = RLE.CHR_ID
AND RLE.RLE_CODE = 'LESSEE'
AND CHR.SCS_CODE = 'CREDITLINE_CONTRACT'
AND CHR.STS_CODE = 'ACTIVE'
AND CHR.TEMPLATE_YN = 'N'
AND CHR.BUY_OR_SELL = 'S'
AND RLE.OBJECT1_ID1 = HZ_P.PARTY_ID
AND RLE.OBJECT1_ID2 = '#'
AND HZ_P.PARTY_TYPE IN ( 'PERSON'
, 'ORGANIZATION')
AND HZ_CA.PARTY_ID = HZ_P.PARTY_ID
AND CHR.CUST_ACCT_ID = HZ_CA.CUST_ACCOUNT_ID