DECLARE
l_sequence_id NUMBER;
l_err_msg VARCHAR2(80);
l_err_code NUMBER;
l_organization_id NUMBER := 108;
l_inventory_item_id NUMBER := 3003;
BEGIN
DELETE bom_small_impl_temp;
SELECT bom_implosion_temp_s.nextval
INTO l_sequence_id
FROM dual;
bompiinq.imploder_userexit(sequence_id => l_sequence_id
,eng_mfg_flag => 1 -- 2
,org_id => l_organization_id
,impl_flag => 1 --2
,display_option => 3 --1
,levels_to_implode => 1 --15
,item_id => l_inventory_item_id
, --34077520002
impl_date => SYSDATE
,unit_number_from => NULL
,unit_number_to => NULL
,err_msg => l_err_msg
,err_code => l_err_code
,organization_option => 1 --3
,organization_hierarchy => NULL
,serial_number_from => NULL
,serial_number_to => NULL);
END;
BOM反展API
最新推荐文章于 2023-10-26 09:58:18 发布