st.sun - 博客园

拉式工序不允许挂财务仓

摘要：应用Oracle Bill Of Materiel层LevelFunction函数名Funcgtion NameMT_BOMFDBOM表单名Form NameBOMFDBOM说明Description拉式工序不允许挂财务仓条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectB_INV_COMPS条件Condition:B_INV_COMPS.SUPPLY_TYPE LIKE '%拉式%'AND :B_INV_COMPS.SUPPLY_SUBINVENTORY LIKE 'M%'A 阅读全文

posted @ 2013-07-09 13:07 st.sun 阅读(174) 评论(0) 推荐(0)

拉式工序不允许倒冲财务仓

摘要：应用Oracle Work in Progress层LevelFunction函数名Funcgtion NameWIP_WIPMRMDF表单名Form NameWIPMRMDF说明Description拉式工序不允许倒冲财务仓条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectW_REQUIREMENTS条件Condition:W_REQUIREMENTS.WIP_SUPPLY_MEANING LIKE '%拉式%'AND :W_REQUIREMENTS.SUPPLY_SUBINVENTORY 阅读全文

posted @ 2013-07-09 13:06 st.sun 阅读(201) 评论(0) 推荐(0)

取消功能屏蔽

摘要：应用Oracle Work in Progress层LevelFunction函数名Funcgtion NameWIP_WIPMRMDF表单名Form NameWIPMRMDF说明Description取消功能屏蔽条件Condition触发器事件Tirgger EventWHEN-NEW-FORM-INSTANCE触发器对象Tirgger Object/条件Condition/处理模式Processing ModeNot in Enter-Query Mode上下文层/值Contest Level/ValueResponsibility/***职责活动Actions序号seq特性Typ... 阅读全文

posted @ 2013-07-09 13:05 st.sun 阅读(193) 评论(0) 推荐(0)

限制库存可交易更改

摘要：应用Oracle Inventory层LevelFunction函数名Funcgtion NameINV_INVIDITM_ORG表单名Form NameINVIDITM说明Description限制库存可交易更改条件Condition触发器事件Tirgger EventWHEN-NEW-FORM-INSTANCE触发器对象Tirgger Object/条件Condition/处理模式Processing ModeNot in Enter-Query Mode上下文层/值Contest Level/ValueResponsibility/***职责活动Actions序号seq特性Type.. 阅读全文

posted @ 2013-07-09 13:04 st.sun 阅读(182) 评论(0) 推荐(0)

只允许分配主组织编码

摘要：应用Oracle Inventory层LevelFunction函数名Funcgtion NameINV_INVIDITM表单名Form NameINVIDITM说明Description只允许分配主组织编码条件Condition触发器事件Tirgger EventWHEN-NEW-ITEM-INSTANCE触发器对象Tirgger ObjectMTL_SYSTEM_ITEMS.INVENTORY_ITEM_MIR条件Condition/处理模式Processing ModeBoth上下文层/值Contest Level/ValueResponsibility/***职责活动Actions. 阅读全文

posted @ 2013-07-09 13:03 st.sun 阅读(172) 评论(0) 推荐(0)

物料只允许分配****库存组织

摘要：应用Oracle Inventory层LevelFunction函数名Funcgtion NameINV_INVIDITM表单名Form NameINVIDITM说明Description只允许分配****库存组织条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectORG_ASSIGN条件Condition:ORG_ASSIGN.ORGANIZATION_CODE '***(库存代码或库存名)'处理模式Processing ModeBoth上下文层/值Contest Level/ValueRe 阅读全文

posted @ 2013-07-09 13:02 st.sun 阅读(194) 评论(0) 推荐(0)

不允许更改描述

摘要：应用Oracle Inventory层LevelFunction函数名Funcgtion NameINV_INVIDITM表单名Form NameINVIDITM说明Description不允许更改描述条件Condition触发器事件Tirgger EventWHEN-NEW-ITEM-INSTANCE触发器对象Tirgger ObjectMTL_SYSTEM_ITEMS.DESCRIPTION_MIR条件Condition/处理模式Processing ModeBoth上下文层/值Contest Level/ValueResponsibility/***职责活动Actions序号seq特. 阅读全文

posted @ 2013-07-09 13:01 st.sun 阅读(195) 评论(0) 推荐(0)

仅能修改产品类型

摘要：应用Oracle Manufacturing Planning层LevelFunction函数名Funcgtion NameCUXPLNITM表单名Form NameCUXPLNITM说明Description仅能修改产品类型条件Condition触发器事件Tirgger EventWHEN-NEW-FORM-INSTANCE触发器对象Tirgger Object/条件Condition/处理模式Processing ModeNot in Enter-Query Mode上下文层/值Contest Level/ValueResponsibility/***职责活动Actions序号se... 阅读全文

posted @ 2013-07-09 13:00 st.sun 阅读(204) 评论(0) 推荐(0)

采购件不允许挂BOM

摘要：应用Oracle Bill Of Materiel层LevelFunction函数名Funcgtion NameBOM_BOMFDBOM表单名Form NameBOMFDBOM说明Description采购件不允许挂BOM条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectB_BILL_OF_MATLS条件Condition'P' = (select nvl(item_type,'A') from inv.mtl_system_items_bwhere organization_ 阅读全文

posted @ 2013-07-09 13:00 st.sun 阅读(343) 评论(0) 推荐(0)

限制需求数量过大情况

摘要：应用Oracle Bill Of Materiel层LevelFunction函数名Funcgtion NameCUX_BOMFDBOM表单名Form NameCUXBOMFDBOM说明Description限制需求数量过大情况条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectB_INV_COMPS条件Condition:B_INV_COMPS.COMPONENT_QUANTITY >900000处理模式Processing ModeNot in Enter-Query Mode上下文层/值Conte 阅读全文

posted @ 2013-07-09 12:59 st.sun 阅读(182) 评论(0) 推荐(0)

限制**类型物料不能输入BOM

摘要：应用Oracle Bill Of Materiel层LevelFunction函数名Funcgtion NameCUX_BOMFDBOM表单名Form NameCUXBOMFDBOM说明Description限制**类型物料不能输入BOM条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectB_BILL_OF_MATLS条件Condition:B_BILL_OF_MATLS.ITEM_TYPE_CODE='**'处理模式Processing ModeNot in Enter-Query Mode上阅读全文

posted @ 2013-07-09 12:58 st.sun 阅读(253) 评论(0) 推荐(0)

限制Inactive物料录入BOM

摘要：应用Oracle Bill Of Materiel层LevelFunction函数名Funcgtion NameCUX_BOMFDBOM表单名Form NameCUXBOMFDBOM说明Description限制Inactive物料录入BOM条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectB_INV_COMPS条件Condition:B_INV_COMPS.INVENTORY_ITEM_STATUS_CODE ='Inactive'处理模式Processing ModeNot in Ente 阅读全文

posted @ 2013-07-09 12:56 st.sun 阅读(279) 评论(0) 推荐(0)

物料序号不可修改

摘要：应用Oracle Bill Of Materiel层LevelFunction函数名Funcgtion NameBOM_BOMFDBOM表单名Form NameBOMFDBOM说明Description物料序号不可修改条件Condition触发器事件Tirgger EventWHEN-NEW-FORM-INSTANCE触发器对象Tirgger Object/条件Condition/处理模式Processing ModeNot in Enter-Query Mode上下文层/值Contest Level/ValueResponsibility/***职责活动Actions序号seq特性T... 阅读全文

posted @ 2013-07-09 12:55 st.sun 阅读(172) 评论(0) 推荐(0)

物料序号不可输入

摘要：应用Oracle Bill Of Materiel层LevelFunction函数名Funcgtion NameMT_BOMFDBOM表单名Form NameBOMFDBOM说明Description物料序号不可输入条件Condition触发器事件Tirgger EventWHEN-NEW-FORM-INSTANCE触发器对象Tirgger Object/条件Condition/处理模式Processing ModeNot in Enter-Query Mode上下文层/值Contest Level/ValueResponsibility/***职责活动Actions序号seq特性Typ.. 阅读全文

posted @ 2013-07-09 12:54 st.sun 阅读(198) 评论(0) 推荐(0)

禁用物料不允许BOM

摘要：应用Oracle Bill Of Materiel层LevelFunction函数名Funcgtion NameBOM_BOMFDBOM表单名Form NameBOMFDBOM说明Description禁用物料不允许BOM条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectB_INV_COMPS条件Condition'Inactive' = (select nvl(Inventory_Item_Status_Code,'A')from inv.mtl_system_items_b 阅读全文

posted @ 2013-07-09 12:52 st.sun 阅读(364) 评论(0) 推荐(0)

MRP工作台任务下达之x组织屏蔽全部发放功能

摘要：应用Oracle Manufacturing Planning层LevelFunction函数名Funcgtion NameMRPFPPWB-390表单名Form NameMRPSCPWB说明DescriptionMRP工作台任务下达之x组织屏蔽全部发放功能条件Condition触发器事件Tirgger EventWHEN-NEW-RECORD-INSTANCE触发器对象Tirgger ObjectMRP_ORDERS条件Condition/处理模式Processing ModeNot in Enter-Query Mode上下文层/值Contest Level/ValueUser/ ... 阅读全文

posted @ 2013-07-09 12:51 st.sun 阅读(265) 评论(0) 推荐(1)

MRP工作台任务下达之计划组为必输

摘要：应用Oracle Manufacturing Planning层LevelFunction函数名Funcgtion NameMRPFPPWB表单名Form NameMRPSCPWB说明DescriptionMRP工作台任务下达之计划组必输条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectMRP_ORDERS条件Condition:MRP_ORDERS.IMPLEMENT_AS_TEXT = '离散任务'处理模式Processing ModeNot in Enter-Query Mode上下文阅读全文

posted @ 2013-07-09 12:50 st.sun 阅读(182) 评论(0) 推荐(0)

按计划员自动带出对应任务类型

摘要：应用Oracle Manufacturing Planning层LevelFunction函数名Funcgtion NameMRPFPPWB-390表单名Form NameMRPSCPWB说明Description按A计划员自动带出’ A标准 ’任务类型条件Condition触发器事件Tirgger EventWHEN-NEW-RECORD-INSTANCE触发器对象Tirgger ObjectMRP_ORDERS条件Condition:MRP_ORDERS.PLANNER_CODE = 'A计划员'处理模式Processing ModeNot in Enter-Query M 阅读全文

posted @ 2013-07-09 12:47 st.sun 阅读(182) 评论(0) 推荐(0)

导航