-
编辑 删除
出货相关SQL
select wdd.source_header_number, wdd.source_line_id, wdd.delivery_detail_id, wdd.released_status,wdd.creation_date from wsh_delivery_details wdd,oe_order_lines_all ol where wdd.source_code = 'OE' and ...
-
编辑 删除
使用弹性域-说明性弹性域--轉載郭振斌
使用弹性域-说明性弹性域 弹性域分成键弹性域、说明性弹性域。这两种弹性域用途是不一样的。关键性弹性域：在使用KEY 弹性域的基表中，只保存ID。但可以通 ID 查询到相应的SEGMENT。在表结构中表现为***_ID、SEG...
-
编辑 删除
Segment Security Rules FAQ [ID 138143.1]
Segment Security Rules FAQ [ID 138143.1] Modified 05-AUG-2010 Type FAQ Status PUBLISHED In this Document &n...
-
编辑 删除
Segment Security Rules FAQ [ID 138143.1]
Segment Security Rules FAQ [ID 138143.1] Modified 05-AUG-2010 Type FAQ Status PUBLISHED In this Document &n...
-
编辑 删除
FA固定资产报废不可撤消重建--摘自arrwei
http://erplife.blog.sohu.com/75435349.html资产报废及重建业务补充说明按数量或成本进行的完全报废和部分报废 您可以报废整个资产，也可以将资产部分报废。 &nbs...
-
编辑 删除
Unplanned depreciation
Unplanned depreciation [ID 114298.1] Modified 15-JAN-2007 Type BULLETIN Status PUBLISHED Checked for relevance 09...
-
编辑 删除
How Depreciation Is Calculated With Monthly Depreciation Calendar,
How Depreciation Is Calculated With Monthly Depreciation Calendar, Daily Prorate And Even Depreciation Distribution [ID 343601.1] Modified 14-APR-2010 &nbs...
-
编辑 删除
STL Depreciation Method And Daily Prorate Calendar? [ID 377505.1]
How Is Depreciation Calculated For STL Depreciation Method And Daily Prorate Calendar? [ID 377505.1] Modified 26-JUN-2009 Type HOWTO  ...
-
编辑 删除
Daily Prorate Calendar And By Days Depreciation Allocation
How Is Depreciation Calculated For STL Method With Life Less Than One Year , Daily Prorate Calendar And By Days Depreciation Allocation [ID 578762.1] Modified 25-MAY-2010 &n...
-
编辑 删除
前辈的一些经验，老是遗忘，铭记
定义值集：1 Table Name可使用别名，可引用多个Table/View，用逗号隔开，客制化的表或视图未经注册也可引用2 Table Column区域各列可使用一些非汇总函数总能，如两个列连接成为一列3 Where /Order By:支持一些比较复...
-
编辑 删除
GL-Technical Bulletins [ID 66651.1]
GL-Technical Bulletins [ID 66651.1] Modified 08-AUG-2003 Type BULLETIN Status PUBLISHED Oracle General Ledger Tec...
-
编辑 删除
Oracle Assets - List of Known bugs on Depreciation calculation [ID 1100524.1]
Oracle Assets - List of Known bugs on Depreciation calculation [ID 1100524.1] Modified 19-MAY-2010 Type BULLETIN Status ...
-
编辑 删除
FA ORACLE SUPPORT NOTES
Oracle Assets Top Notes by Topic - Depreciation [ID 307011.1] Modified 26-JUN-2009 Type BULLETIN Status PUBLISHED PURPOSE---...
-
编辑 删除
EBS-FA-STUDY 100916-01
First Fixed Assets (FA) Depreciation Period Is Much Earlier Than The Current General Ledger (GL) Period [ID 232846.1] Modified 21-MAR-2003 Type PROBL...
-
编辑 删除
ITEM_COST最后一次采购单价获取
此问题已经不是第一次遗忘了，以示警戒，有此日志，加油……select cstplpop.po_price(organization_id ,inventory_item_id) from dual--cstplpop package body as followsCREATE OR REPLACE PACKAGE BODY CSTPLP...
-
编辑 删除
Workflow学习
最近在搞Workflow因为几乎什么都不知道，所以决定记录下搜集的信息，我相信总有一天会因为这些只言片语茅塞顿开1.workflow engine APIs can be called by an application program or a workflow function in the ru...
-
编辑 删除
GL
HOW DO YOU BUDGET TO SUMMARY ACCOUNT LEVEL [ID 1009879.7]--https://support.oracle.comYou would like to know how to do a Budget to Summary Account Level in General Ledger.These are the steps to set up...
