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 阅读(172) 评论(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 阅读(200) 评论(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 阅读(171) 评论(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 阅读(650) 评论(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 阅读(428) 评论(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 阅读(448) 评论(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 阅读(179) 评论(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 阅读(178) 评论(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 阅读(170) 评论(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 阅读(157) 评论(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 阅读(191) 评论(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 阅读(158) 评论(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 阅读(132) 评论(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 阅读(166) 评论(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 阅读(276) 评论(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 阅读(227) 评论(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 阅读(231) 评论(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 阅读(263) 评论(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 阅读(274) 评论(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 阅读(187) 评论(0) 推荐(0) 编辑

导航