View: JA_AU_FA_ADD_ADJ_V

Product:	JA - Asia/Pacific Localizations
Description:	- Retrofitted
Implementation/DBA Data:	APPS.JA_AU_FA_ADD_ADJ_V

View Text

SELECT JBCS.ASSET_ID SOURCE_ASSET_ID
, JBCA.BAL_CHG_ID SOURCE_BAL_CHG_ID
, JBCA.BAL_CHG_APPLIED
, JBCA.CREATION_DATE
, JBCA.ASSET_ID
, FADD.ASSET_NUMBER
, FADD.TAG_NUMBER
, FADD.DESCRIPTION
, FADD.ASSET_CATEGORY_ID
, FADD.ATTRIBUTE_CATEGORY_CODE
, FADD.ASSET_KEY_CCID
, FADD.ASSET_TYPE
, FADD.MANUFACTURER_NAME
, FADD.MODEL_NUMBER
, FADD.SERIAL_NUMBER
, FADD.CURRENT_UNITS
, FABO.ORIGINAL_COST
, FABO.COST
, FABO.DATE_PLACED_IN_SERVICE
, FABO.BOOK_TYPE_CODE
, FABO.SALVAGE_VALUE
, FABO.RECOVERABLE_COST
, FABO.ADJUSTED_RATE
, FABO.CEILING_NAME
, FABO.BONUS_RULE
, FABO.DEPRN_METHOD_CODE
, FABO.LIFE_IN_MONTHS
, FABO.PRORATE_DATE
, FABO.DEPRN_START_DATE
, FABO.DEPRECIATE_FLAG
, FABO.RATE_ADJUSTMENT_FACTOR
, FABO.REVAL_AMORTIZATION_BASIS
, FABO.PRODUCTION_CAPACITY
FROM FA_BOOKS FABO
, FA_ADDITIONS FADD
, JA_AU_BAL_CHG_APPLIED JBCA
, JA_AU_BAL_CHG_SOURCE JBCS
WHERE JBCA.ASSET_ID = FADD.ASSET_ID
AND JBCA.BAL_CHG_ID = JBCS.BAL_CHG_ID
AND JBCA.BOOK_TYPE_CODE = JBCS.BOOK_TYPE_CODE
AND FABO.BOOK_TYPE_CODE = JBCA.BOOK_TYPE_CODE
AND FABO.ASSET_ID = JBCA.ASSET_ID
AND FABO.DATE_INEFFECTIVE IS NULL
AND NVL(FABO.DEPRECIATE_FLAG
, 'ZZZ') = 'YES'
AND NVL(FADD.PROPERTY_TYPE_CODE
, 'ZZZ') <> 'DIV 10D'

Columns