Product: | OKL - Lease and Finance Management |
---|---|
Description: | View holds subsidy pool transactions |
Implementation/DBA Data: | APPS.OKL_TRX_SUBSIDY_POOLS_V |
SELECT SIXB.ROWID ROW_ID
, SIXB.ID ID
, SIXB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SIXB.TRX_TYPE_CODE TRX_TYPE_CODE
, SIXB.SOURCE_TYPE_CODE SOURCE_TYPE_CODE
, SIXB.SOURCE_OBJECT_ID SOURCE_OBJECT_ID
, SIXB.SUBSIDY_POOL_ID SUBSIDY_POOL_ID
, SIXB.DNZ_ASSET_NUMBER DNZ_ASSET_NUMBER
, SIXB.VENDOR_ID VENDOR_ID
, SIXB.SOURCE_TRX_DATE SOURCE_TRX_DATE
, SIXB.TRX_DATE TRX_DATE
, SIXB.SUBSIDY_ID SUBSIDY_ID
, SIXB.TRX_REASON_CODE TRX_REASON_CODE
, SIXB.TRX_CURRENCY_CODE TRX_CURRENCY_CODE
, SIXB.TRX_AMOUNT TRX_AMOUNT
, SIXB.SUBSIDY_POOL_CURRENCY_CODE SUBSIDY_POOL_CURRENCY_CODE
, SIXB.SUBSIDY_POOL_AMOUNT SUBSIDY_POOL_AMOUNT
, SIXB.CONVERSION_RATE CONVERSION_RATE
, SIXB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, SIXB.ATTRIBUTE1 ATTRIBUTE1
, SIXB.ATTRIBUTE2 ATTRIBUTE2
, SIXB.ATTRIBUTE3 ATTRIBUTE3
, SIXB.ATTRIBUTE4 ATTRIBUTE4
, SIXB.ATTRIBUTE5 ATTRIBUTE5
, SIXB.ATTRIBUTE6 ATTRIBUTE6
, SIXB.ATTRIBUTE7 ATTRIBUTE7
, SIXB.ATTRIBUTE8 ATTRIBUTE8
, SIXB.ATTRIBUTE9 ATTRIBUTE9
, SIXB.ATTRIBUTE10 ATTRIBUTE10
, SIXB.ATTRIBUTE11 ATTRIBUTE11
, SIXB.ATTRIBUTE12 ATTRIBUTE12
, SIXB.ATTRIBUTE13 ATTRIBUTE13
, SIXB.ATTRIBUTE14 ATTRIBUTE14
, SIXB.ATTRIBUTE15 ATTRIBUTE15
, SIXB.CREATED_BY CREATED_BY
, SIXB.CREATION_DATE CREATION_DATE
, SIXB.LAST_UPDATED_BY LAST_UPDATED_BY
, SIXB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SIXB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKL_TRX_SUBSIDY_POOLS SIXB