VIEW: APPS.OKL_SEC_INVESTORS_UV

Source

View Text - Preformatted

SELECT cleb.dnz_chr_id chr_id, cleb.ID top_line_id, stsb.code sts_code, stsb.ste_code ste_code, stsl.meaning sts_meaning, cplb.ID k_role_id, parb.NAME NAME, parb.description description, parb.id1 id1, parb.id2 id2, kleb.date_pay_investor_start date_pay_investor_start, kleb.pay_investor_frequency pay_investor_frequency, freq.meaning pay_investor_frequency_meaning, kleb.pay_investor_event pay_investor_event, paye.meaning pay_investor_event_meaning, kleb.pay_investor_remittance_days pay_investor_remittance_days, kleb.amount amount, cleb.start_date start_date, khrb.currency_code currency_code, cleb.bill_to_site_use_id bill_to_site_use_id, site.NAME bill_to_site_use_name, cleb.cust_acct_id cust_acct_id, parb.NAME cust_acct_no, hzca.account_number cust_acct_name, kleb.AMOUNT_STAKE AMOUNT_STAKE FROM OKL_K_LINES KLEB,OKC_K_LINES_B CLEB,OKC_STATUSES_B STSB,OKC_STATUSES_TL STSL,OKC_LINE_STYLES_B LSEB,OKX_PARTIES_V PARB,OKC_K_PARTY_ROLES_B CPLB,OKC_K_HEADERS_B KHRB,FND_LOOKUPS PAYE,FND_LOOKUPS FREQ,HZ_CUST_ACCOUNTS HZCA,OKX_CUST_SITE_USES_V SITE WHERE cleb.ID = kleb.ID AND cleb.lse_id = lseb.ID AND lseb.lty_code = 'INVESTMENT' AND stsb.code = stsl.code AND stsl.LANGUAGE = USERENV ('LANG') AND cleb.sts_code = stsb.code AND parb.id1 = cplb.object1_id1 AND parb.id2 = cplb.object1_id2 AND cplb.jtot_object1_code = 'OKX_PARTY' AND cplb.rle_code = 'INVESTOR' AND cplb.cle_id = cleb.ID AND cplb.dnz_chr_id = cleb.dnz_chr_id AND paye.lookup_code = kleb.pay_investor_event AND paye.lookup_type = 'OKL_SEC_PAYOUT_EVENT' AND freq.lookup_code = kleb.pay_investor_frequency AND freq.lookup_type = 'OKL_FREQUENCY' AND khrb.ID = cleb.dnz_chr_id AND site.site_use_code(+) = 'BILL_TO' AND site.id1(+) = cleb.bill_to_site_use_id AND hzca.cust_account_id(+) = cleb.cust_acct_id

View Text - HTML Formatted

SELECT CLEB.DNZ_CHR_ID CHR_ID
, CLEB.ID TOP_LINE_ID
, STSB.CODE STS_CODE
, STSB.STE_CODE STE_CODE
, STSL.MEANING STS_MEANING
, CPLB.ID K_ROLE_ID
, PARB.NAME NAME
, PARB.DESCRIPTION DESCRIPTION
, PARB.ID1 ID1
, PARB.ID2 ID2
, KLEB.DATE_PAY_INVESTOR_START DATE_PAY_INVESTOR_START
, KLEB.PAY_INVESTOR_FREQUENCY PAY_INVESTOR_FREQUENCY
, FREQ.MEANING PAY_INVESTOR_FREQUENCY_MEANING
, KLEB.PAY_INVESTOR_EVENT PAY_INVESTOR_EVENT
, PAYE.MEANING PAY_INVESTOR_EVENT_MEANING
, KLEB.PAY_INVESTOR_REMITTANCE_DAYS PAY_INVESTOR_REMITTANCE_DAYS
, KLEB.AMOUNT AMOUNT
, CLEB.START_DATE START_DATE
, KHRB.CURRENCY_CODE CURRENCY_CODE
, CLEB.BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID
, SITE.NAME BILL_TO_SITE_USE_NAME
, CLEB.CUST_ACCT_ID CUST_ACCT_ID
, PARB.NAME CUST_ACCT_NO
, HZCA.ACCOUNT_NUMBER CUST_ACCT_NAME
, KLEB.AMOUNT_STAKE AMOUNT_STAKE
FROM OKL_K_LINES KLEB
, OKC_K_LINES_B CLEB
, OKC_STATUSES_B STSB
, OKC_STATUSES_TL STSL
, OKC_LINE_STYLES_B LSEB
, OKX_PARTIES_V PARB
, OKC_K_PARTY_ROLES_B CPLB
, OKC_K_HEADERS_B KHRB
, FND_LOOKUPS PAYE
, FND_LOOKUPS FREQ
, HZ_CUST_ACCOUNTS HZCA
, OKX_CUST_SITE_USES_V SITE
WHERE CLEB.ID = KLEB.ID
AND CLEB.LSE_ID = LSEB.ID
AND LSEB.LTY_CODE = 'INVESTMENT'
AND STSB.CODE = STSL.CODE
AND STSL.LANGUAGE = USERENV ('LANG')
AND CLEB.STS_CODE = STSB.CODE
AND PARB.ID1 = CPLB.OBJECT1_ID1
AND PARB.ID2 = CPLB.OBJECT1_ID2
AND CPLB.JTOT_OBJECT1_CODE = 'OKX_PARTY'
AND CPLB.RLE_CODE = 'INVESTOR'
AND CPLB.CLE_ID = CLEB.ID
AND CPLB.DNZ_CHR_ID = CLEB.DNZ_CHR_ID
AND PAYE.LOOKUP_CODE = KLEB.PAY_INVESTOR_EVENT
AND PAYE.LOOKUP_TYPE = 'OKL_SEC_PAYOUT_EVENT'
AND FREQ.LOOKUP_CODE = KLEB.PAY_INVESTOR_FREQUENCY
AND FREQ.LOOKUP_TYPE = 'OKL_FREQUENCY'
AND KHRB.ID = CLEB.DNZ_CHR_ID
AND SITE.SITE_USE_CODE(+) = 'BILL_TO'
AND SITE.ID1(+) = CLEB.BILL_TO_SITE_USE_ID
AND HZCA.CUST_ACCOUNT_ID(+) = CLEB.CUST_ACCT_ID