SELECT PR.PRODUCT_CODE, PR.RECONCILE_GROUP,
PR1.PRODUCT_CODE, PR1.RECONCILE_GROUP,
PR2.PRODUCT_CODE, PR2.RECONCILE_GROUP,
PR3.PRODUCT_CODE, PR3.RECONCILE_GROUP,
PR4.PRODUCT_CODE, PR4.RECONCILE_GROUP,
PR5.PRODUCT_CODE, PR5.RECONCILE_GROUP,
PR6.PRODUCT_CODE, PR6.RECONCILE_GROUP,
PR7.PRODUCT_CODE, PR7.RECONCILE_GROUP,
PR8.PRODUCT_CODE, PR8.RECONCILE_GROUP,
PR9.PRODUCT_CODE, PR9.RECONCILE_GROUP
FROM ARTPROD PR
LEFT OUTER JOIN ARTPRSTR PS1 ON (PS1.ASSY_PRODUCT_CODE = PR.PRODUCT_CODE)
LEFT OUTER JOIN ARTPROD PR1 ON (PR1.PRODUCT_CODE = PS1.COMP_PRODUCT_CODE)
LEFT OUTER JOIN ARTPRSTR PS2 ON (PS2.ASSY_PRODUCT_CODE = PS1.COMP_PRODUCT_CODE)
LEFT OUTER JOIN ARTPROD PR2 ON (PR2.PRODUCT_CODE = PS2.COMP_PRODUCT_CODE)
LEFT OUTER JOIN ARTPRSTR PS3 ON (PS3.ASSY_PRODUCT_CODE = PS2.COMP_PRODUCT_CODE)
LEFT OUTER JOIN ARTPROD PR3 ON (PR3.PRODUCT_CODE = PS3.COMP_PRODUCT_CODE)
LEFT OUTER JOIN ARTPRSTR PS4 ON (PS4.ASSY_PRODUCT_CODE = PS3.COMP_PRODUCT_CODE)
LEFT OUTER JOIN ARTPROD PR4 ON (PR4.PRODUCT_CODE = PS4.COMP_PRODUCT_CODE)
LEFT OUTER JOIN ARTPRSTR PS5 ON (PS5.ASSY_PRODUCT_CODE = PS4.COMP_PRODUCT_CODE)
LEFT OUTER JOIN ARTPROD PR5 ON (PR5.PRODUCT_CODE = PS5.COMP_PRODUCT_CODE)
LEFT OUTER JOIN ARTPRSTR PS6 ON (PS6.ASSY_PRODUCT_CODE = PS5.COMP_PRODUCT_CODE)
LEFT OUTER JOIN ARTPROD PR6 ON (PR6.PRODUCT_CODE = PS6.COMP_PRODUCT_CODE)
LEFT OUTER JOIN ARTPRSTR PS7 ON (PS7.ASSY_PRODUCT_CODE = PS6.COMP_PRODUCT_CODE)
LEFT OUTER JOIN ARTPROD PR7 ON (PR7.PRODUCT_CODE = PS7.COMP_PRODUCT_CODE)
LEFT OUTER JOIN ARTPRSTR PS8 ON (PS8.ASSY_PRODUCT_CODE = PS7.COMP_PRODUCT_CODE)
LEFT OUTER JOIN ARTPROD PR8 ON (PR8.PRODUCT_CODE = PS8.COMP_PRODUCT_CODE)
LEFT OUTER JOIN ARTPRSTR PS9 ON (PS9.ASSY_PRODUCT_CODE = PS8.COMP_PRODUCT_CODE)
LEFT OUTER JOIN ARTPROD PR9 ON (PR9.PRODUCT_CODE = PS9.COMP_PRODUCT_CODE)
WHERE
(PR.RECONCILE_GROUP BETWEEN :BEGGRP AND :ENDGRP) AND
((NOT (PR1.RECONCILE_GROUP BETWEEN :BEGGRP AND :ENDGRP)) OR
(NOT (PR2.RECONCILE_GROUP BETWEEN :BEGGRP AND :ENDGRP)) OR
(NOT (PR3.RECONCILE_GROUP BETWEEN :BEGGRP AND :ENDGRP)) OR
(NOT (PR4.RECONCILE_GROUP BETWEEN :BEGGRP AND :ENDGRP)) OR
(NOT (PR5.RECONCILE_GROUP BETWEEN :BEGGRP AND :ENDGRP)) OR
(NOT (PR6.RECONCILE_GROUP BETWEEN :BEGGRP AND :ENDGRP)) OR
(NOT (PR7.RECONCILE_GROUP BETWEEN :BEGGRP AND :ENDGRP)) OR
(NOT (PR8.RECONCILE_GROUP BETWEEN :BEGGRP AND :ENDGRP)) OR
(NOT (PR9.RECONCILE_GROUP BETWEEN :BEGGRP AND :ENDGRP))
)