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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

摘要：应用Oracle Bill Of Materiel层LevelFunction函数名Funcgtion NameBOM_BOMFDBOM表单名Form NameBOMFDBOM说明Description不显示BOM清单的版本条件Condition触发器事件Tirgger EventWHEN-NEW-FORM-INSTANCE触发器对象Tirgger Object/条件Condition/处理模式Processing ModeNot in Enter-Query Mode上下文 层/值Contest Level/ValueResponsibility/***职责活动Actions序号seq... 阅读全文

摘要：应用Oracle Bill Of Materiel层LevelFunction函数名Funcgtion NameBOM_BOMFDBOM表单名Form NameBOMFDBOM说明Description配件BOM定义限制（只定义配件的）条件Condition触发器事件Tirgger EventWHEN-VALIDATE-RECORD触发器对象Tirgger ObjectB_BILL_OF_MATLS条件Condition:B_BILL_OF_MATLS.ITEM NOT LIKE '56HS%'and :B_BILL_OF_MATLS.ITEM NOT LIKE '5% 阅读全文