Fixed Assets quer 2016.txt

Description
SELECT cc.segment1 Company , cc.segment2 Branch , cc.segment5 Cost Center , ca.segment1 Main Cat , -- ca.segment2 sub Cat , fdp.period_name, fdp.fiscal_year, round(SUM(RSV.DEPRN_AMOUNT)/5,2) DEPRN_AMOUNT FROM FA_RESERVE_LEDGER_ITF RSV, FA_ADDITIONS AD, FA_ASSET_HISTORY AH, FA_CATEGORY_BOOKS CB, GL_CODE_COMBINATIONS CC, FA_DEPRN_SUMMARY DS, fa_deprn_periods fdp, fa_categories_b ca WHERE RSV.ASSET_ID = AD.ASSET_ID AND RSV.DH_CCID = CC.CODE_COMBINATION_ID AND CB.BOOK_TYPE_CODE = 'TYRES BOOK' A

Please download to get full document.

View again

of 5
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Information
Category:

Documents

Publish on:

Views: 92 | Pages: 5

Extension: PDF | Download: 1

Share
Transcript
  SELECT cc.segment1 Company , cc.segment2 Branch , cc.segment5 Cost Center , ca.segment1 Main Cat , -- ca.segment2 sub Cat , fdp.period_name, fdp.fiscal_year, round(SUM(RSV.DEPRN_AMOUNT)/5,2) DEPRN_AMOUNT FROM FA_RESERVE_LEDGER_ITF RSV, FA_ADDITIONS AD, FA_ASSET_HISTORY AH, FA_CATEGORY_BOOKS CB, GL_CODE_COMBINATIONS CC, FA_DEPRN_SUMMARY DS, fa_deprn_periods fdp, fa_categories_b ca WHERE RSV.ASSET_ID = AD.ASSET_ID AND RSV.DH_CCID = CC.CODE_COMBINATION_ID AND CB.BOOK_TYPE_CODE = 'TYRES BOOK' AND CB.CATEGORY_ID = AH.CATEGORY_ID AND AH.ASSET_ID = AD.ASSET_ID AND AH.DATE_EFFECTIVE < RSV.DATE_EFFECTIVE AND nvl(AH.DATE_INEFFECTIVE, SYSDATE) >= RSV.DATE_EFFECTIVE AND DS.PERIOD_COUNTER(+) = RSV.PERIOD_COUNTER AND DS.BOOK_TYPE_CODE(+) = 'TYRES BOOK' AND DS.ASSET_ID(+) = RSV.ASSET_ID and ca.category_id =cb.category_id and fdp.period_name = 'JAN-16'AND fdp.book_type_code = 'TYRES BOOK'and cc.segment1='02'and cc.segment2='01'--and cc.segment5='1222'and fdp.period_counter =rsv.period_counter GROUP BY cc.segment1, cc.segment2 , cc.segment5 , fdp.period_name, fdp.fiscal_year, ca.segment1 -- ca.segment2 order by cc.segment5----------------------------------SELECT cc.segment1 Company , cc.segment2 Branch , cc.segment5 Cost Center , ca.segment1 Main Cat , -- ca.segment2 sub Cat , fdp.period_name, fdp.fiscal_year, round(SUM(RSV.DEPRN_AMOUNT) / 3, 2) DEPRN_AMOUNT FROM FA_RESERVE_LEDGER_ITF RSV, FA_ADDITIONS AD, FA_ASSET_HISTORY AH, FA_CATEGORY_BOOKS CB, GL_CODE_COMBINATIONS CC, FA_DEPRN_SUMMARY DS, fa_deprn_periods fdp, fa_categories_b ca   WHERE RSV.ASSET_ID = AD.ASSET_ID AND RSV.DH_CCID = CC.CODE_COMBINATION_ID AND CB.BOOK_TYPE_CODE = 'TYRES ER BOOK' --'TYRES BOOK' AND CB.CATEGORY_ID = AH.CATEGORY_ID AND AH.ASSET_ID = AD.ASSET_ID AND AH.DATE_EFFECTIVE < RSV.DATE_EFFECTIVE AND nvl(AH.DATE_INEFFECTIVE, SYSDATE) >= RSV.DATE_EFFECTIVE AND DS.PERIOD_COUNTER(+) = RSV.PERIOD_COUNTER AND DS.BOOK_TYPE_CODE(+) = 'TYRES ER BOOK' AND DS.ASSET_ID(+) = RSV.ASSET_ID and ca.category_id = cb.category_id and fdp.period_name = 'JAN-16' AND fdp.book_type_code = 'TYRES ER BOOK' --'TYRES BOOK' and cc.segment1 = '02' and cc.segment2 = '03' and fdp.period_counter = rsv.period_counter GROUP BY cc.segment1, cc.segment2, cc.segment5, fdp.period_name, fdp.fiscal_year, ca.segment1-- ca.segment2 order by cc.segment5--------------------------------------------------SELECT cc.segment1 Company , cc.segment2 Branch , cc.segment5 Cost Center , ca.segment1 Main Cat , -- ca.segment2 sub Cat , fdp.period_name, fdp.fiscal_year, round(SUM(RSV.DEPRN_AMOUNT) / 3, 2) DEPRN_AMOUNT FROM FA_RESERVE_LEDGER_ITF RSV, FA_ADDITIONS AD, FA_ASSET_HISTORY AH, FA_CATEGORY_BOOKS CB, GL_CODE_COMBINATIONS CC, FA_DEPRN_SUMMARY DS, fa_deprn_periods fdp, fa_categories_b ca WHERE RSV.ASSET_ID = AD.ASSET_ID AND RSV.DH_CCID = CC.CODE_COMBINATION_ID AND CB.BOOK_TYPE_CODE = 'HO BOOK'--'TYRES ER BOOK' --'TYRES BOOK' AND CB.CATEGORY_ID = AH.CATEGORY_ID AND AH.ASSET_ID = AD.ASSET_ID AND AH.DATE_EFFECTIVE < RSV.DATE_EFFECTIVE AND nvl(AH.DATE_INEFFECTIVE, SYSDATE) >= RSV.DATE_EFFECTIVE AND DS.PERIOD_COUNTER(+) = RSV.PERIOD_COUNTER AND DS.BOOK_TYPE_CODE(+) = 'HO BOOK'--'TYRES ER BOOK' AND DS.ASSET_ID(+) = RSV.ASSET_ID and ca.category_id = cb.category_id and fdp.period_name = 'JAN-16' AND fdp.book_type_code = 'HO BOOK'--'TYRES ER BOOK' --'TYRES BOOK' and cc.segment1 = '03' and cc.segment2 = '01' and fdp.period_counter = rsv.period_counter GROUP BY cc.segment1, cc.segment2,   cc.segment5, fdp.period_name, fdp.fiscal_year, ca.segment1-- ca.segment2 order by cc.segment5------------------------------------------------------------SELECT cc.segment1 Company , cc.segment2 Branch , cc.segment5 Cost Center , ca.segment1 Main Cat , -- ca.segment2 sub Cat , fdp.period_name, fdp.fiscal_year, round(SUM(RSV.DEPRN_AMOUNT) / 2, 2) DEPRN_AMOUNT FROM FA_RESERVE_LEDGER_ITF RSV, FA_ADDITIONS AD, FA_ASSET_HISTORY AH, FA_CATEGORY_BOOKS CB, GL_CODE_COMBINATIONS CC, FA_DEPRN_SUMMARY DS, fa_deprn_periods fdp, fa_categories_b ca WHERE RSV.ASSET_ID = AD.ASSET_ID AND RSV.DH_CCID = CC.CODE_COMBINATION_ID AND CB.BOOK_TYPE_CODE = 'HO ER BOOK'--'TYRES ER BOOK' --'TYRES BOOK' AND CB.CATEGORY_ID = AH.CATEGORY_ID AND AH.ASSET_ID = AD.ASSET_ID AND AH.DATE_EFFECTIVE < RSV.DATE_EFFECTIVE AND nvl(AH.DATE_INEFFECTIVE, SYSDATE) >= RSV.DATE_EFFECTIVE AND DS.PERIOD_COUNTER(+) = RSV.PERIOD_COUNTER AND DS.BOOK_TYPE_CODE(+) = 'HO ER BOOK'--'HO BOOK'--'TYRES ER BOOK' AND DS.ASSET_ID(+) = RSV.ASSET_ID and ca.category_id = cb.category_id and fdp.period_name = 'JAN-16' AND fdp.book_type_code = 'HO ER BOOK'--'HO BOOK'--'TYRES ER BOOK' --'TYRES BOOK' and cc.segment1 = '03' and cc.segment2 = '03' and fdp.period_counter = rsv.period_counter GROUP BY cc.segment1, cc.segment2, cc.segment5, fdp.period_name, fdp.fiscal_year, ca.segment1-- ca.segment2 order by cc.segment5-----------------------------------------------------------------------------SELECT cc.segment1 Company , cc.segment2 Branch , cc.segment5 Cost Center , ca.segment1 Main Cat , -- ca.segment2 sub Cat , fdp.period_name, fdp.fiscal_year, round(SUM(RSV.DEPRN_AMOUNT) / 3, 2) DEPRN_AMOUNT   FROM FA_RESERVE_LEDGER_ITF RSV, FA_ADDITIONS AD, FA_ASSET_HISTORY AH, FA_CATEGORY_BOOKS CB, GL_CODE_COMBINATIONS CC, FA_DEPRN_SUMMARY DS, fa_deprn_periods fdp, fa_categories_b ca WHERE RSV.ASSET_ID = AD.ASSET_ID AND RSV.DH_CCID = CC.CODE_COMBINATION_ID AND CB.BOOK_TYPE_CODE = 'AHC BOOK'--'TYRES ER BOOK' --'TYRES BOOK' AND CB.CATEGORY_ID = AH.CATEGORY_ID AND AH.ASSET_ID = AD.ASSET_ID AND AH.DATE_EFFECTIVE < RSV.DATE_EFFECTIVE AND nvl(AH.DATE_INEFFECTIVE, SYSDATE) >= RSV.DATE_EFFECTIVE AND DS.PERIOD_COUNTER(+) = RSV.PERIOD_COUNTER AND DS.BOOK_TYPE_CODE(+) = 'AHC BOOK'--'HO BOOK'--'TYRES ER BOOK' AND DS.ASSET_ID(+) = RSV.ASSET_ID and ca.category_id = cb.category_id and fdp.period_name = 'JAN-16' AND fdp.book_type_code = 'AHC BOOK'--'HO BOOK'--'TYRES ER BOOK' --'TYRES BOOK' and cc.segment1 = '01' --and cc.segment2 = '03' and fdp.period_counter = rsv.period_counter GROUP BY cc.segment1, cc.segment2, cc.segment5, fdp.period_name, fdp.fiscal_year, ca.segment1-- ca.segment2 order by cc.segment5===================================================== SELECT cc.segment1 Company , cc.segment2 Branch , cc.segment5 Cost Center , ca.segment1 Main Cat , SUM(DS.DEPRN_AMOUNT) FROM FA_DEPRN_SUMMARY DS ,FA_DISTRIBUTION_HISTORY DH ,GL_CODE_COMBINATIONS CC ,fa_deprn_periods FDP , fa_categories_b ca -- ,FA_CATEGORY_BOOKS CB ,FA_ASSET_HISTORY AH WHERE/* DS.ASSET_ID=17419 AND DS.PERIOD_COUNTER=24193 AND */DS.ASSET_ID=DH.ASSET_ID AND CC.CODE_COMBINATION_ID=DH.CODE_COMBINATION_ID AND FDP.PERIOD_COUNTER =DS.PERIOD_COUNTER AND CA.CATEGORY_ID = AH.CATEGORY_ID AND AH.ASSET_ID =DS.ASSET_ID AND FDP.PERIOD_NAME='JAN-16' AND FDP.BOOK_TYPE_CODE = 'TYRES BOOK' AND cc.segment1='02' GROUP BY cc.segment1, cc.segment2 , cc.segment5,
Related Search
We Need Your Support
Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

Thanks to everyone for your continued support.

No, Thanks