Product: | JA - Asia/Pacific Localizations |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.JA_AU_SOURCE_ADDITIONS_BOOKS_V |
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