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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

摘要：应用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/***职责活动.. 阅读全文

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

摘要：应用Oracle Inventory层LevelFunction函数名Funcgtion NamePERWSEMP表单名Form NamePERWSEMP说明Description不可新增人员条件Condition触发器事件Tirgger EventWHEN-NEW-RECORD-INSTANCE触发器对象Tirgger ObjectPERSON条件Condition/处理模式Processing ModeNot in Enter-Query Mode上下文 层/值Contest Level/ValueResponsibility/***职责活动Actions序号seq特性Type说明Des. 阅读全文

摘要：应用Oracle Quality层LevelFunction函数名Funcgtion NameMT_RCVTXERT_DELIVER表单名Form NameRCVTXERT说明Description已接受的记录不能再作检验条件Condition触发器事件Tirgger EventWHEN-NEW-RECORD-INSTANCE触发器对象Tirgger ObjectRCV_TRANSACTION条件Condition:OVERFLOW_AREA.INSPECTION_STATUS ='已接受 - 要求检验'处理模式Processing ModeNot in Enter-Query 阅读全文