2013 年 7月 9 日随笔档案 - st.sun

不可新增人员

摘要：应用Oracle Inventory层LevelFunction函数名Funcgtion NamePERWSEMP表单名Form NamePERWSEMP说明Description不可新增人员条件Condition触发器事件Tirgger EventWHEN-NEW-RECORD-INSTANCE触发器对象Tirgger ObjectPERSON条件Condition/处理模式Processing ModeNot in Enter-Query Mode上下文层/值Contest Level/ValueResponsibility/***职责活动Actions序号seq特性Type说明Des. 阅读全文

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

已接受的记录不能再作检验

摘要：应用Oracle Quality层LevelFunction函数名Funcgtion NameMT_RCVTXERT_DELIVER表单名Form NameRCVTXERT说明Description已接受的记录不能再作检验条件Condition触发器事件Tirgger EventWHEN-NEW-RECORD-INSTANCE触发器对象Tirgger ObjectRCV_TRANSACTION条件Condition:OVERFLOW_AREA.INSPECTION_STATUS ='已接受 - 要求检验'处理模式Processing ModeNot in Enter-Query 阅读全文

posted @ 2013-07-09 14:08 st.sun 阅读(210) 评论(0) 推荐(0)

隐藏发料权限

摘要：应用Oracle Work in Progress层LevelFunction函数名Funcgtion NameHL_WIP_WIPTXMAT表单名Form NameWIPTXMAT说明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 14:07 st.sun 阅读(187) 评论(0) 推荐(0)

限制子库转移(资产子库与非资产子库)

摘要：应用Oracle Inventory层LevelFunction函数名Funcgtion NameINV_INVTTMTX_SUBINV表单名Form NameINVTTMTX说明Description限制子库转移(资产子库与非资产子库)条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectMTL_TRX_LINE条件Condition(:MTL_TRX_LINE.SUBINVENTORY_CODE not in ('G530供方','G520供方','G540供方' 阅读全文

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

RMA编码为必输

摘要：应用Oracle Inventory层LevelFunction函数名Funcgtion NameRCV_RCVTXERE表单名Form NameRCVTXERE说明DescriptionRMA编码为必输条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectRCV_TRANSACTION条件Condition:RCV_TRANSACTION.TRANSACTION_QUANTITY IS NOT NULLAND :RCV_TRANSACTION.RMA_NUMBER IS NULL处理模式Processing . 阅读全文

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

采购订单接收备注为必输项

摘要：应用Oracle Inventory层LevelFunction函数名Funcgtion NameRCV_RCVRCERC表单名Form NameRCVRCERC说明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 14:05 st.sun 阅读(485) 评论(0) 推荐(0)

提单号提示

摘要：应用Oracle Order Management层LevelFunction函数名Funcgtion NameRCV_RCVRCERC表单名Form NameRCVRCERC说明Description提单号提示条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectHEADER条件Conditionto_number(SUBSTR(:HEADER.BILL_OF_LADING,4,7)) <= to_number(( select MAX(substr(bill_of_lading,4,7)) from p 阅读全文

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

限定只能处理"A仓"和"B仓"入库

摘要：应用Oracle Inventory层LevelFunction函数名Funcgtion NameINV_INVTTMTX_MISC表单名Form NameINVTTMTX说明Description限定只能处理"**仓"和"**仓"入库条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectMTL_TRX_LINE条件Condition:MTL_TRX_LINE.transaction_type_id not in (149,151)（ REMARK 仓库ID）处理模式Pro 阅读全文

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

不能交易的物料不可做接收

摘要：应用Oracle Inventory层LevelFunction函数名Funcgtion NameCUXRCVRCERC表单名Form NameRCVRCERC说明Description不能交易的物料不可做接收条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectRCV_TRANSACTION条件Condition(select count(*) from inv.mtl_system_items_bwhere organization_id = :rcv_transaction.to_organizatio.. 阅读全文

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

限制车间备料方式更改

摘要：应用Oracle Work in Progress层LevelFunction函数名Funcgtion NameCUXDPTSB表单名Form NameCUXDPTSB说明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:55 st.sun 阅读(161) 评论(0) 推荐(0)

成本维护不允许超过设定比例

摘要：应用Oracle Cost Management层LevelFunction函数名Funcgtion NameCST_CSTFITCT表单名Form NameCSTFITCT说明Description成本维护不允许超过设定比例条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectITEM_COST_USER条件Condition(ABS((select ITEM_COST from BOM.CST_ITEM_COST_DETAILSWHERE INVENTORY_ITEM_ID = :ITEM_COST_U... 阅读全文

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

车间不可操作非车间仓

摘要：应用Oracle Inventory层LevelFunction函数名Funcgtion NameINV_INVTTMTX_MISC表单名Form NameINVTTMTX说明Description车间不可操作非车间仓条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectMTL_TRX_LINE条件Condition:MTL_TRX_LINE.SUBINVENTORY_CODE not like 'B%' OR :MTL_TRX_LINE.SUBINVENTORY_CODE not like &# 阅读全文

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

手工成本维护不可以将成本改为零

摘要：应用Oracle Cost Management层LevelFunction函数名Funcgtion NameCST_CSTFITCT表单名Form NameCSTFITCT说明Description手工成本维护不可以将成本改为零条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectITEM_COST_USER条件Condition:ITEM_COST_USER.USAGE_RATE_OR_AMOUNT =0处理模式Processing ModeNot in Enter-Query Mode上下文层/值C... 阅读全文

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

手工成本维护超过1500元提醒

摘要：应用Oracle Cost Management层LevelFunction函数名Funcgtion NameCST_CSTFITCT表单名Form NameCSTFITCT说明Description手工成本维护超过1500元提醒条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectITEM_COST_USER条件Condition:ITEM_COST_USER.USAGE_RATE_OR_AMOUNT>1500处理模式Processing ModeNot in Enter-Query Mode上下文层/ 阅读全文

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

成本查询

摘要：应用Oracle Cost Management层LevelFunction函数名Funcgtion NameCST_CSTFITCT表单名Form NameCSTFITCT说明Description成本查询条件Condition触发器事件Tirgger EventWHEN-NEW-FORM-INSTANCE触发器对象Tirgger Object/条件Condition/处理模式Processing ModeNot in Enter-Query Mode上下文层/值Contest Level/ValueResponsibility/***职责活动Actions序号seq特性Type说明D.. 阅读全文

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

同一供应商只能有一个有效的报价单

摘要：应用Oracle Purchasing层LevelFunction函数名Funcgtion NamePO_POXSCERQ_Q表单名Form NamePOXSCERQ说明Description同一供应商只能有一个有效的报价单条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectPO_HEADERS条件Condition(SELECT COUNT(*) FROM po.po_headers_allwhere vendor_site_id = :po_headers.VENDOR_SITE_IDand STA... 阅读全文

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

新增报价单状态为有效状态

摘要：应用Oracle Purchasing层LevelFunction函数名Funcgtion NamePO_POXSCERQ_Q表单名Form NamePOXSCERQ说明Description新增报价单状态为有效状态条件Condition触发器事件Tirgger EventWHEN-NEW-RECORD-INSTANCE触发器对象Tirgger ObjectPO_HEADERS条件Condition1=1处理模式Processing ModeNot in Enter-Query Mode上下文层/值Contest Level/ValueResponsibility/***职责活动Acti.. 阅读全文

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

同一供应商同一物料存在有效报价时不能再新增报价

摘要：应用Oracle Purchasing层LevelFunction函数名Funcgtion NamePO_POXSCERQ_Q表单名Form NamePOXSCERQ说明Description同一供应商同一物料存在有效报价时不能再新增报价条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectPO_LINES条件Condition1 (select nvl(max(po_line_id),1)from po_headers_all pha ,po_lines_all pla where pha.po_head... 阅读全文

posted @ 2013-07-09 13:28 st.sun 阅读(272) 评论(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说明D.. 阅读全文

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

默认值更改

摘要：应用Oracle Inventory层LevelFunction函数名Funcgtion NameINV_INVSDODS表单名Form NameINVSDODS说明Description默认值更改条件Condition触发器事件Tirgger EventWHEN-NEW-RECORD-INSTANCE触发器对象Tirgger ObjectITEM_SUB_DEFAULTS条件Condition/处理模式Processing ModeNot in Enter-Query Mode上下文层/值Contest Level/ValueResponsibility/***职责活动Actions序号. 阅读全文

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

不显示BOM清单的版本

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

posted @ 2013-07-09 13:25 st.sun 阅读(276) 评论(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:B_BILL_OF_MATLS.ITEM NOT LIKE '56HS%'and :B_BILL_OF_MATLS.ITEM NOT LIKE '5% 阅读全文

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

子库必输

摘要：应用Oracle Bill Of Materiel层LevelFunction函数名Funcgtion NameBOM_BOMFDRTG表单名Form NameBOMFDRTG说明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:23 st.sun 阅读(206) 评论(0) 推荐(0)

提醒录入BOM更改原因

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

posted @ 2013-07-09 13:22 st.sun 阅读(181) 评论(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:21 st.sun 阅读(362) 评论(0) 推荐(0)

A类型物料必须为装配拉式,供应子库为B仓

摘要：应用Oracle Bill Of Materiel层LevelFunction函数名Funcgtion NameMT_BOMFDBOM表单名Form NameBOMFDBOM说明DescriptionA类型物料必须为装配拉式,供应子库为A仓条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectB_INV_COMPS条件ConditionSUBSTR(:B_INV_COMPS.COMPONENT_ITEM,1,2) = '5h'and ( :B_INV_COMPS.SUPPLY_TYPE ' 阅读全文

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

供应类型与供应子库必输

摘要：应用Oracle Bill Of Materiel层LevelFunction函数名Funcgtion NameBOM_BOMFDBOM表单名Form NameBOMFDBOM说明Description供应类型与供应子库必输条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectB_INV_COMPS条件Condition:B_INV_COMPS.ITEM_TYPE '虚拟件物料'AND :B_INV_COMPS.CREATED_BY IS NULL处理模式Processing ModeNot in 阅读全文

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

物料编码定义必须12位

摘要：应用Oracle Inventory层LevelFunction函数名Funcgtion NameINV_INVIDITM表单名Form NameINVIDITM说明Description物料编码定义必须12位条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectMTL_SYSTEM_ITEMS条件Condition(SELECT LENGTH(:MTL_SYSTEM_ITEMS.INVENTORY_ITEM_MIR)FROM DUAL) 12AND :MTL_SYSTEM_ITEMS.CREATED_BY .. 阅读全文

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

不能修改数据

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

posted @ 2013-07-09 13:16 st.sun 阅读(240) 评论(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:13 st.sun 阅读(172) 评论(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:11 st.sun 阅读(462) 评论(0) 推荐(0)

供应类型与计划分类一致性检查(PO)

摘要：应用Oracle Purchasing层LevelFunction函数名Funcgtion NameCUXPOIMM表单名Form NameCUXPOIMM说明Description供应类型与计划分类一致性检查(PO)条件Condition触发器事件Tirgger EventWHEN-NEW-ITEM-INSTANCE触发器对象Tirgger ObjectPOIMM.MPP_CATEGORY_SEGS条件Condition${item.poimm.mpl_category_segs.value} is not nulland ${item.poimm.wip_supply_type_me... 阅读全文

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

供应类型与计划分类一致性检查(INV)

摘要：应用Oracle Inventory层LevelFunction函数名Funcgtion NameCUXINVIMM表单名Form NameCUXINVIMM说明Description供应类型与计划分类一致性检查(INV)条件Condition触发器事件Tirgger EventWHEN-NEW-ITEM-INSTANCE触发器对象Tirgger ObjectPOIMM.WIP_SUPPLY_SUBINVENTORY条件Condition${item.poimm.mpl_category_segs.value} is not nulland ${item.poimm.wip_supply_.. 阅读全文

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

拉式工序不允许挂财务仓

摘要：应用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 阅读(205) 评论(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)

导航