APPS.BOM_GTIN_RULES dependencies on EGO_GTIN_MFG_ATTRS_V

Line 769: ego_gtin_mfg_attrs_v ega

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
773: AND be.common_organization_id = ega.organization_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;