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_AM_AMORT_HOLD_SETUPS_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_AM_AMORT_HOLD_SETUPS_UV

View Text

SELECT AMH.ROWID ROW_ID
, AMH.ID ID
, AMH.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, AMH.HOLD_PERIOD_DAYS HOLD_PERIOD_DAYS
, AMH.CATEGORY_ID CATEGORY_ID
, FACAT.DESCRIPTION FA_CATEGORY_DESCRIPTION
, AMH.BOOK_TYPE_CODE BOOK_TYPE_CODE
, AMH.METHOD_ID METHOD_ID
, FAMET.NAME DEPRN_METHOD_NAME
, FAMET.METHOD_CODE DEPRN_METHOD_CODE
, FAMET.LIFE_IN_MONTHS LIFE_IN_MONTHS
, AMH.ORG_ID ORG_ID
, AMH.CREATED_BY CREATED_BY
, AMH.CREATION_DATE CREATION_DATE
, AMH.LAST_UPDATED_BY LAST_UPDATED_BY
, AMH.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AMH.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, FABKC.BOOK_TYPE_NAME ASSET_BOOK_NAME
, FABKC.BOOK_CLASS ASSET_BOOK_TYPE
, (AMH.DEPRN_RATE * 100) DEPRN_RATE
FROM OKL_AMORT_HOLD_SETUPS AMH
, FA_CATEGORIES_VL FACAT
, FA_BOOK_CONTROLS FABKC
, FA_METHODS FAMET
WHERE AMH.BOOK_TYPE_CODE = FABKC.BOOK_TYPE_CODE
AND AMH.CATEGORY_ID = FACAT.CATEGORY_ID
AND AMH.METHOD_ID = FAMET.METHOD_ID (+)

Columns

Name
ROW_ID
ID
OBJECT_VERSION_NUMBER
HOLD_PERIOD_DAYS
CATEGORY_ID
FA_CATEGORY_DESCRIPTION
BOOK_TYPE_CODE
METHOD_ID
DEPRN_METHOD_NAME
DEPRN_METHOD_CODE
LIFE_IN_MONTHS
ORG_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
ASSET_BOOK_NAME
ASSET_BOOK_TYPE
DEPRN_RATE