[Home] [Help]
| Product: | OKL - Leasing and Finance Management |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT POL.ID ID
, POL.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, POL.POT_ID POT_ID
, POL.KHR_ID KHR_ID
, POL.POOL_NUMBER POOL_NUMBER
, POL.DESCRIPTION DESCRIPTION
, POL.SHORT_DESCRIPTION SHORT_DESCRIPTION
, POL.CURRENCY_CODE CURRENCY_CODE
, POL.TOTAL_PRINCIPAL_AMOUNT TOTAL_PRINCIPAL_AMOUNT
, POL.TOTAL_RECEIVABLE_AMOUNT TOTAL_RECEIVABLE_AMOUNT
, POL.SECURITIES_CREDIT_RATING SECURITIES_CREDIT_RATING
, POL.DATE_CREATED DATE_CREATED
, POL.DATE_LAST_UPDATED DATE_LAST_UPDATED
, POL.STATUS_CODE STATUS_CODE
, POL.DATE_LAST_RECONCILED DATE_LAST_RECONCILED
, POL.DATE_TOTAL_PRINCIPAL_CALC DATE_TOTAL_PRINCIPAL_CALC
, POL.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, POL.ATTRIBUTE1 ATTRIBUTE1
, POL.ATTRIBUTE2 ATTRIBUTE2
, POL.ATTRIBUTE3 ATTRIBUTE3
, POL.ATTRIBUTE4 ATTRIBUTE4
, POL.ATTRIBUTE5 ATTRIBUTE5
, POL.ATTRIBUTE6 ATTRIBUTE6
, POL.ATTRIBUTE7 ATTRIBUTE7
, POL.ATTRIBUTE8 ATTRIBUTE8
, POL.ATTRIBUTE9 ATTRIBUTE9
, POL.ATTRIBUTE10 ATTRIBUTE10
, POL.ATTRIBUTE11 ATTRIBUTE11
, POL.ATTRIBUTE12 ATTRIBUTE12
, POL.ATTRIBUTE13 ATTRIBUTE13
, POL.ATTRIBUTE14 ATTRIBUTE14
, POL.ATTRIBUTE15 ATTRIBUTE15
, POL.ORG_ID ORG_ID
, POL.REQUEST_ID REQUEST_ID
, POL.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, POL.PROGRAM_ID PROGRAM_ID
, POL.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, POL.CREATED_BY CREATED_BY
, POL.CREATION_DATE CREATION_DATE
, POL.LAST_UPDATED_BY LAST_UPDATED_BY
, POL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, POL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKL_POOLS POL
WHERE NVL(ORG_ID
, NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)