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

限定成本中心

摘要：应用Oracle Cost Management层LevelFunction函数名Funcgtion NameCUXAPXPAWKB表单名Form NameAPXPAWKB说明Description验证只能在系统管理员职责下打开此表单条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectPAY_SUM_FOLDER条件Condition:PAY_SUM_FOLDER.CURRENT_BANK_ACCOUNT_NAME'制造_现金'and :PAY_SUM_FOLDER.CURRENT_BANK_A 阅读全文

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

物料描述不可更新(分配组织后)

摘要：应用Oracle Inventory层LevelFunction函数名Funcgtion NameINV_INVIDITM表单名Form NameINVIDITM说明Description物料描述不可更新(分配组织后)条件Condition触发器事件Tirgger EventWHEN-NEW-RECORD-INSTANCE触发器对象Tirgger ObjectMTL_SYSTEM_ITEMS条件Conditionexists (select 1from mtl_system_items_b msiwhere msi.organization_id:STARTUP_INFO.MASTER_OR. 阅读全文

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

屏蔽查看会计科目

摘要：应用Oracle Inventory层LevelFunction函数名Funcgtion NameINV_INVTVTXN表单名Form NameINVTVTXN说明Description屏蔽查看会计科目条件Condition触发器事件Tirgger EventWHEN-NEW-FORM-INSTANCE触发器对象Tirgger Object/条件Condition/处理模式Processing ModeNot in Enter-Query Mode上下文层/值Contest Level/ValueResponsibility/***职责活动Actions序号seq特性Type说明Des.. 阅读全文

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

验证只能在系统管理员职责下打开此表单

摘要：应用Oracle System层LevelFunction函数名Funcgtion NameFND_FNDSCAUS表单名Form NameFNDSCAUS说明Description验证只能在系统管理员职责下打开此表单条件Condition触发器事件Tirgger EventWHEN-NEW-FORM-INSTANCE触发器对象Tirgger Object/条件Conditionfnd_profile.Value('RESP_ID')20420and fnd_profile.value('USERNAME')'***'（REMARK：操作用户）阅读全文

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

车间任务移动完工时检验倒冲子库

摘要：应用Oracle Work in Progress层LevelFunction函数名Funcgtion NameWIP_WIPTXSFM表单名Form NameWIPTXSFM说明Description车间任务移动完工时检验倒冲子库条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectMOVE_TRANSACTIONS条件Condition( select count(*) from wip.wip_entities we ,wip.wip_discrete_jobs wdj ,wip.WIP_REQUIREM. 阅读全文

posted @ 2013-07-10 13:16 st.sun 阅读(331) 评论(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.DISCRETE_JOB_NAME NOT LIKE '**%'（REMARK：任务类型）处理模式Processing Mo 阅读全文

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

完工任务不允许更改需求

摘要：应用Oracle Work in Progress层LevelFunction函数名Funcgtion NameWIP_WIPMRMDF表单名Form NameWIPMRMDF说明Description完工任务不允许更改需求条件Condition触发器事件Tirgger EventWHEN-NEW-RECORD-INSTANCE触发器对象Tirgger ObjectW_REQUIREMENTS条件Condition/处理模式Processing ModeNot in Enter-Query Mode上下文层/值Contest Level/ValueResponsibility/***职... 阅读全文

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

作业需求更改,限制车间人员只允许修改子库

摘要：应用Oracle Work in Progress层LevelFunction函数名Funcgtion NameWIP_WIPMRMDF表单名Form NameWIPMRMDF说明Description作业需求更改,限制车间人员只允许修改子库条件Condition触发器事件Tirgger EventWHEN-NEW-RECORD-INSTANCE触发器对象Tirgger ObjectW_REQUIREMENTS条件Condition处理模式Processing ModeNot in Enter-Query Mode上下文层/值Contest Level/ValueResponsibili.. 阅读全文

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

有库存不能停用子库存

摘要：应用Oracle Inventory层LevelFunction函数名Funcgtion NameINV_INVSDSUB表单名Form NameINVSDSUB说明Description有库存不能停用子库存条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectSUBINV条件Condition${item.subinv.DISABLE_DATE.value} is not null and exists (select 1 from apps.org_organization_definitions ood . 阅读全文

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

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

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

摘要：应用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 阅读(254) 评论(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 阅读(227) 评论(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 阅读(559) 评论(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 阅读(310) 评论(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 阅读(638) 评论(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 阅读(146) 评论(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 阅读(312) 评论(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 阅读(200) 评论(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 阅读(244) 评论(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 阅读(166) 评论(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 阅读(216) 评论(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 阅读(144) 评论(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 阅读(221) 评论(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 阅读(301) 评论(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 阅读(6624) 评论(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 阅读(148) 评论(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 阅读(157) 评论(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 阅读(285) 评论(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 阅读(129) 评论(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 阅读(209) 评论(0) 推荐(0)

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

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

posted @ 2013-07-10 13:11 st.sun 阅读(269) 评论(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 阅读(214) 评论(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 阅读(179) 评论(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 阅读(189) 评论(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 阅读(119) 评论(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 阅读(161) 评论(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 阅读(291) 评论(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 阅读(321) 评论(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 阅读(481) 评论(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 阅读(150) 评论(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 阅读(206) 评论(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 阅读(193) 评论(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 阅读(150) 评论(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 阅读(181) 评论(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 阅读(204) 评论(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 阅读(252) 评论(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 阅读(146) 评论(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 阅读(249) 评论(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 阅读(157) 评论(0) 推荐(0)

订单行序号不可输入

摘要：应用Oracle Purchasing层LevelFunction函数名Funcgtion NameMT_POXPOEPO/ PO_POXPOEPO表单名Form NamePOXPOEPO说明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:06 st.sun 阅读(201) 评论(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 阅读(191) 评论(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 阅读(167) 评论(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 阅读(234) 评论(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 阅读(306) 评论(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 阅读(166) 评论(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 阅读(299) 评论(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 阅读(468) 评论(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 阅读(301) 评论(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 阅读(385) 评论(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 阅读(200) 评论(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 阅读(231) 评论(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 阅读(145) 评论(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 阅读(458) 评论(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 阅读(240) 评论(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 阅读(155) 评论(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 阅读(389) 评论(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 阅读(145) 评论(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 阅读(213) 评论(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 阅读(220) 评论(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 阅读(160) 评论(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 阅读(500) 评论(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 阅读(325) 评论(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 阅读(228) 评论(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 阅读(545) 评论(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 阅读(589) 评论(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 阅读(7955) 评论(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 阅读(206) 评论(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 阅读(361) 评论(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 阅读(485) 评论(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 阅读(203) 评论(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 阅读(152) 评论(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 阅读(156) 评论(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 阅读(234) 评论(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 阅读(183) 评论(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 阅读(168) 评论(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 阅读(136) 评论(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 阅读(205) 评论(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 阅读(159) 评论(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 阅读(219) 评论(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 阅读(176) 评论(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.status_type = 7and (select count(*) from WIP_REQUIREMENT_OPERATIONS_Vwhere wip_e.. 阅读全文

posted @ 2013-07-10 12:11 st.sun 阅读(182) 评论(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 阅读(231) 评论(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 阅读(169) 评论(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 阅读(178) 评论(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 阅读(180) 评论(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 阅读(183) 评论(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 阅读(161) 评论(0) 推荐(0)

导航