eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: OKL_POOL_HEADER_UV

Product:	OKL - Lease and Finance Management
Description:	Securitization - Pool header UI view
Implementation/DBA Data:	APPS.OKL_POOL_HEADER_UV

View Text

SELECT POLB.ID ID
, POLB.POOL_NUMBER POOL_NUMBER
, POLB.CURRENCY_CODE CURRENCY_CODE
, POLB.TOTAL_PRINCIPAL_AMOUNT TOTAL_PRINCIPAL_AMOUNT
, POLB.TOTAL_RECEIVABLE_AMOUNT TOTAL_RECEIVABLE_AMOUNT
, POLB.DATE_CREATED DATE_CREATED
, POLB.DATE_LAST_UPDATED DATE_LAST_UPDATED
, POLB.DATE_LAST_RECONCILED DATE_LAST_RECONCILED
, POLB.DATE_TOTAL_PRINCIPAL_CALC DATE_TOTAL_PRINCIPAL_CALC
, POLB.KHR_ID KHR_ID
, POLB.STATUS_CODE STATUS_CODE
, PSTS.MEANING STATUS
, NULL AGREEMENT_NUMBER
, NULL AGREEMENT_STE_CODE
, NULL AGREEMENT_STS_CODE
, NULL AGREEMENT_STATUS
, POLB.DESCRIPTION
, POLB.SHORT_DESCRIPTION
, POLB.LAST_UPDATE_DATE
, POLB.ATTRIBUTE_CATEGORY
, POLB.ATTRIBUTE1
, POLB.ATTRIBUTE2
, POLB.ATTRIBUTE3
, POLB.ATTRIBUTE4
, POLB.ATTRIBUTE5
, POLB.ATTRIBUTE6
, POLB.ATTRIBUTE7
, POLB.ATTRIBUTE8
, POLB.ATTRIBUTE9
, POLB.ATTRIBUTE10
, POLB.ATTRIBUTE11
, POLB.ATTRIBUTE12
, POLB.ATTRIBUTE13
, POLB.ATTRIBUTE14
, POLB.ATTRIBUTE15
, POLB.DISPLAY_IN_LEASE_CENTER
, FL.MEANING DISP_IN_LEASE_CNTR_MEANING
, POLB.LEGAL_ENTITY_ID LEGAL_ENTITY_ID
FROM OKL_POOLS POLB
, OKC_STATUSES_TL PSTS
, FND_LOOKUPS FL
WHERE POLB.KHR_ID IS NULL
AND POLB.STATUS_CODE = PSTS.CODE
AND PSTS.LANGUAGE = USERENV('LANG')
AND NVL(POLB.DISPLAY_IN_LEASE_CENTER
, 'N') = FL.LOOKUP_CODE
AND FL.LOOKUP_TYPE = 'OKL_YES_NO' UNION SELECT POLB.ID ID
, POLB.POOL_NUMBER POOL_NUMBER
, POLB.CURRENCY_CODE CURRENCY_CODE
, POLB.TOTAL_PRINCIPAL_AMOUNT TOTAL_PRINCIPAL_AMOUNT
, POLB.TOTAL_RECEIVABLE_AMOUNT TOTAL_RECEIVABLE_AMOUNT
, POLB.DATE_CREATED DATE_CREATED
, POLB.DATE_LAST_UPDATED DATE_LAST_UPDATED
, POLB.DATE_LAST_RECONCILED DATE_LAST_RECONCILED
, POLB.DATE_TOTAL_PRINCIPAL_CALC DATE_TOTAL_PRINCIPAL_CALC
, POLB.KHR_ID KHR_ID
, POLB.STATUS_CODE STATUS_CODE
, PSTS.MEANING STATUS
, CHRB.CONTRACT_NUMBER AGREEMENT_NUMBER
, STSB.STE_CODE AGREEMENT_STE_CODE
, CHRB.STS_CODE AGREEMENT_STS_CODE
, CSTS.MEANING AGREEMENT_STATUS
, POLB.DESCRIPTION
, POLB.SHORT_DESCRIPTION
, POLB.LAST_UPDATE_DATE
, POLB.ATTRIBUTE_CATEGORY
, POLB.ATTRIBUTE1
, POLB.ATTRIBUTE2
, POLB.ATTRIBUTE3
, POLB.ATTRIBUTE4
, POLB.ATTRIBUTE5
, POLB.ATTRIBUTE6
, POLB.ATTRIBUTE7
, POLB.ATTRIBUTE8
, POLB.ATTRIBUTE9
, POLB.ATTRIBUTE10
, POLB.ATTRIBUTE11
, POLB.ATTRIBUTE12
, POLB.ATTRIBUTE13
, POLB.ATTRIBUTE14
, POLB.ATTRIBUTE15
, POLB.DISPLAY_IN_LEASE_CENTER
, FL.MEANING DISP_IN_LEASE_CNTR_MEANING
, POLB.LEGAL_ENTITY_ID LEGAL_ENTITY_ID
FROM OKL_POOLS POLB
, OKC_K_HEADERS_ALL_B CHRB
, OKC_STATUSES_B STSB
, OKC_STATUSES_TL CSTS
, OKC_STATUSES_TL PSTS
, FND_LOOKUPS FL
WHERE POLB.KHR_ID = CHRB.ID
AND CHRB.STS_CODE = CSTS.CODE
AND CSTS.CODE = STSB.CODE
AND CSTS.LANGUAGE = USERENV('LANG')
AND POLB.STATUS_CODE = PSTS.CODE
AND PSTS.LANGUAGE = USERENV('LANG')
AND NVL(POLB.DISPLAY_IN_LEASE_CENTER
, 'N') = FL.LOOKUP_CODE
AND FL.LOOKUP_TYPE = 'OKL_YES_NO'

Columns

Name
ID
POOL_NUMBER
CURRENCY_CODE
TOTAL_PRINCIPAL_AMOUNT
TOTAL_RECEIVABLE_AMOUNT
DATE_CREATED
DATE_LAST_UPDATED
DATE_LAST_RECONCILED
DATE_TOTAL_PRINCIPAL_CALC
KHR_ID
STATUS_CODE
STATUS
AGREEMENT_NUMBER
AGREEMENT_STE_CODE
AGREEMENT_STS_CODE
AGREEMENT_STATUS
DESCRIPTION
SHORT_DESCRIPTION
LAST_UPDATE_DATE
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
DISPLAY_IN_LEASE_CENTER
DISP_IN_LEASE_CNTR_MEANING
LEGAL_ENTITY_ID