Down or Up levels of the BOM

This post I will go over the code to go down or level up the structure of the BOM (Bill of Materials), inside the EBS you can consult the combination of father and son by the screens below:

Indentend Bills

Or to facilitate and make the search faster and easier access also has the option by code.

INDENTED BILLS

DECLARE
v_err_msg VARCHAR2(4000);
v_err_code VARCHAR2(4000);
v_session_id NUMBER;
BEGIN
bompxinq.exploder_userexit (org_id => p_organization_id, -- organizacao
grp_id => v_session_id, -- id da sessão
item_id => p_inventory_item_id, -- id do item
expl_qty => 1,
unit_number_from => NULL,
unit_number_to => NULL,
levels_to_explode => 1, -- niveis para descer
order_by => 1,
explode_option => 3,
show_rev => 1,
module => 1,
cst_type_id => p_cost_type_id, -- id do custo
err_msg => v_err_msg,
error_code => v_error_code);
END;

select * from bom_small_expl_temp;

Utilização do Item

DECLARE
v_item_utilizado VARCHAR2(400);
v_err_msg VARCHAR2(4000);
v_err_code VARCHAR2(4000);
v_sequence NUMBER;
BEGIN

v_sequence := bom_implosion_temp_s.nextval;

BOMPIINQ.IMPLODER_USEREXIT ( sequence_id => v_sequence,
eng_mfg_flag => 1, -- BOM ou ENG
org_id => pi_organization_id, -- organizacao
impl_flag => 1, -- somente implementado
display_option => 3, -- futuro e atual
levels_to_implode => 4, -- niveis para subir
item_id => pi_inventory_item_id, -- id do item
impl_date => TO_CHAR(SYSDATE,'YYYY/MM/DD HH24:MI'),
unit_number_from => NULL,
unit_number_to => NULL,
err_msg => v_err_msg,
err_code => v_err_code,
organization_option => 1, --organização atual
organization_hierarchy => NULL,
serial_number_from => NULL,
serial_number_to => NULL);
END;

select * from bom_small_impl_temp;