摘要：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
阅读全文
摘要：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
阅读全文
摘要：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
阅读全文
摘要：设置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
阅读全文
