APPS.BOM_GTIN_RULES dependencies on EGO_ITEM_GTN_ATTRS_B

Line 398: UPDATE EGO_ITEM_GTN_ATTRS_B

394: is_preferred_flag := TRUE;
395: END LOOP;
396: END IF;
397: IF (is_preferred_flag) THEN
398: UPDATE EGO_ITEM_GTN_ATTRS_B
399: SET top_gtin = null
400: WHERE inventory_item_id = p_component_item_id AND
401: organization_id = p_organization_id;
402: END IF;

Line 697: ego_item_gtn_attrs_b ega,

693: count(DISTINCT ega.sub_brand) sub_brand_cnt,
694: count(DISTINCT egal.functional_name) functional_name_cnt,
695: count(DISTINCT msi.weight_uom_code) weight_uom_code_cnt
696: FROM bom_explosions_all be,
697: ego_item_gtn_attrs_b ega,
698: ego_item_gtn_attrs_tl egal,
699: mtl_system_items_b msi
700: WHERE be.group_id = p_group_id
701: AND be.trade_item_descriptor = 'BASE_UNIT_OR_EACH'