st.sun - 博客园

只允许更改任务状态，其他项不允许更改

摘要：应用Oracle Work in Progress层LevelFunction函数名Funcgtion NameWIP_WIPDJMDF_DEFINE表单名Form NameWIPDJMDF说明Description只允许更改任务状态，其他项不允许更改条件Condition触发器事件Tirgger EventWHEN-NEW-RECORD-INSTANCE触发器对象Tirgger ObjectW_JOBS条件Condition/处理模式Processing ModeNot in Enter-Query Mode上下文层/值Contest Level/ValueResponsibilit... 阅读全文

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

不允许修改标准作业需求

摘要：应用Oracle Work in Progress层LevelFunction函数名Funcgtion NameWIP_WIPMRMDF表单名Form NameWIPMRMDF说明Description不允许修改标准作业需求条件Condition触发器事件Tirgger EventWHEN-NEW-RECORD-INSTANCE触发器对象Tirgger ObjectW_REQUIREMENTS条件Condition:WIPMRMDF_ENTITY.WIP_ENTITY_ID IN (SELECT WIP_ENTITY_ID FROM WIP_DISCRETE_JOBS WHERE JOB_.. 阅读全文

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

已有发料的工单不能变更为取消状态

摘要：应用Oracle Work in Progress层LevelFunction函数名Funcgtion NameWIP_WIPDJMDF_DEFINE表单名Form NameWIPDJMDF说明Description已有发料的工单不能变更为取消状态条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectW_JOBS条件Condition${item.w_jobs.status_type.value} = 7and cux_rd_Personalization_pkg.cux_get_issued_quanti... 阅读全文

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

虚拟件零成本控制

摘要：应用Oracle Inventory层LevelFunction函数名Funcgtion NameINV_INVTTMTX_MISC/ INV_INVTTMTX_SUBINV表单名Form NameINVTTMTX说明Description虚拟件零成本控制条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectMTL_TRX_LINE条件Condition(SELECT ITEM_TYPE FROM INV.MTL_SYSTEM_ITEMS_BWHERE SEGMENT1 = :MTL_TRX_LINE.ITE.. 阅读全文

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

不允许计划员修改任务的完成、完工不计费状态

摘要：应用Oracle Work in Progress层LevelFunction函数名Funcgtion NameCUXWIPDJMDF表单名Form NameCUXWIPDJMDF说明Description不允许计划员修改任务的完成、完工不计费状态条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectW_JOBS条件Condition(:W_JOBS.STATUS_TYPE_DISP IN ('完成','完成 - 不计费') or :W_JOBS.M_STATUS_TYPE_DIS 阅读全文

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

完工原因栏必输

摘要：应用Oracle Work in Progress层LevelFunction函数名Funcgtion NameWIP_WIPTXSFM表单名Form NameWIPTXSFM说明Description完工原因栏必输条件Condition触发器事件Tirgger EventWHEN-NEW-FORM-INSTANCE触发器对象Tirgger Object/条件Condition/处理模式Processing ModeNot in Enter-Query Mode上下文层/值Contest Level/ValueResponsibility/***职责活动Actions序号seq特性Ty... 阅读全文

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

成本监控只能修改完成或完工不计费状态作业

摘要：应用Oracle Work in Progress层LevelFunction函数名Funcgtion NameWIP_WIPDJMDF_DEFINE表单名Form NameWIPDJMDF说明Description成本监控只能修改完成或完工不计费状态作业条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectW_JOBS条件Condition(:W_JOBS.M_STATUS_TYPE_DISP not in ('完成','完成 - 不计费') or :W_JOBS.STATUS_ 阅读全文

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

完工子库必输

摘要：应用Oracle Work in Progress层LevelFunction函数名Funcgtion NameWIP_WIPDJMDF_DEFINE表单名Form NameWIPDJMDF说明Description完工子库必输条件Condition触发器事件Tirgger EventWHEN-NEW-FORM-INSTANCE触发器对象Tirgger Object/条件Condition/处理模式Processing ModeNot in Enter-Query Mode上下文层/值Contest Level/ValueResponsibility/***职责活动Actions序号s... 阅读全文

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

移动禁止修改事务处理时间

摘要：应用Oracle Work in Progress层LevelFunction函数名Funcgtion NameWIP_WIPTXSFM表单名Form NameWIPTXSFM说明Description移动禁止修改事务处理时间条件Condition触发器事件Tirgger EventWHEN-NEW-FORM-INSTANCE触发器对象Tirgger Object/条件Condition/处理模式Processing ModeNot in Enter-Query Mode上下文层/值Contest Level/ValueResponsibility/***职责活动Actions序号se... 阅读全文

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

车间任务不可更改开始时间/完成时间

摘要：应用Oracle Work in Progress层LevelFunction函数名Funcgtion NameWIP_WIPDJMDF_DEFINE表单名Form NameWIPDJMDF说明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 ... 阅读全文

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

查跟单件时错误排除

摘要：应用Oracle Work in Progress层LevelFunction函数名Funcgtion NameCUXWIPDJMDF_QUERY表单名Form NameCUXWIPDJMDF说明Description查跟单件时错误排除条件Condition触发器事件Tirgger EventWHEN-NEW-FORM-INSTANCE触发器对象Tirgger Object/条件Condition/处理模式Processing ModeNot in Enter-Query Mode上下文层/值Contest Level/ValueResponsibility/***职责活动Actions.. 阅读全文

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

发料不允许更改发料日期

摘要：应用Oracle Work in Progress层LevelFunction函数名Funcgtion NameWIP_WIPTXMAT表单名Form NameWIPTXMAT说明Description发料不允许更改发料日期条件Condition触发器事件Tirgger EventWHEN-NEW-FORM-INSTANCE触发器对象Tirgger Object/条件Condition/处理模式Processing ModeBoth上下文层/值Contest Level/ValueResponsibility/***职责活动Actions序号seq特性Type说明Description语.. 阅读全文

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

禁止更改事务处理时间

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

限制*开头的订单不允许退货

摘要：应用Oracle Inventory层LevelFunction函数名Funcgtion NameRCV_RCVTXERE表单名Form NameRCVTXERE说明Description限制*开头的订单不允许退货条件Condition触发器事件Tirgger EventWHEN-NEW-FORM-INSTANCE触发器对象Tirgger Object/条件Condition:PO_STARTUP_VALUES.ORG_ID= ***（当前ID）处理模式Processing ModeNot in Enter-Query Mode上下文层/值Contest Level/ValueResp... 阅读全文

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

不许增加和修改供应商名称和编码

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

车间不允许操作财务仓

摘要：应用Oracle Work in Progress层LevelFunction函数名Funcgtion NameWIP_WIPTXMAT表单名Form NameWIPTXMAT说明Description车间不允许操作财务仓条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectMTL_TRX_LINE条件Condition(fnd_profile.value('USER_ID') = (select nvl(max(user_id),0)from FND_USER twhere t.user_id 阅读全文

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

车间任务不允许"每个装配件"超过100000

摘要：应用Oracle Work in Progress层LevelFunction函数名Funcgtion NameWIP_WIPMRMDF表单名Form NameWIPMRMDF说明Description车间任务不允许"每个装配件"超过100000条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectW_REQUIREMENTS条件Condition:W_REQUIREMENTS.QUANTITY_PER_ASSEMBLY>100000 OR :W_REQUIREMENTS.REQUIRE 阅读全文

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

参考栏位必输

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

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

有效日期必输

摘要：应用Oracle Purchasing层LevelFunction函数名Funcgtion NamePO_POXPOEPO表单名Form NamePOXPOEPO说明Description有效日期必输条件Condition触发器事件Tirgger EventWHEN-NEW-RECORD-INSTANCE触发器对象Tirgger ObjectPO_SHIPMENTS条件Condition1=1处理模式Processing ModeNot in Enter-Query Mode上下文层/值Contest Level/ValueResponsibility/***职责活动Actions序号S.. 阅读全文

posted @ 2013-07-10 13:11 st.sun 阅读(149) 评论(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说... 阅读全文

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

无一揽子协议不允许下达采购订单

摘要：应用Oracle Purchasing层LevelFunction函数名Funcgtion NamePO_POXPOEPO表单名Form NamePOXPOEPO说明Description无一揽子协议不允许下达采购订单条件Condition触发器事件Tirgger EventWHEN-VALIDA... 阅读全文

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

价格管理员只允许下达一揽子协议

摘要：应用Oracle Purchasing层LevelFunction函数名Funcgtion NamePO_POXPOEPO表单名Form NamePOXPOEPO说明Description价格管理员只允许下达一揽子协议条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectPO_HEADERS条件Condition:PO_HEADERS.DOC_TYPE_NAME '一揽子采购协议'处理模式Processing ModeNot in Enter-Query Mode上下文层/值Contest Le 阅读全文

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

采购员只允许下达标准采购订单

摘要：应用Oracle Purchasing层LevelFunction函数名Funcgtion NamePO_POXPOEPO表单名Form NamePOXPOEPO说明Description采购员只允许下达标准采购订单条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectPO_HEADERS条件Condition:PO_HEADERS.DOC_TYPE_NAME '标准采购订单'处理模式Processing ModeNot in Enter-Query Mode上下文层/值Contest Leve 阅读全文

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

禁止手工创建采购订单

摘要：应用Oracle Purchasing层LevelFunction函数名Funcgtion NamePO_POXPOEPO表单名Form NamePOXPOEPO说明Description禁止手工创建采购订单条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectPO_HEADERS条件Condition/处理模式Processing ModeBoth上下文层/值Contest Level/ValueResponsibility/***职责活动Actions序号seq特性Type说明Description语言.. 阅读全文

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

已结采购订单不显示

摘要：应用Oracle Purchasing层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-10 13:10 st.sun 阅读(200) 评论(0) 推荐(0)

子库存安全性控制

摘要：应用Oracle Inventory层LevelFunction函数名Funcgtion NameCUXRCVTXERTI表单名Form NameRCVTXERT说明Description子库存安全性控制条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectRCV_TRANSACTION条件Condition:SYSTEM.Record_Status IN ('INSERT','CHANGED') AND:RCV_TRANSACTION.DESTINATION_TYPE_CODE 阅读全文

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

退货备注栏必输

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

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

退货行RMA编号改为必输选项

摘要：应用Oracle Inventory层LevelFunction函数名Funcgtion NameRCV_RCVTXERE表单名Form NameRCVTXERE说明Description退货行RMA编号改为必输选项条件Condition触发器事件Tirgger EventWHEN-NEW-RECORD-INSTANCE触发器对象Tirgger ObjectRCV_TRANSACTION条件Condition${ps.org_id.value} in (select OPERATING_UNIT org_id FROM apps.ORG_ORGANIZATION_DEFINITIONS wh. 阅读全文

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

不允许新建来源准则集

摘要：应用Oracle Manufacturing Planning层LevelFunction函数名Funcgtion NameMRPFDSRADSA表单名Form NameMRPFDSRA说明Description不允许新建来源准则集条件Condition触发器事件Tirgger EventWHEN-NEW-ITEM-INSTANCE触发器对象Tirgger ObjectASSIGNMENT_SETS.ASSIGNMENT_SET_NAME条件Condition处理模式Processing ModeNot in Enter-Query Mode上下文层/值Contest Level/Va... 阅读全文

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

订单保存不可以更改供应商

摘要：应用Oracle Purchasing层LevelFunction函数名Funcgtion NameCUXPOXPOEPO表单名Form NamePOXPOEPO说明Description订单保存不可以更改供应商条件Condition触发器事件Tirgger EventWHEN-NEW-FORM-INSTANCE触发器对象Tirgger Object/条件Condition:PO_HEADERS.SEGMENT1 IS NOT NULLAND :PO_HEADERS.DOC_TYPE_NAME = '标准采购订单'and :po_headers.doc_type_name =& 阅读全文

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

屏蔽一揽子协议价格

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

检查加工费是否有父件

摘要：应用Oracle Purchasing层LevelFunction函数名Funcgtion NameMT_POXPOEPO表单名Form NamePOXPOEPO说明Description检查加工费是否有父件（外协加工费采购订单下达自动生成任务时的检查）条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectPO_LINES条件Conditionsubstr(:PO_LINES.ITEM_NUMBER,1,2) = '5h'AND (select COUNT(bbom.assembly_item_i 阅读全文

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

检查委外货位

摘要：应用Oracle Purchasing层LevelFunction函数名Funcgtion NameMT_POXPOEPO表单名Form NamePOXPOEPO说明Description检查委外货位条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectPO_LINES条件Conditionsubstr(:PO_LINES.ITEM_NUMBER,1,2) = '5h'AND :PO_HEADERS.STATUS '批准'AND not exists (select 1 from 阅读全文

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

检查装配件属性

摘要：应用Oracle Purchasing层LevelFunction函数名Funcgtion NameMT_POXPOEPO/ PO_POXPOEPO表单名Form NamePOXPOEPO说明Description检查装配件属性条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectPO_LINES条件Conditionsubstr(:PO_LINES.ITEM_NUMBER,1,2) = '5h'and (select nvl(msi1.BUILD_IN_WIP_FLAG,'N') 阅读全文

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

只允许操作外协任务

摘要：应用Oracle Work in Progress层LevelFunction函数名Funcgtion NameWIP_WIPDJMDF_DEFINE表单名Form NameWIPDJMDF说明Description只允许操作外协任务条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectW_JOBS条件Condition:W_JOBS.WIP_ENTITY_NAME NOT LIKE 'WX%'处理模式Processing ModeNot in Enter-Query Mode上下文层/值Con 阅读全文

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

采购订单供应商地点必输

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

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

加宽任务号宽度

摘要：应用Oracle Work in Progress层LevelFunction函数名Funcgtion NameWIP_WIPTXMAT/WIP_WIPMRMDF表单名Form NameWIPTXMAT说明Description加宽任务号宽度条件Condition触发器事件Tirgger EventWHEN-NEW-FORM-INSTANCE触发器对象Tirgger Object/条件Condition/处理模式Processing ModeNot in Enter-Query Mode上下文层/值Contest Level/ValueResponsibility/***职责活动Act... 阅读全文

posted @ 2013-07-10 13:07 st.sun 阅读(157) 评论(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 (SELECT COUNT(BOR.ASSEMBLY_ITEM_ID 阅读全文

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

不能取组织ID

摘要：应用Oracle Purchasing层LevelFunction函数名Funcgtion NamePO_POXBWVRP表单名Form NamePOXBWVRP说明Description不能取组织ID条件Condition触发器事件Tirgger EventWHEN-NEW-FORM-INSTANCE触发器对象Tirgger Object/条件Condition:REQ_LINES.DEST_ORGANIZATION_ID IS NULL处理模式Processing ModeNot in Enter-Query Mode上下文层/值Contest Level/ValueRespon... 阅读全文

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

只显示标准采购订单

摘要：应用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 阅读(204) 评论(0) 推荐(0)

导航