随笔分类 -  Oracle EBS Inv

Material Workbench Query Logic
摘要：What's main code logic while performing query in material workbench form(INVMWBIV.fmb).Key File:INVMWBIV.fmbINVMWQMB.pls - INV_MWB_QUERY_MANAGERINVMWCTB.pls - INV_MWB_CONTROLLERKey Table:MTL_MWB_GTMPmtl_onhand_quantities_detail=====================First Delete All records from MTL_MWB_GTMP.DELET 阅读全文

posted @ 2012-07-03 17:34 h2内存数据库 阅读(433) 评论(0) 推荐(0)

Cycle Count Interface Table - MTL_CC_ENTRIES_INTERFACE
摘要：The MTL_CC_ENTRIES_INTERFACE table serves as the interface between users and Oracle Inventory's Enter/Approve Cycle Count Request functionality. Users populate the interface table, and a PL/SQLconcurrent program, launched by the user, processes the information in this table, inserts/updates the 阅读全文

posted @ 2012-07-02 23:23 h2内存数据库 阅读(549) 评论(0) 推荐(0)

INV&WMS Picking Rule
摘要：Inventory Picking Rule(Oracle Apps R12)用于在非WMS组织下，给Sales Order, WIP, OPM Manufacturing设置挑库规则路径:Inventory > Setup > Rules > PickingLot: You can sort by lot based on the following criteria:Lot Number Asc: Sorts the lot by number in ascending order.Lot Number Desc: Sorts the lot by number in d 阅读全文

posted @ 2012-07-02 14:48 h2内存数据库 阅读(549) 评论(0) 推荐(0)

Move Order Approval Workflow
摘要：设置1.Organization Item的Planner设置审批用户,注意Planner如果设置为当前User，就不会走工作流审批流程2.Organization Parameter form设置两个参数Move Order Time Out Period > 0Move Order Time Out Action = Approve/RejectDemo1.创建Move Order，审批后状态为Pengding Approval2.切换到Planner用户，在Worklist里就能看到那条审批申请，这里就可以Approve3.最后到Workflow Administrator Web 阅读全文

posted @ 2012-05-11 10:46 h2内存数据库 阅读(226) 评论(0) 推荐(0)

导航