VIEW: APPS.OKL_AM_AMORT_HOLD_SETUPS_UV

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)