qq_36818903的博客

EBS FORM跳转工作台后带条件查询

使用EBS个性化修改标准FORM的LOV

工作笔记

EBS物料属性（接收子库）更新API： 内联代码片。// 代码如下// An highlighted block declare l_return_status VARCHAR2(240); l_msg_count NUMBER; x_msg_data VARCHAR2(240); begin inv_item_sub_default_pkg.insert_upd_item_sub_defaults(p_organization_id =>

PLSQL程序包被锁：// 查询被锁程序包IDSelect b.SID, b.SERIAL# From dba_ddl_locks a, v$session b Where a.session_id = b.SID And a.name = 'SCUX_MRP_MODIFYLOG_RPKG';--程序包名称 // 杀死相关进程 alter system kill session '89,57299';--SIDPLSQL功能界面被锁：// 1查询SELECT 'alter sy

Oracle EBS循环操作表单选择触发器后：~~// CODEIF Pv_Owner = 'CONTROL.COMFIRM_BTN2' AND Pv_Event = 'WHEN-BUTTON-PRESSED' THEN :System.Message_Level := 25; DECLARE l_Query_Hits2 number; begin l_Query_Hits2 := To_Number(Get_Block_Property('SCUX_MR

全选功能建立ITEM及其触发器如下程序包CODE：ELSIF Pv_Owner = 'CONTROL.CHECK_ALL2' AND Pv_Event = 'WHEN-CHECKBOX-CHANGED' THEN IF :CONTROL.Check_All2 = 'Y' THEN go_block('Scux_Mrp_Batch_Modify'); first_record; LOOP :Scux_Mrp_Batch_Modify.CHOOSE2 :