View: OKL_SEC_AGREEMENTS_UV

Product:	OKL - Lease and Finance Management
Description:	User Interface view for securitization agreements
Implementation/DBA Data:	APPS.OKL_SEC_AGREEMENTS_UV

View Text

SELECT CHRB.ID ID
, CHRB.CONTRACT_NUMBER AGREEMENT_NUMBER
, CHRT.SHORT_DESCRIPTION NOTE
, CHRB.START_DATE START_DATE
, CHRB.END_DATE END_DATE
, CHRB.DATE_APPROVED DATE_APPROVED
, STSB.STE_CODE STE_CODE
, CHRB.STS_CODE STS_CODE
, STST.MEANING STATUS
, CURR.CURRENCY_CODE CURRENCY_CODE
, CURR.NAME CURRENCY
, PDTB.ID PDT_ID
, PDTB.NAME PRODUCT_NAME
, POLB.ID POL_ID
, POLB.POOL_NUMBER POOL_NUMBER
, KHRB.SECURITIZATION_TYPE SEC_TYPE_CODE
, SECL.MEANING SEC_TYPE
, KHRB.LESSOR_SERV_ORG_CODE LESSOR_SERV_ORG_CODE
, SERL.MEANING LESSOR_SERV_ORG
, KHRB.RECOURSE_CODE RECOURSE_CODE
, RECL.MEANING RECOURSE
, CHRB.AUTHORING_ORG_ID AUTHORING_ORG_ID
, KHRB.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, KHRB.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, KHRB.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, CPLB.ID CPL_TRUSTEE_ID
, CPLB.OBJECT1_ID1 TRUSTEE_ID1
, CPLB.OBJECT1_ID2 TRUSTEE_ID2
, VEND.NAME TRUSTEE_NAME
, KHRB.AFTER_TAX_YIELD AFTER_TAX_YIELD
, KHRB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, KHRB.ATTRIBUTE1 ATTRIBUTE1
, KHRB.ATTRIBUTE2 ATTRIBUTE2
, KHRB.ATTRIBUTE3 ATTRIBUTE3
, KHRB.ATTRIBUTE4 ATTRIBUTE4
, KHRB.ATTRIBUTE5 ATTRIBUTE5
, KHRB.ATTRIBUTE6 ATTRIBUTE6
, KHRB.ATTRIBUTE7 ATTRIBUTE7
, KHRB.ATTRIBUTE8 ATTRIBUTE8
, KHRB.ATTRIBUTE9 ATTRIBUTE9
, KHRB.ATTRIBUTE10 ATTRIBUTE10
, KHRB.ATTRIBUTE11 ATTRIBUTE11
, KHRB.ATTRIBUTE12 ATTRIBUTE12
, KHRB.ATTRIBUTE13 ATTRIBUTE13
, KHRB.ATTRIBUTE14 ATTRIBUTE14
, KHRB.ATTRIBUTE15 ATTRIBUTE15
, POLB.LEGAL_ENTITY_ID LEGAL_ENTITY_ID
FROM OKC_K_HEADERS_B CHRB
, OKC_STATUSES_B STSB
, OKC_STATUSES_TL STST
, OKC_K_HEADERS_TL CHRT
, OKL_K_HEADERS KHRB
, OKL_PRODUCTS PDTB
, OKL_POOLS_ALL POLB
, FND_CURRENCIES_VL CURR
, FND_LOOKUPS SECL
, FND_LOOKUPS SERL
, FND_LOOKUPS RECL
, OKX_VENDORS_V VEND
, OKC_K_PARTY_ROLES_B CPLB
WHERE CHRT.ID = CHRB.ID
AND STST.CODE = CHRB.STS_CODE
AND STST.CODE = STSB.CODE
AND STST.LANGUAGE = USERENV('LANG')
AND CHRT.LANGUAGE = USERENV('LANG')
AND KHRB.ID = CHRB.ID
AND PDTB.ID = KHRB.PDT_ID
AND CHRB.CURRENCY_CODE = CURR.CURRENCY_CODE
AND CHRB.SCS_CODE = 'INVESTOR'
AND CHRB.ID = POLB.KHR_ID
AND SECL.LOOKUP_TYPE = 'OKL_SECURITIZATION_TYPE'
AND DECODE(KHRB.SECURITIZATION_TYPE
, 'SALE'
, 'SECURITIZATION'
, 'LOAN'
, 'SYNDICATION'
, 'SECURITIZATION'
, 'SECURITIZATION'
, 'SYNDICATION'
, 'SYNDICATION') = SECL.LOOKUP_CODE
AND SERL.LOOKUP_TYPE = 'OKL_SEC_SERVICE_ORG'
AND KHRB.LESSOR_SERV_ORG_CODE = SERL.LOOKUP_CODE
AND RECL.LOOKUP_TYPE = 'OKL_SEC_RECOURSE'
AND KHRB.RECOURSE_CODE = RECL.LOOKUP_CODE
AND CHRB.ID = CPLB.CHR_ID
AND CPLB.RLE_CODE = 'TRUSTEE'
AND CPLB.JTOT_OBJECT1_CODE = 'OKX_VENDOR'
AND VEND.ID1 = CPLB.OBJECT1_ID1
AND VEND.ID2 = CPLB.OBJECT1_ID2

Columns