===========================================================
===========================================================
PO 编号产生规则
作者: moonsoft(http://moonsoft.itpub.net)发表于: 2007.01.31 11:56
分类: 分销 , EBS
出处: http://moonsoft.itpub.net/post/15182/258875
---------------------------------------------------------------
EBS :PO-setup->organization->purchasing option ->
通过查看form , 得:
select *
from
po_unique_identifier_cont_all
where org_id=204
可以看出,如果PO segment1 的产生规则是保存在表里面,然后加1
form 里面的源代码:
PROCEDURE get_next_num (doc_num IN OUT NUMBER,
doc_table IN VARCHAR2,
doc_message IN VARCHAR2)
IS
x_progress VARCHAR2(3) := NULL;
BEGIN
x_progress := '010';
SELECT (current_max_unique_identifier + 1)
INTO doc_num
FROM po_unique_identifier_control
WHERE table_name = doc_table;
EXCEPTION
WHEN OTHERS THEN
PO_MESSAGE_C.SHOW;
RAISE form_trigger_failure;
END get_next_num;
