DBA Data[Home] [Help]

APPS.BOM_GTIN_RULES dependencies on EGO_ITEM_GTN_ATTRS_TL

Line 695: ego_item_gtn_attrs_tl egal,

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'
699: AND be.component_item_id = msi.inventory_item_id