SELECT DISTINCT B.TYPECATIND, F.TYPECATIND, T.TYPECATIND, M.TYPECATIND FROM PRODUCT.TYPECATEGORY B, PRODUCT.TYPECATEGORY PRJ, PRODUCT.TYPECATEGORY F, PRODUCT.TYPECATEGORY T, PRODUCT.TYPECATEGORY M, PRODUCT.CATEGORY C WHERE T.PARENTCATIND=PRJ.TYPECATIND AND PRJ.PARENTCATIND=F.TYPECATIND AND F.PARENTCATIND=B.TYPECATIND AND M.PARENTCATIND=T.TYPECATIND AND ((M.CATEGORYLEVEL='model' AND T.DESCRIPTION='8670' AND M.DESCRIPTION='MJX') OR (M.CATEGORYLEVEL='partnum' AND M.DESCRIPTION='8670MJX')) AND M.TYPECATIND=C.TYPECATIND FOR READ ONLY