VIEW: APPS.OKL_LA_FEE_LINES_UV

Source

View Text - Preformatted

SELECT TO_CHAR(CLEB_FEE.ID) CLEB_FEE_ID, TO_CHAR(CLEB_FEE.DNZ_CHR_ID) DNZ_CHR_ID, TO_CHAR(CLEB_FEE.ORIG_SYSTEM_ID1) ORIG_SYSTEM_ID1, KLE_FEE.FEE_TYPE FEE_TYPE, LKP_FEE_TYPE.MEANING FEE_TYPE_NAME, TO_CHAR(CIM_FEE.ID) CIM_FEE_ID, STYT.NAME CIM_FEE_STY_NAME, TO_CHAR(CIM_FEE.OBJECT1_ID1) CIM_FEE_OBJECT1_ID1, TO_CHAR(CIM_FEE.OBJECT1_ID2) CIM_FEE_OBJECT1_ID2, CIM_FEE.JTOT_OBJECT1_CODE CIM_FEE_OBJECT1_CODE, TO_CHAR(CPLB_FEE.ID) CPLB_FEE_ID, decode( cplb_fee.rle_code,'INVESTOR', parb.name,pov.vendor_name) CPLB_FEE_VENDOR_NAME, TO_CHAR(CPLB_FEE.OBJECT1_ID1) CPLB_FEE_OBJECT1_ID1, TO_CHAR(CPLB_FEE.OBJECT1_ID2) CPLB_FEE_OBJECT1_ID2, CPLB_FEE.JTOT_OBJECT1_CODE CPLB_FEE_OBJECT1_CODE, CPLB_FEE.RLE_CODE CPLB_FEE_RLE_CODE, CLEB_FEE.START_DATE START_DATE, CLEB_FEE.END_DATE END_DATE, KLE_FEE.AMOUNT AMOUNT, KLE_FEE.INITIAL_DIRECT_COST INITIAL_DIRECT_COST, TO_CHAR(NULL) ROLLOVER_TERM_QUOTE_NUMBER, TO_CHAR(NULL) ROLLOVER_CONTRACT_NUMBER, TO_CHAR(KLE_FEE.QTE_ID) QTE_ID, KLE_FEE.FUNDING_DATE FUNDING_DATE, KLE_FEE.FEE_PURPOSE_CODE FEE_PURPOSE_CODE, TO_CHAR(NULL) SALES_TAX_FEE_YN, KLE_FEE.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, KLE_FEE.ATTRIBUTE1 ATTRIBUTE1, KLE_FEE.ATTRIBUTE2 ATTRIBUTE2, KLE_FEE.ATTRIBUTE3 ATTRIBUTE3, KLE_FEE.ATTRIBUTE4 ATTRIBUTE4, KLE_FEE.ATTRIBUTE5 ATTRIBUTE5, KLE_FEE.ATTRIBUTE6 ATTRIBUTE6, KLE_FEE.ATTRIBUTE7 ATTRIBUTE7, KLE_FEE.ATTRIBUTE8 ATTRIBUTE8, KLE_FEE.ATTRIBUTE9 ATTRIBUTE9, KLE_FEE.ATTRIBUTE10 ATTRIBUTE10, KLE_FEE.ATTRIBUTE11 ATTRIBUTE11, KLE_FEE.ATTRIBUTE12 ATTRIBUTE12, KLE_FEE.ATTRIBUTE13 ATTRIBUTE13, KLE_FEE.ATTRIBUTE14 ATTRIBUTE14, KLE_FEE.ATTRIBUTE15 ATTRIBUTE15, TO_CHAR(RGP_LAFEXP.ID) RGP_LAFEXP_ID, TO_CHAR(RUL_LAFREQ.ID) RUL_LAFREQ_ID, TO_CHAR(RUL_LAFREQ.OBJECT1_ID1) RUL_LAFREQ_OBJECT1_ID1, TO_CHAR(RUL_LAFREQ.OBJECT1_ID2) RUL_LAFREQ_OBJECT1_ID2, RUL_LAFREQ.JTOT_OBJECT1_CODE RUL_LAFREQ_OBJECT1_CODE, TUOM.NAME FREQUENCY_NAME, TO_CHAR(RUL_LAFEXP.ID) RUL_LAFEXP_ID, RUL_LAFEXP.RULE_INFORMATION1 RULE_INFORMATION1, RUL_LAFEXP.RULE_INFORMATION2 RULE_INFORMATION2, KLE_FEE.ORIGINATION_INCOME FROM OKX_PARTIES_V PARB,OKC_K_LINES_B CLEB_FEE,OKL_K_LINES KLE_FEE,OKC_K_ITEMS CIM_FEE,OKL_STRM_TYPE_TL STYT,OKC_K_PARTY_ROLES_B CPLB_FEE,PO_VENDORS POV,FND_LOOKUPS LKP_FEE_TYPE,OKC_RULE_GROUPS_B RGP_LAFEXP,OKC_RULES_B RUL_LAFREQ,OKC_RULES_B RUL_LAFEXP,OKL_TIME_UNITS_V TUOM WHERE CLEB_FEE.ID = KLE_FEE.ID AND CIM_FEE.CLE_ID = CLEB_FEE.ID AND CIM_FEE.DNZ_CHR_ID = CLEB_FEE.DNZ_CHR_ID AND CIM_FEE.JTOT_OBJECT1_CODE = 'OKL_STRMTYP' AND STYT.ID = CIM_FEE.OBJECT1_ID1 AND STYT.LANGUAGE = USERENV('LANG') AND CPLB_FEE.CLE_ID (+) = CLEB_FEE.ID AND CPLB_FEE.DNZ_CHR_ID (+) = CLEB_FEE.DNZ_CHR_ID AND nvl(cplb_fee.rle_code,'INVESTOR' ) in ('OKL_VENDOR','INVESTOR') AND POV.VENDOR_ID (+) = CPLB_FEE.OBJECT1_ID1 AND PARB.id1 (+) = CPLB_FEE.OBJECT1_ID1 AND PARB.id2 (+) = CPLB_FEE.OBJECT1_ID2 AND LKP_FEE_TYPE.LOOKUP_CODE = KLE_FEE.FEE_TYPE AND LKP_FEE_TYPE.LOOKUP_TYPE = 'OKL_FEE_TYPES' AND RGP_LAFEXP.DNZ_CHR_ID (+) = CLEB_FEE.DNZ_CHR_ID AND RGP_LAFEXP.CLE_ID (+) = CLEB_FEE.ID AND RGP_LAFEXP.RGD_CODE (+) = 'LAFEXP' AND RUL_LAFREQ.RGP_ID (+) = RGP_LAFEXP.ID AND RUL_LAFREQ.RULE_INFORMATION_CATEGORY (+) = 'LAFREQ' AND RUL_LAFEXP.RGP_ID (+) = RGP_LAFEXP.ID AND RUL_LAFEXP.RULE_INFORMATION_CATEGORY (+) = 'LAFEXP' AND TUOM.ID1 (+) = RUL_LAFREQ.OBJECT1_ID1

View Text - HTML Formatted

SELECT TO_CHAR(CLEB_FEE.ID) CLEB_FEE_ID
, TO_CHAR(CLEB_FEE.DNZ_CHR_ID) DNZ_CHR_ID
, TO_CHAR(CLEB_FEE.ORIG_SYSTEM_ID1) ORIG_SYSTEM_ID1
, KLE_FEE.FEE_TYPE FEE_TYPE
, LKP_FEE_TYPE.MEANING FEE_TYPE_NAME
, TO_CHAR(CIM_FEE.ID) CIM_FEE_ID
, STYT.NAME CIM_FEE_STY_NAME
, TO_CHAR(CIM_FEE.OBJECT1_ID1) CIM_FEE_OBJECT1_ID1
, TO_CHAR(CIM_FEE.OBJECT1_ID2) CIM_FEE_OBJECT1_ID2
, CIM_FEE.JTOT_OBJECT1_CODE CIM_FEE_OBJECT1_CODE
, TO_CHAR(CPLB_FEE.ID) CPLB_FEE_ID
, DECODE( CPLB_FEE.RLE_CODE
, 'INVESTOR'
, PARB.NAME
, POV.VENDOR_NAME) CPLB_FEE_VENDOR_NAME
, TO_CHAR(CPLB_FEE.OBJECT1_ID1) CPLB_FEE_OBJECT1_ID1
, TO_CHAR(CPLB_FEE.OBJECT1_ID2) CPLB_FEE_OBJECT1_ID2
, CPLB_FEE.JTOT_OBJECT1_CODE CPLB_FEE_OBJECT1_CODE
, CPLB_FEE.RLE_CODE CPLB_FEE_RLE_CODE
, CLEB_FEE.START_DATE START_DATE
, CLEB_FEE.END_DATE END_DATE
, KLE_FEE.AMOUNT AMOUNT
, KLE_FEE.INITIAL_DIRECT_COST INITIAL_DIRECT_COST
, TO_CHAR(NULL) ROLLOVER_TERM_QUOTE_NUMBER
, TO_CHAR(NULL) ROLLOVER_CONTRACT_NUMBER
, TO_CHAR(KLE_FEE.QTE_ID) QTE_ID
, KLE_FEE.FUNDING_DATE FUNDING_DATE
, KLE_FEE.FEE_PURPOSE_CODE FEE_PURPOSE_CODE
, TO_CHAR(NULL) SALES_TAX_FEE_YN
, KLE_FEE.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, KLE_FEE.ATTRIBUTE1 ATTRIBUTE1
, KLE_FEE.ATTRIBUTE2 ATTRIBUTE2
, KLE_FEE.ATTRIBUTE3 ATTRIBUTE3
, KLE_FEE.ATTRIBUTE4 ATTRIBUTE4
, KLE_FEE.ATTRIBUTE5 ATTRIBUTE5
, KLE_FEE.ATTRIBUTE6 ATTRIBUTE6
, KLE_FEE.ATTRIBUTE7 ATTRIBUTE7
, KLE_FEE.ATTRIBUTE8 ATTRIBUTE8
, KLE_FEE.ATTRIBUTE9 ATTRIBUTE9
, KLE_FEE.ATTRIBUTE10 ATTRIBUTE10
, KLE_FEE.ATTRIBUTE11 ATTRIBUTE11
, KLE_FEE.ATTRIBUTE12 ATTRIBUTE12
, KLE_FEE.ATTRIBUTE13 ATTRIBUTE13
, KLE_FEE.ATTRIBUTE14 ATTRIBUTE14
, KLE_FEE.ATTRIBUTE15 ATTRIBUTE15
, TO_CHAR(RGP_LAFEXP.ID) RGP_LAFEXP_ID
, TO_CHAR(RUL_LAFREQ.ID) RUL_LAFREQ_ID
, TO_CHAR(RUL_LAFREQ.OBJECT1_ID1) RUL_LAFREQ_OBJECT1_ID1
, TO_CHAR(RUL_LAFREQ.OBJECT1_ID2) RUL_LAFREQ_OBJECT1_ID2
, RUL_LAFREQ.JTOT_OBJECT1_CODE RUL_LAFREQ_OBJECT1_CODE
, TUOM.NAME FREQUENCY_NAME
, TO_CHAR(RUL_LAFEXP.ID) RUL_LAFEXP_ID
, RUL_LAFEXP.RULE_INFORMATION1 RULE_INFORMATION1
, RUL_LAFEXP.RULE_INFORMATION2 RULE_INFORMATION2
, KLE_FEE.ORIGINATION_INCOME
FROM OKX_PARTIES_V PARB
, OKC_K_LINES_B CLEB_FEE
, OKL_K_LINES KLE_FEE
, OKC_K_ITEMS CIM_FEE
, OKL_STRM_TYPE_TL STYT
, OKC_K_PARTY_ROLES_B CPLB_FEE
, PO_VENDORS POV
, FND_LOOKUPS LKP_FEE_TYPE
, OKC_RULE_GROUPS_B RGP_LAFEXP
, OKC_RULES_B RUL_LAFREQ
, OKC_RULES_B RUL_LAFEXP
, OKL_TIME_UNITS_V TUOM
WHERE CLEB_FEE.ID = KLE_FEE.ID
AND CIM_FEE.CLE_ID = CLEB_FEE.ID
AND CIM_FEE.DNZ_CHR_ID = CLEB_FEE.DNZ_CHR_ID
AND CIM_FEE.JTOT_OBJECT1_CODE = 'OKL_STRMTYP'
AND STYT.ID = CIM_FEE.OBJECT1_ID1
AND STYT.LANGUAGE = USERENV('LANG')
AND CPLB_FEE.CLE_ID (+) = CLEB_FEE.ID
AND CPLB_FEE.DNZ_CHR_ID (+) = CLEB_FEE.DNZ_CHR_ID
AND NVL(CPLB_FEE.RLE_CODE
, 'INVESTOR' ) IN ('OKL_VENDOR'
, 'INVESTOR')
AND POV.VENDOR_ID (+) = CPLB_FEE.OBJECT1_ID1
AND PARB.ID1 (+) = CPLB_FEE.OBJECT1_ID1
AND PARB.ID2 (+) = CPLB_FEE.OBJECT1_ID2
AND LKP_FEE_TYPE.LOOKUP_CODE = KLE_FEE.FEE_TYPE
AND LKP_FEE_TYPE.LOOKUP_TYPE = 'OKL_FEE_TYPES'
AND RGP_LAFEXP.DNZ_CHR_ID (+) = CLEB_FEE.DNZ_CHR_ID
AND RGP_LAFEXP.CLE_ID (+) = CLEB_FEE.ID
AND RGP_LAFEXP.RGD_CODE (+) = 'LAFEXP'
AND RUL_LAFREQ.RGP_ID (+) = RGP_LAFEXP.ID
AND RUL_LAFREQ.RULE_INFORMATION_CATEGORY (+) = 'LAFREQ'
AND RUL_LAFEXP.RGP_ID (+) = RGP_LAFEXP.ID
AND RUL_LAFEXP.RULE_INFORMATION_CATEGORY (+) = 'LAFEXP'
AND TUOM.ID1 (+) = RUL_LAFREQ.OBJECT1_ID1