随笔分类 -  Oracle EBS-SYS Form Presonalization(表单个性化)

摘要：应用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... 阅读全文

摘要：应用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 =& 阅读全文

摘要：应用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 阅读全文

摘要：应用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 阅读全文

摘要：应用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') 阅读全文

摘要：应用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 阅读全文

摘要：应用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.. 阅读全文

摘要：应用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... 阅读全文

摘要：应用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 阅读全文

摘要：应用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... 阅读全文

摘要：应用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序... 阅读全文

摘要：应用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... 阅读全文

摘要：应用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 阅读全文

摘要：应用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 阅读全文

摘要：应用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... 阅读全文

摘要：应用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 阅读全文

摘要：应用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 阅读全文

摘要：应用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_ 阅读全文

摘要：应用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 阅读全文

摘要：应用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... 阅读全文