Home » SQL & PL/SQL » SQL & PL/SQL » BOM Explosion package
BOM Explosion package [message #239124] Mon, 21 May 2007 09:21 Go to next message
tarmenel
Messages: 63
Registered: February 2007
Location: Israel
Member

Hi there all,

I'm posting this here not because I'm an expert but I think this is a little bit past the basics. I've also done the searches in both Google and the forum unsuccessfully. The following code is supposed to create the explosion on the BOM into BOM_SMALL_EXPL_TEMP but unfortunately seems to be empty. I've made sure to take an assembly item with a good tree with a few levels but unfortunately nothing seems to be happening. From what I did find on the net seems to be old as they've added two columns unit_number_from and unit_number_to, not sure what they are and not sure if this is affecting the package from working.
declare
v_assembly_group_id   integer;
v_err_msg             VARCHAR2(2000);
v_err_code            integer;
begin
SELECT bom_explosion_temp_s.NEXTVAL INTO v_assembly_group_id FROM sys.dual;
bompxinq.exploder_userexit(
0,                                --verify_flag
106,                              --org_id 
1,                                --order_by	
v_assembly_group_id,              --grp_id	
0,                                --session_id
12,                               --levels_to_explode
1,                                --bom_or_eng
1,                                --impl_flag
2,                                --plan_factor_flag
2,                                --explode_option
2,                                --module
1,                                --cst_type_id
0,                                --std_comp_flag
1,                                --expl_qty
56083,--v_assembly_item_id,               --item_id
null,                                 --unit_number_from
NULL,                                  --unit_number_to
'',                                --alt_desg
NULL,                               --comp_code
SYSDATE,                          --rev_date
1,                                --show_rev
1,                                --material_ctrl
2,                                --lead_time
v_err_msg,                        --err_msg
v_err_code);                      --error_code
commit;
dbms_output.put_line(v_assembly_group_id);                        
dbms_output.put_line(v_err_code);
dbms_output.put_line(v_err_msg);                           
end;

If anyone has made use of this package please could you let me know what i may be missing.
Re: BOM Explosion package [message #240986 is a reply to message #239124] Mon, 28 May 2007 02:38 Go to previous message
tarmenel
Messages: 63
Registered: February 2007
Location: Israel
Member

I figured out the problem. It seems I can't query the data in the temp table afterwards but have to deal with the info at the same time of the procedure when it runs
Previous Topic: send mail through oracle
Next Topic: parse count=execution with cursor ref
Goto Forum:
  


Current Time: Thu Dec 08 00:01:10 CST 2016

Total time taken to generate the page: 0.10395 seconds