SELECT [Active Plant Parts Made From Dept Produced Components
Usage].ASSEMBLY_ITEM_NO, [Active Plant Parts Made From Dept Produced
Components Usage].COMPONENT_ITEM_NO, [Active Plant Parts Made From Dept
Produced Components Usage].COMPONENT_QTY, [Active Plant Parts Made From Dept
Produced Components Usage].[3 Yr Average], [Active Plant Parts Made From
Dept Produced Components Usage].[Comp Usage], NOETIX_SYS_INVUS_CATEGORY_ALL.
[A$CAT$ITEM_TYPE] INTO [Department Component Usage and Assembly Type]
FROM [Active Plant Parts Made From Dept Produced Components Usage] INNER
JOIN NOETIX_SYS_INVUS_CATEGORY_ALL ON [Active Plant Parts Made From Dept
Produced Components Usage].ASSEMBLY_ITEM_NO = NOETIX_SYS_INVUS_CATEGORY_ALL.
[A$ITEM$ITEM_NUMBER]
WHERE ((([Active Plant Parts Made From Dept Produced Components Usage].[3 Yr
Average])<>0) AND (([Active Plant Parts Made From Dept Produced Components
Usage].[Comp Usage])<>0) AND ((NOETIX_SYS_INVUS_CATEGORY_ALL.
[A$CAT$ITEM_TYPE])="AFT")) OR ((([Active Plant Parts Made From Dept Produced
Components Usage].[3 Yr Average]) Is Not Null) AND (([Active Plant Parts
Made From Dept Produced Components Usage].[Comp Usage]) Is Not Null) AND
((NOETIX_SYS_INVUS_CATEGORY_ALL.[A$CAT$ITEM_TYPE])="AFT+")) OR
(((NOETIX_SYS_INVUS_CATEGORY_ALL.[A$CAT$ITEM_TYPE])="OEM")) OR
(((NOETIX_SYS_INVUS_CATEGORY_ALL.[A$CAT$ITEM_TYPE])="OEM+"))
ORDER BY [Active Plant Parts Made From Dept Produced Components Usage].[3 Yr
Average] DESC , [Active Plant Parts Made From Dept Produced Components
Usage].[Comp Usage] DESC , NOETIX_SYS_INVUS_CATEGORY_ALL.[A$CAT$ITEM_TYPE];

<>0 And Is Not Null

"X" Or "Y" Or "Z"