Product: | OKL - Lease and Finance Management |
---|---|
Description: | View holds all subsidy pools in the system |
Implementation/DBA Data: | APPS.OKL_SUBSIDY_POOLS_V |
SELECT SIPB.ROWID ROW_ID
, SIPB.ID ID
, SIPB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SIPT.SFWT_FLAG SFWT_FLAG
, SIPB.POOL_TYPE_CODE POOL_TYPE_CODE
, SIPB.SUBSIDY_POOL_NAME SUBSIDY_POOL_NAME
, SIPT.SHORT_DESCRIPTION SHORT_DESCRIPTION
, SIPT.DESCRIPTION DESCRIPTION
, SIPB.EFFECTIVE_FROM_DATE EFFECTIVE_FROM_DATE
, SIPB.EFFECTIVE_TO_DATE EFFECTIVE_TO_DATE
, SIPB.CURRENCY_CODE CURRENCY_CODE
, SIPB.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, SIPB.DECISION_STATUS_CODE DECISION_STATUS_CODE
, SIPB.SUBSIDY_POOL_ID SUBSIDY_POOL_ID
, SIPB.REPORTING_POOL_LIMIT REPORTING_POOL_LIMIT
, SIPB.TOTAL_BUDGETS TOTAL_BUDGETS
, SIPB.TOTAL_SUBSIDY_AMOUNT TOTAL_SUBSIDY_AMOUNT
, SIPB.DECISION_DATE DECISION_DATE
, SIPB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, SIPB.ATTRIBUTE1 ATTRIBUTE1
, SIPB.ATTRIBUTE2 ATTRIBUTE2
, SIPB.ATTRIBUTE3 ATTRIBUTE3
, SIPB.ATTRIBUTE4 ATTRIBUTE4
, SIPB.ATTRIBUTE5 ATTRIBUTE5
, SIPB.ATTRIBUTE6 ATTRIBUTE6
, SIPB.ATTRIBUTE7 ATTRIBUTE7
, SIPB.ATTRIBUTE8 ATTRIBUTE8
, SIPB.ATTRIBUTE9 ATTRIBUTE9
, SIPB.ATTRIBUTE10 ATTRIBUTE10
, SIPB.ATTRIBUTE11 ATTRIBUTE11
, SIPB.ATTRIBUTE12 ATTRIBUTE12
, SIPB.ATTRIBUTE13 ATTRIBUTE13
, SIPB.ATTRIBUTE14 ATTRIBUTE14
, SIPB.ATTRIBUTE15 ATTRIBUTE15
, SIPB.CREATED_BY CREATED_BY
, SIPB.CREATION_DATE CREATION_DATE
, SIPB.LAST_UPDATED_BY LAST_UPDATED_BY
, SIPB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SIPB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKL_SUBSIDY_POOLS_B SIPB
, OKL_SUBSIDY_POOLS_TL SIPT
WHERE SIPT.ID = SIPB.ID
AND SIPT.LANGUAGE = USERENV('LANG')