oracle_资产模块总结.docxVIP

十月总结二资产模块个人总结Author:jun.zhanCreation Date:October 29, 2012Last Updated:October 29, 2012Document Ref:MD120Version:1.0Title, Subject, Last Updated Date, Reference Number, andVersion are marked by a Word Bookmark so that they can be easily reproduced in the header and footer of documents. When you change any of these values, be careful not to accidentally delete the bookmark. You can make bookmarks visible by selecting Tools-Options…View and checking the Bookmarks option in the Show region.文档控制更改记录1DateAuthorVersionChange ReferenceOctober 29, 2012Jun.zhan审阅NamePosition分发记录Copy No.NameLocationThe copy numbers referenced above should be written into the Copy Number space on the cover of each distributed copy. If the document is not controlled, you can delete this table, the Note To Holders, and the Copy Number label from the cover page.目录文档控制ii有关资产报表开发总结1资产事务处理类型1累计折旧计算2会计分录3资产对应的表4解决和未解决的问题6已解决的问题6未解决的问题6To update the table of contents, put the cursor anywhere in the table and press [F9]. To change the number of levels displayed, select the menu option InsertIndex and Tables, make sure the Table of Contents tab is active, and change the Number of Levels to a new value.有关资产报表开发总结本文将详细介绍租赁资产科目结转报表中理解到的，或许有不正确的。仅作参考If the Functional Design included a Technical Overview section, duplicate that information here and add additional details.资产事务处理类型主要内容增加事务处理报废事务处理脚本增加事务处理：逻辑，由事务处理资产的ID，关联到增加事务处理资产的ID，在关联到固定资产中转弹性域。SELECT FT.TRANSACTION_TYPE 事务处理类别, FAV.PROPERTY_TYPE_MEANING 事务处理类型, FT.PERIOD_EFFECTIVE 期间, SUM(L.Accounted_Cr) 固定资产中转金额, NULL 固定资产清理金额 FROM FA_TRANSACTION_HISTORY_TRX_V FT, --事务处理 FA_ADDITIONS_V FAV,--增加事物类型 FA_LOOKUPS_VL FL1,xla_transaction_entities XTE,xla_ae_headers H,xla_ae_lines L, --会计分录apps.gl_code_combinations_kfv GL --会计科目,fnd_flex_values_vlffv WHERE FT.ASSET_ID = fAV.ASSET_ID AND FT.TRANSACTION_TYPE_code IN (ADDITION) AND FAV.PROPERTY_TYPE_CO