View: OKL_SEC_HEADERS_UV

Product:	OKL - Leasing and Finance Management
Description:	User Interface view for securitizaton headers
Implementation/DBA Data:	APPS.OKL_SEC_HEADERS_UV

View Text

SELECT CHRB.ID ID
, CHRB.CONTRACT_NUMBER CONTRACT_NUMBER
, CHRT.SHORT_DESCRIPTION SHORT_DESCRIPTION
, CHRB.START_DATE START_DATE
, CHRB.END_DATE END_DATE
, CHRB.AUTHORING_ORG_ID AUTHORING_ORG_ID
, CHRB.INV_ORGANIZATION_ID INV_ORG_ID
, CHRB.STS_CODE STS_CODE
, STSB.STE_CODE STE_CODE
, STSL.MEANING STS_MEANING
, CURR.CURRENCY_CODE CURRENCY_CODE
, CURR.NAME CURRENCY
, KLPB.ID PDT_ID
, KLPB.NAME PRODUCT_NAME
, KLPB.DESCRIPTION PRODUCT_DESCRIPTION
, POLB.POOL_NUMBER POOL_NUMBER
, POLB.ID POOL_ID
, POLB.TOTAL_PRINCIPAL_AMOUNT TOTAL_PRINCIPAL_AMOUNT
, POLB.TOTAL_RECEIVABLE_AMOUNT TOTAL_RECEIVABLE_AMOUNT
, POLB.LEGAL_ENTITY_ID LEGAL_ENTITY_ID
FROM OKC_K_HEADERS_B CHRB
, OKC_STATUSES_B STSB
, OKC_STATUSES_TL STSL
, OKC_K_HEADERS_TL CHRT
, OKL_K_HEADERS KHRB
, OKL_PRODUCTS KLPB
, OKL_POOLS_ALL POLB
, FND_CURRENCIES_VL CURR
WHERE CHRT.ID = CHRB.ID
AND STSL.LANGUAGE = USERENV('LANG')
AND CHRT.LANGUAGE = USERENV('LANG')
AND STSL.CODE = CHRB.STS_CODE
AND STSB.CODE = STSL.CODE
AND KHRB.ID = CHRB.ID
AND KLPB.ID = KHRB.PDT_ID
AND CHRB.CURRENCY_CODE = CURR.CURRENCY_CODE
AND CHRB.SCS_CODE = 'INVESTOR'
AND CHRB.ID = POLB.KHR_ID

Columns