OraFAQ Forum: SQL & PL/SQL » BOM Explosion package

Home » SQL & PL/SQL » SQL & PL/SQL » BOM Explosion package

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

BOM Explosion package [message #239124]

Mon, 21 May 2007 09:21

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.

Report message to a moderator

Re: BOM Explosion package [message #240986 is a reply to message #239124]

Mon, 28 May 2007 02:38

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

Report message to a moderator

Previous Topic:	send mail through oracle
Next Topic:	parse count=execution with cursor ref

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 12 17:04:07 CDT 2025