581: SELECT bom_item_type
582: , pick_components_flag
583: , bom_enabled_flag
584: , eng_item_flag
585: FROM MTL_SYSTEM_ITEMS
586: WHERE organization_id = p_org_id
587: AND inventory_item_id = p_item_id
588: ;
589:
822: l_return_status VARCHAR2(1);
823:
824: CURSOR c_ItemType IS
825: SELECT bom_item_type
826: FROM MTL_SYSTEM_ITEMS
827: WHERE inventory_item_id = p_item_id
828: AND organization_id = p_organization_id;
829:
830: