VIEW: APPS.JA_AU_BAL_CHG_DETAILS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'