APPS.BOM_GTIN_RULES dependencies on EGO_ITEM_GTN_ATTRS_B

Line 395: UPDATE EGO_ITEM_GTN_ATTRS_B

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

Line 694: ego_item_gtn_attrs_b ega,

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