VIEW: APPS.OKL_SEC_AGREEMENTS_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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