View source for Identify Assembly and Component Product Reconcile Group Mismatch

=== Identify overall product reconcile group mismatches ===
<pre>
SELECT x.assy_product_code,x.comp_product_code,pa.reconcile_group,pc.reconcile_group
FROM artprstr x
inner join artprod pa on pa.product_code=x.assy_product_code
inner join artprod pc on pc.product_code=x.comp_product_code
where pa.reconcile_group<>pc.reconcile_group
</pre>

=== Identify product reconcile group mismatches for a reconcile group range ===
<pre>
SELECT x.assy_product_code,x.comp_product_code,pa.reconcile_group,pc.reconcile_group
FROM artprstr x
inner join artprod pa on pa.product_code=x.assy_product_code
inner join artprod pc on pc.product_code=x.comp_product_code
where
((pa.reconcile_group between :lorecgrp and :hirecgrp) and
 (not (pc.reconcile_group between :lorecgrp and :hirecgrp))) or
((pc.reconcile_group between :lorecgrp and :hirecgrp) and
 (not (pa.reconcile_group between :lorecgrp and :hirecgrp))) 
</pre>