st.sun - 博客园

未退完料的车间任务禁制“取消”操作

摘要：应用Oracle Work in Progress层LevelFunction函数名Funcgtion NameWIP_WIPDJMDF_DEFINE表单名Form NameWIPDJMDF说明Description未退完料的车间任务禁止“取消”操作条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectW_JOBS条件Condition:w_jobs.status_type = 7and (select count(*) from WIP_REQUIREMENT_OPERATIONS_Vwhere wip_e.. 阅读全文

posted @ 2013-07-10 12:11 st.sun 阅读(195) 评论(0) 推荐(0)

不允许修改安全库存

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

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

帐套零成本控制

摘要：应用Oracle Inventory层LevelFunction函数名Funcgtion NameINV_INVTTMTX_MISC表单名Form NameINVTTMTX说明Description帐套零成本控制条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectMTL_TRX_LINE条件Condition(select count(*)from bom.cst_item_costs cic ,inv.mtl_system_items_b msiwhere cic.cost_type_id =1 and nv 阅读全文

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

接收时物料必须为Active状态

摘要：应用Oracle Inventory层LevelFunction函数名Funcgtion NameRCV_RCVRCERC表单名Form NameRCVRCERC说明Description接收时物料必须为Active状态条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectRCV_TRANSACTION条件Condition(select nvl(INVENTORY_ITEM_STATUS_CODE,'New')from inv.mtl_system_items_bwhere organizati 阅读全文

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

接收检验的质量代码为必输

摘要：应用Oracle Quality层LevelFunction函数名Funcgtion NameMT_RCVTXERT_INSPECT表单名Form NameRCVTXERT说明Description接收检验的质量代码为必输条件Condition触发器事件Tirgger EventWHEN-NEW-RECORD-INSTANCE触发器对象Tirgger ObjectINSPECTION条件Condition/处理模式Processing ModeNot in Enter-Query Mode上下文层/值Contest Level/ValueResponsibility/***职责活动Acti. 阅读全文

posted @ 2013-07-10 12:08 st.sun 阅读(202) 评论(0) 推荐(0)

不允许更改安全库存（仅查询）

摘要：应用Oracle Inventory层LevelFunction函数名Funcgtion NameINV_INVDDFSS表单名Form NameINVDDFSS说明Description不允许更改安全库存（仅查询）条件Condition触发器事件Tirgger EventWHEN-NEW-BLOCK-INSTANCE触发器对象Tirgger ObjectMTL_SAFETY_STOCKS条件Condition/处理模式Processing ModeNot in Enter-Query Mode上下文层/值Contest Level/ValueResponsibility/***职责活动.. 阅读全文

posted @ 2013-07-10 12:08 st.sun 阅读(190) 评论(0) 推荐(0)

接收时必须库存可处理标识为Y

摘要：应用Oracle Inventory层LevelFunction函数名Funcgtion NameRCV_RCVRCERC表单名Form NameRCVRCERC说明Description接收时必须库存标识为Y条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectRCV_TRANSACTION条件Condition(select nvl(STOCK_ENABLED_FLAG,'N')from inv.mtl_system_items_bwhere organization_id = *** （RE 阅读全文

posted @ 2013-07-10 12:08 st.sun 阅读(186) 评论(0) 推荐(0)

不可新增人员

摘要：应用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 阅读(191) 评论(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 阅读(228) 评论(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 阅读(203) 评论(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 阅读(688) 评论(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 阅读(505) 评论(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 阅读(455) 评论(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 阅读(216) 评论(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 阅读(204) 评论(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 阅读(184) 评论(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 阅读(178) 评论(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 阅读(209) 评论(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 阅读(174) 评论(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 阅读(149) 评论(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 阅读(184) 评论(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 阅读(298) 评论(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 阅读(283) 评论(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 阅读(261) 评论(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 阅读(295) 评论(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 阅读(303) 评论(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 阅读(208) 评论(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 阅读(290) 评论(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 阅读(305) 评论(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 阅读(224) 评论(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 阅读(200) 评论(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 阅读(379) 评论(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 阅读(210) 评论(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 阅读(283) 评论(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 阅读(454) 评论(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 阅读(248) 评论(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 阅读(190) 评论(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 阅读(483) 评论(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 阅读(308) 评论(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 阅读(247) 评论(0) 推荐(0)

导航