Product: | JA - Asia/Pacific Localizations |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.JA_AU_BAL_CHG_DETAILS_V |
SELECT FBK.ASSET_ID
, FBK.BOOK_TYPE_CODE
, JBS.ROWID ROW_ID
, JBS.BAL_CHG_ID
, JBS.RETIREMENT_ID
, JBS.LAST_UPDATE_DATE
, JBS.LAST_UPDATED_BY
, JBS.CREATED_BY
, JBS.CREATION_DATE
, JBS.LAST_UPDATE_LOGIN
, JBS.BAL_CHG_APPLIED BAL_CHG_SOURCED
, JBS.BAL_CHG_AMOUNT
, JBS.DATE_RETIRED
, DECODE(JBS.BAL_CHG_STATUS
, 'F'
, 'FULLY APPLIED'
, 'P'
, 'PARTIALLY APPLIED'
, 'N'
, 'NOT APPLIED'
, 'R'
, 'REVERSED'
, 'UNKNOWN') BAL_CHG_STATUS
, JBA.BAL_CHG_APPLIED BAL_CHG_APPLIED
, NVL(JBS.BAL_CHG_AMOUNT
, 0) - NVL(JBS.BAL_CHG_APPLIED
, 0) BAL_CHG_REMAINING
FROM FA_BOOKS FBK
, JA_AU_BAL_CHG_SOURCE JBS
, JA_AU_BAL_CHG_APPLIED JBA
, JA_AU_FA_BOOK_CONTROLS JBC
WHERE JBS.ASSET_ID (+) = FBK.ASSET_ID
AND JBA.ASSET_ID (+) = FBK.ASSET_ID
AND JBA.BOOK_TYPE_CODE (+) = FBK.BOOK_TYPE_CODE
AND JBS.BOOK_TYPE_CODE (+) = FBK.BOOK_TYPE_CODE
AND FBK.DATE_INEFFECTIVE IS NULL
AND JBC.BOOK_TYPE_CODE = FBK.BOOK_TYPE_CODE
AND JBC.BAL_CHARGE_ENABLED='YES'
AND NVL(FBK.DEPRECIATE_FLAG
, 'ZZZ') = 'YES'