APPS.BOM_GTIN_RULES dependencies on BOM_EXPLOSIONS_ALL

Line 696: FROM bom_explosions_all be,

692: count(DISTINCT ega.brand_owner_name) brand_owner_name_cnt,
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

Line 768: FROM bom_explosions_all be,

764: */
765:
766: SELECT DISTINCT concat(ega.manufacturer,ega.name_of_manufacturer)
767: BULK COLLECT INTO l_mfg_table
768: FROM bom_explosions_all be,
769: ego_gtin_mfg_attrs_v ega
770: WHERE be.group_id = p_group_id
771: AND be.trade_item_descriptor = 'BASE_UNIT_OR_EACH'
772: AND be.component_item_id = ega.inventory_item_id

Line 791: (SELECT null FROM bom_explosions_all be, ego_gtin_mfg_attrs_v ega

787: l_where_clause := substr(l_where_clause,2);
788:
789: /*
790: dbms_output.put_line(substr('SELECT 1 INTO l_result FROM dual WHERE EXISTS
791: (SELECT null FROM bom_explosions_all be, ego_gtin_mfg_attrs_v ega
792: WHERE be.group_id = '||p_group_id||' AND be.trade_item_descriptor = '||''''||'BASE_UNIT_OR_EACH'||''''||
793: ' AND be.component_item_id = ega.inventory_item_id AND be.common_organization_id = ega.organization_id
794: AND concat(ega.manufacturer,ega.name_of_manufacturer) IN ('||l_where_clause||')'||
795: ' GROUP BY be.component_item_id HAVING count(*) <>'||l_total_mfrs||')',1,250));

Line 801: (SELECT null FROM bom_explosions_all be, ego_gtin_mfg_attrs_v ega

797:
798: BEGIN
799:
800: EXECUTE IMMEDIATE 'SELECT 1 FROM dual WHERE EXISTS
801: (SELECT null FROM bom_explosions_all be, ego_gtin_mfg_attrs_v ega
802: WHERE be.group_id = '||p_group_id||' AND be.trade_item_descriptor = '||''''||'BASE_UNIT_OR_EACH'||''''||
803: ' AND be.component_item_id = ega.inventory_item_id AND be.common_organization_id = ega.organization_id
804: AND concat(ega.manufacturer,ega.name_of_manufacturer) IN ('||l_where_clause||')'||
805: ' GROUP BY be.component_item_id HAVING count(*) <> '||l_total_mfrs||' )' INTO l_result;