摘要:1.1.1 表单个性化定义 Oracle EBS 11.5.10所增加的Form Presonalization功能,是在对Form不进行开发的前提下,用一些系统内置的触发器,按照所设定的控制规则及条件逻辑,改变Form的标准功能,从而实现对部分功能个性化控制的目的。如下是使用“Form Preso...
阅读全文
摘要:应用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
阅读全文
摘要:应用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.
阅读全文
摘要:应用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..
阅读全文
摘要:应用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: 操作用户)
阅读全文
摘要:应用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 .
阅读全文
摘要:应用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.
阅读全文
摘要:应用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
阅读全文
摘要:应用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/***职...
阅读全文
摘要:应用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..
阅读全文
摘要:应用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...
阅读全文
摘要:应用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_..
阅读全文
摘要:应用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...
阅读全文
摘要:应用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...
阅读全文
摘要:应用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...
阅读全文
摘要:应用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..
阅读全文
摘要:应用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
阅读全文
摘要:应用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...
阅读全文
摘要:应用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_
阅读全文
摘要:应用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特...
阅读全文