Product: | OKL - Lease and Finance Management |
---|---|
Description: | View for OKL_ASSETS_B and OKL_ASSETS_TL |
Implementation/DBA Data: | APPS.OKL_ASSETS_V |
SELECT ASS.ROWID ROW_ID
, ASS.ID ID
, ASS.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ASS.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ASS.ATTRIBUTE1 ATTRIBUTE1
, ASS.ATTRIBUTE2 ATTRIBUTE2
, ASS.ATTRIBUTE3 ATTRIBUTE3
, ASS.ATTRIBUTE4 ATTRIBUTE4
, ASS.ATTRIBUTE5 ATTRIBUTE5
, ASS.ATTRIBUTE6 ATTRIBUTE6
, ASS.ATTRIBUTE7 ATTRIBUTE7
, ASS.ATTRIBUTE8 ATTRIBUTE8
, ASS.ATTRIBUTE9 ATTRIBUTE9
, ASS.ATTRIBUTE10 ATTRIBUTE10
, ASS.ATTRIBUTE11 ATTRIBUTE11
, ASS.ATTRIBUTE12 ATTRIBUTE12
, ASS.ATTRIBUTE13 ATTRIBUTE13
, ASS.ATTRIBUTE14 ATTRIBUTE14
, ASS.ATTRIBUTE15 ATTRIBUTE15
, ASS.CREATED_BY CREATED_BY
, ASS.CREATION_DATE CREATION_DATE
, ASS.LAST_UPDATED_BY LAST_UPDATED_BY
, ASS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ASS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ASS.PARENT_OBJECT_CODE PARENT_OBJECT_CODE
, ASS.PARENT_OBJECT_ID PARENT_OBJECT_ID
, ASS.ASSET_NUMBER ASSET_NUMBER
, ASS.INSTALL_SITE_ID INSTALL_SITE_ID
, ASS.STRUCTURED_PRICING STRUCTURED_PRICING
, ASS.RATE_TEMPLATE_ID RATE_TEMPLATE_ID
, ASS.RATE_CARD_ID RATE_CARD_ID
, ASS.LEASE_RATE_FACTOR LEASE_RATE_FACTOR
, ASS.TARGET_ARREARS TARGET_ARREARS
, ASS.OEC OEC
, ASS.OEC_PERCENTAGE OEC_PERCENTAGE
, ASS.END_OF_TERM_VALUE_DEFAULT END_OF_TERM_VALUE_DEFAULT
, ASS.END_OF_TERM_VALUE END_OF_TERM_VALUE
, ASST.SHORT_DESCRIPTION SHORT_DESCRIPTION
, ASST.DESCRIPTION DESCRIPTION
, ASST.COMMENTS COMMENTS
, ASS.ORIG_ASSET_ID ORIG_ASSET_ID
, ASS.TARGET_AMOUNT TARGET_AMOUNT
, ASS.TARGET_FREQUENCY TARGET_FREQUENCY
FROM OKL_ASSETS_B ASS
, OKL_ASSETS_TL ASST
WHERE ASS.ID = ASST.ID
AND ASST.LANGUAGE = USERENV('LANG')