st.sun - 博客园

只显示标准采购订单

摘要：应用Oracle Purchasing层LevelFunction函数名Funcgtion NamePO_POXPOVPO表单名Form NamePOXPOVPO说明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-10 13:06 st.sun 阅读(210) 评论(0) 推荐(0)

不允许下达到无供应商门户的送货通知

摘要：应用Oracle Purchasing层LevelFunction函数名Funcgtion NameCUXFDNTF表单名Form NameCUXFDNTF说明Description不允许下达到无供应商门户的送货通知条件Condition触发器事件Tirgger EventWHEN-NEW-RECORD-INSTANCE触发器对象Tirgger ObjectNOTIFY条件Condition:NOTIFY.VENDOR_CODE not IN (SELECT USER_NAME FROM APPS.FND_USER WHERE NVL(END_DATE,SYSDATE+1)>SYSDAT 阅读全文

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

供应商必须输入

摘要：应用Oracle Purchasing层LevelFunction函数名Funcgtion NameMT_POXBWVRP表单名Form NameMT_POXBWVRP说明Description供应商必须输入条件Condition触发器事件Tirgger EventWHEN-NEW-RECORD-INSTANCE触发器对象Tirgger ObjectPO_HEADERS条件Condition(:PO_HEADERS.doc_type_name = '标准采购订单'or :po_headers.doc_type_name ='一揽子采购协议')处理模式Proces 阅读全文

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

采购订单单价屏蔽

摘要：应用Oracle Purchasing层LevelFunction函数名Funcgtion NameCUXPOXPOEPO表单名Form NamePOXPOEPO说明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:28 st.sun 阅读(315) 评论(0) 推荐(0)

无效的报价单不能维护项目价格信息

摘要：应用Oracle Purchasing层LevelFunction函数名Funcgtion NamePO_POXSCERQ_Q表单名Form NamePOXSCERQ说明Description无效的报价单不能维护项目价格信息条件Condition触发器事件Tirgger EventWHEN-NEW-RECORD-INSTANCE触发器对象Tirgger ObjectPO_LINES条件Condition:PO_HEADERS.STATUS_MIR '有效'OR NVL(:PO_HEADERS.END_DATE_MIR,SYSDATE+1) < SYSDATE处理模式Pro 阅读全文

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

登记的订单不能修改价格

摘要：应用Oracle Order Management层LevelFunction函数名Funcgtion NameONT_OEXOEORD表单名Form NameOEXOEORD说明Description登记的订单不能修改价格条件Condition触发器事件Tirgger EventWHEN-NEW-RECORD-INSTANCE触发器对象Tirgger ObjectORDER条件Condition:ORDER.STATUS = '已登记'处理模式Processing ModeNot in Enter-Query Mode上下文层/值Contest Level/ValueRes 阅读全文

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

限制取消采购订单

摘要：应用Oracle Purchasing层LevelFunction函数名Funcgtion NameCUXPOXPOEPO表单名Form NamePOXPOEPO说明Description限制取消采购订单条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectPO_DOCON_CONTROL条件Condition:PO_DOCON_CONTROL.ACTION='CANCEL PO LINE'OR:PO_DOCON_CONTROL.ACTION='CANCEL PO'处理模式Proc 阅读全文

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

采购订单保存不能修改供应商

摘要：应用Oracle Purchasing层LevelFunction函数名Funcgtion NameMT_POXPOEPO表单名Form NamePOXPOEPO说明Description采购订单保存不能修改供应商条件Condition触发器事件Tirgger EventWHEN-NEW-RECORD-INSTANCE触发器对象Tirgger ObjectPO_HEADERS条件Condition:PO_HEADERS.SEGMENT1 IS NOT NULLAND (:PO_HEADERS.DOC_TYPE_NAME = '标准采购订单'or :po_headers.doc_ 阅读全文

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

有效日期不能重叠

摘要：应用Oracle Purchasing层LevelFunction函数名Funcgtion NameMT_POXPOEPO表单名Form NamePOXPOEPO说明Description有效日期不能重叠条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectPO_SHIPMENTS条件Condition((select count(*)from PO_LINE_LOCATIONS_allwhere po_header_id = :PO_SHIPMENTS.PO_HEADER_ID and po_line_id.. 阅读全文

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

一个供应商只允许一个报价单

摘要：应用Oracle Purchasing层LevelFunction函数名Funcgtion NamePO_POXPOEPO表单名Form NamePOXPOEPO说明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 vendor_id.. 阅读全文

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

限制转交订单－采购直接批准PO

摘要：应用Oracle Purchasing层LevelFunction函数名Funcgtion NameCUXPOXPOEPO表单名Form NamePOXPOEPO说明Description限制转交订单－采购直接批准PO条件Condition触发器事件Tirgger EventWHEN-NEW-FORM-INSTANCE触发器对象Tirgger Object/条件Condition/处理模式Processing ModeNot in Enter-Query Mode上下文层/值Contest Level/ValueResponsibility/***职责活动Actions序号seq特性T... 阅读全文

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

限制更改采购订单的供应商地点

摘要：应用Oracle Purchasing层LevelFunction函数名Funcgtion NameCUXPOXPOEPO表单名Form NamePOXPOEPO说明Description限制更改采购订单的供应商地点条件Condition触发器事件Tirgger EventWHEN-NEW-RECORD-INSTANCE触发器对象Tirgger ObjectPO_HEADERS条件Condition/处理模式Processing ModeNot in Enter-Query Mode上下文层/值Contest Level/ValueResponsibility/***职责活动Action.. 阅读全文

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

限制采购订单行数量的小数位

摘要：应用Oracle Purchasing层LevelFunction函数名Funcgtion NameCUXPOXPOEPO表单名Form NamePOXPOEPO说明Description限制采购订单行数量的小数位条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectPO_LINES条件ConditionTRUNC(:PO_LINES.QUANTITY,5):PO_LINES.QUANTITY处理模式Processing ModeNot in Enter-Query Mode上下文层/值Contest Le.. 阅读全文

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

加工费采购订单批准后禁止更改订单数量

摘要：应用Oracle Purchasing层LevelFunction函数名Funcgtion NamePO_POXPOEPO表单名Form NamePOXPOEPO说明Description加工费工采购订单批准后禁止更改订单数量条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectPO_LINES条件ConditionSUBSTR(:PO_LINES.ITEM_NUMBER,1,2) = '5h'AND :PO_HEADERS.STATUS in ('批准','要求重新审批& 阅读全文

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

限制ITEM读取其它物料的物料描述

摘要：应用Oracle Purchasing层LevelFunction函数名Funcgtion NameCUXPOXPOEPO表单名Form NamePOXPOEPO说明Description限制物料读取其它物料的物料描述条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectPO_LINES条件Conditionexists (select 1 from mtl_system_items_tl awhere a.inventory_item_id=:PO_LINES.ITEM_IDand a.language... 阅读全文

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

采购订单限制订单“行号”过大的控制

摘要：应用Oracle Purchasing层LevelFunction函数名Funcgtion NameCUXPOXPOEPO表单名Form NamePOXPOEPO说明Description采购订单限制订单“行号”过大的控制条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectPO_LINES条件Condition:PO_LINES.LINE_NUM >200处理模式Processing ModeNot in Enter-Query Mode上下文层/值Contest Level/ValueRespons. 阅读全文

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

限制行表新增记录

摘要：应用Oracle Purchasing层LevelFunction函数名Funcgtion NameCUXPOXSCASL表单名Form NameCUXPOXSCASL说明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-10 12:24 st.sun 阅读(159) 评论(0) 推荐(0)

采购订单行需求时间必输

摘要：应用Oracle Purchasing层LevelFunction函数名Funcgtion NameMT_POXPOEPO表单名Form NamePOXPOEPO说明Description采购订单行需求时间必输条件Condition触发器事件Tirgger EventWHEN-NEW-RECORD-INSTANCE触发器对象Tirgger ObjectPO_LINES条件Condition/处理模式Processing ModeNot in Enter-Query Mode上下文层/值Contest Level/ValueResponsibility/***职责活动Actions序号se.. 阅读全文

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

报价单内，同一物料只允许一条行价格记录

摘要：应用Oracle Purchasing层LevelFunction函数名Funcgtion NameMT_POXPOEPO表单名Form NamePOXPOEPO说明Description报价单内，同一物料只允许一条行价格记录条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectPO_LINES条件Condition((SELECT COUNT(*) FROM PO_LINES_ALLWHERE PO_HEADER_ID = :PO_HEADERS.PO_HEADER_ID AND ITEM_ID = :P... 阅读全文

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

限制头表新增记录

摘要：应用Oracle Purchasing层LevelFunction函数名Funcgtion NameCUXPOXSCASL表单名Form NameCUXPOXSCASL说明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-10 12:23 st.sun 阅读(187) 评论(0) 推荐(0)

采购订单单价异常控制

摘要：应用Oracle Purchasing层LevelFunction函数名Funcgtion NameCUXPOXPOEPO表单名Form NamePOXPOEPO说明Description采购订单单价异常控制条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectPO_LINES条件Condition:PO_LINES.UNIT_PRICE=0OR :PO_LINES.UNIT_PRICE > 2500处理模式Processing ModeNot in Enter-Query Mode上下文层/值Conte 阅读全文

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

限制采购订单取消(行取消)功能

摘要：应用Oracle Purchasing层LevelFunction函数名Funcgtion NameCUXPOXPOVPO表单名Form NamePOXPOVPO说明Description限制采购订单取消(行取消)功能条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectPO_DOCON_CONTROL条件Condition:PO_DOCON_CONTROL.ACTION='CANCEL PO LINE'OR:PO_DOCON_CONTROL.ACTION='CANCEL PO'处阅读全文

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

下达订单时，付款条件不可手工录入

摘要：应用Oracle Order Management层LevelFunction函数名Funcgtion NameONT_OEXOEORD/ ONT_OEXOEORD_SUMMARY表单名Form NameOEXOEORD说明Description下达订单时，付款条件不可手工录入条件Condition触发器事件Tirgger EventWHEN-NEW-RECORD-INSTANCE触发器对象Tirgger ObjectORDER条件Condition/处理模式Processing ModeNot in Enter-Query Mode上下文层/值Contest Level/ValueR... 阅读全文

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

采购订单行号不能大于6位数字

摘要：应用Oracle Purchasing层LevelFunction函数名Funcgtion NamePO_POXPOEPO表单名Form NamePOXPOEPO说明Description采购订单行号不能大于6位数字条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectPO_LINES条件Conditionlength(to_char(${item.po_lines.line_num_mir.value})) >= 6处理模式Processing ModeNot in Enter-Query Mode上下文阅读全文

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

采购订单单价金额屏蔽

摘要：应用Oracle Purchasing层LevelFunction函数名Funcgtion NameCUXPOXPOVPO表单名Form NamePOXPOVPO说明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-10 12:15 st.sun 阅读(609) 评论(0) 推荐(0)

外销订单发票编码必输

摘要：应用Oracle Order Management层LevelFunction函数名Funcgtion NameWSHFSTRX表单名Form NameWSHFSTRX说明Description外销订单发票编码必输条件Condition触发器事件Tirgger EventWHEN-NEW-RECORD-INSTANCE触发器对象Tirgger ObjectDLVY条件Condition:DLVB.source_header_type_name like '%外销%'AND :DLVB.DELIVERY_NAME IS NOT NULLAND :DLVB.SUBINVENTORY 阅读全文

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

挑库来源必输

摘要：应用Oracle Order Management层LevelFunction函数名Funcgtion NameWSH_WSHFRREL表单名Form NameWSHFRREL说明Description挑库来源必输条件Condition触发器事件Tirgger EventWHEN-NEW-RECORD-INSTANCE触发器对象Tirgger ObjectRELEASE条件Condition/处理模式Processing ModeNot in Enter-Query Mode上下文层/值Contest Level/ValueResponsibility/***职责活动Actions序号... 阅读全文

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

销售订单的付款条件必输

摘要：应用Oracle Order Management层LevelFunction函数名Funcgtion NameONT_OEXOEORD表单名Form NameOEXOEORD说明Description销售订单的付款条件必输条件Condition触发器事件Tirgger EventWHEN-NEW-FORM-INSTANCE触发器对象Tirgger Object/条件Condition/处理模式Processing ModeNot in Enter-Query Mode上下文层/值Contest Level/ValueResponsibility/***职责活动Actions序号seq... 阅读全文

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

销售订单查询

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

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

价目表必输

摘要：应用Oracle Order Management层LevelFunction函数名Funcgtion NameONT_OEXOEORD表单名Form NameOEXOEORD说明Description价目表必输条件Condition触发器事件Tirgger EventWHEN-NEW-RECORD-INSTANCE触发器对象Tirgger ObjectORDER条件Condition/处理模式Processing ModeNot in Enter-Query Mode上下文层/值Contest Level/ValueResponsibility/***职责活动Actions序号seq... 阅读全文

posted @ 2013-07-10 12:13 st.sun 阅读(167) 评论(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-10 12:13 st.sun 阅读(226) 评论(0) 推荐(0)

来源为必输

摘要：应用Oracle Inventory层LevelFunction函数名Funcgtion NameINV_INVTTMTX_SUBINV表单名Form NameINVTTMTX说明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-10 12:13 st.sun 阅读(169) 评论(0) 推荐(0)

限制退货备注栏必填

摘要：应用Oracle Inventory层LevelFunction函数名Funcgtion NameCUXRCVTXERE表单名Form NameRCVTXERE说明Description限制退货备注栏必填条件Condition触发器事件Tirgger EventWHEN-NEW-RECORD-INSTANCE触发器对象Tirgger ObjectRCV_TRANSACTION条件Condition/处理模式Processing ModeNot in Enter-Query Mode上下文层/值Contest Level/ValueResponsibility/***职责活动Actions序. 阅读全文

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

手工下达申请理由必输

摘要：应用Oracle Manufacturing Planning层LevelFunction函数名Funcgtion NamePO_POXRQERQ表单名Form NamePOXRQERQ说明Description手工下达申请理由必输条件Condition触发器事件Tirgger EventWHEN-NEW-FORM-INSTANCE触发器对象Tirgger Object/条件Condition/处理模式Processing ModeNot in Enter-Query Mode上下文层/值Contest Level/ValueResponsibility/***职责活动Actions序... 阅读全文

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

计划任务开始时间限制更改

摘要：应用Oracle Work in Progress层LevelFunction函数名Funcgtion NameCUXWIPDJMDF表单名Form NameCUXWIPDJMDF说明Description计划任务开始时间限制更改条件Condition触发器事件Tirgger EventWHEN-NEW-ITEM-INSTANCE触发器对象Tirgger ObjectW_JOBS.SCHEDULED_START_DATE条件ConditionNVL(:W_JOBS.STATUS_TYPE,1) != 1处理模式Processing ModeNot in Enter-Query Mode上... 阅读全文

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

计划工作台屏蔽“全部发放”

摘要：应用Oracle Manufacturing Planning层LevelFunction函数名Funcgtion NameMRPFPPWB表单名Form NameMRPSCPWB说明Description计划工作台屏蔽“全部发放”条件Condition触发器事件Tirgger EventWHEN-NEW-RECORD-INSTANCE触发器对象Tirgger ObjectMRP_ORDERS条件Condition/处理模式Processing ModeNot in Enter-Query Mode上下文层/值Contest Level/ValueResponsibility/***职... 阅读全文

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

隐藏计划能力

摘要：应用Oracle Manufacturing Planning层LevelFunction函数名Funcgtion NameMRPFPPMR表单名Form NameMRPFPPMR说明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-10 12:12 st.sun 阅读(229) 评论(0) 推荐(0)

限制只能够打印超领单

摘要：应用Oracle Inventory层LevelFunction函数名Funcgtion NameCUXWIPGR_JZ表单名Form NameCUXWIPGR_JZ说明Description限制只能够打印超领单条件Condition触发器事件Tirgger EventWHEN-NEW-RECORD-INSTANCE触发器对象Tirgger ObjectQUERY_FIND条件Condition/处理模式Processing ModeNot in Enter-Query Mode上下文层/值Contest Level/ValueResponsibility/***职责活动Actions序号. 阅读全文

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

主计划MPS禁止改写项目编号（PROJECT）

摘要：应用Oracle Manufacturing Planning层LevelFunction函数名Funcgtion NameMRPFSDMS-253表单名Form NameMRPFSDMS说明Description主计划MPS禁止改写项目编号（PROJECT）条件Condition触发器事件Tirgger EventWHEN-NEW-FORM-INSTANCE触发器对象Tirgger Object/条件Condition/处理模式Processing ModeNot in Enter-Query Mode上下文层/值Contest Level/ValueResponsibility/*... 阅读全文

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

实地盘点不可选择全部的仓库

摘要：应用Oracle Inventory层LevelFunction函数名Funcgtion NameINV_INVADPPI表单名Form NameINVADPPI说明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-10 12:11 st.sun 阅读(196) 评论(0) 推荐(0)

导航