44: and explosion_type = 'ALL';
45:
46: select item_type
47: into l_comp_type
48: from mtl_system_items
49: where inventory_item_id = l_comp_id
50: and organization_id = p_org_id;
51:
52: select item_type
50: and organization_id = p_org_id;
51:
52: select item_type
53: into l_parent_type
54: from mtl_system_items
55: where inventory_item_id = l_parent_id
56: and organization_id = p_org_id;
57:
58: /* Criteria :