View: JA_AU_SOURCE_ADDITIONS_BOOKS_V

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

View Text

SELECT JBCS.ASSET_ID
, JBCS.BOOK_TYPE_CODE
, JBCS.DATE_RETIRED
, 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
, JBCS.BAL_CHG_AMOUNT BAL_CHG_TOTAL
, JBCS.BAL_CHG_APPLIED BAL_CHG_APPLIED
, JBCS.BAL_CHG_AMOUNT - JBCS.BAL_CHG_APPLIED BAL_CHG_REMAINING
FROM JA_AU_BAL_CHG_SOURCE JBCS
, FA_ADDITIONS FADD
WHERE JBCS.ASSET_ID = FADD.ASSET_ID

Columns