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;
Deixe uma resposta