如何在值集Value Set的Where条件里去重
SELECT ei.rowid, ei.inventory_item_id
FROM pa_expenditure_items_all ei
WHERE ei.rowid IN
(SELECT MIN(ROWID)
FROM pa_expenditure_items_all ei1
WHERE ei1.inventory_item_id = ei.inventory_item_id);
获取当前组织(OU)
l_org_id := mo_global.get_current_org_id;
模拟登陆
BEGIN
fnd_global.apps_initialize(user_id => 1438,
resp_id => 50649,
resp_appl_id => 201);
mo_global.init(fnd_global.application_short_name);
--mo_global.init;
--dbms_application_info.set_client_info(88);
--mo_global.set_policy_context('S',88);
END;
SELECT fnd_profile.value('ORG_ID') FROM dual;
html或者xml报表设置编码方式,获取预置文件的字符集
output('<?xml version="1.0" encoding="' || fnd_profile.value('ICX_CLIENT_IANA_ENCODING') || '"?>');
系统设置的日期格式
g_date_format VARCHAR(30) := fnd_profile.value('ICX_DATE_FORMAT_MASK');
xml报表指定包含特殊字符的内容(或者通过replace函数替换)
<![CDATA[rec.number]]>
Message定义和使用
定义Message
XXINV_001E_001
The &OBJECT &WHAT_ERROR.
fnd_message.set_name('XXINV','XXINV_001E_001');
fnd_message.set_token('OBJECT','Value');
fnd_message.set_token('WHAT_ERROR','should not contain comma');
fnd_message.error;
注册客户化表到应用产品
BEGIN
ad_dd.register_table('XXWIP', 'XXWIP_PRODUCTION_PROCESS_SCAN', 'T');
commit;
END;
对于头行结构记录,如何在SQL里实现同一个头只在第一行输出该头信息,其他行头信息放空
select xe.department_id,
xe.employee_id,
decode(xe.employee_id,
(select min(xe1.employee_id) from xxtest_employees xe1 where xe.department_id = xe1.department_id), xe.department_id,
null),
xe.employee_id
from xxtest_employees xe
order by xe.department_id, xe.employee_id;