SELECT ORGANIZATION_ID,ASSEMBLY_ITEM_ID,ASSEMBLY_TYPE,ALTERNATE_BOM_DESIGNATOR,COMMON_BILL_SEQUENCE_ID,BILL_SEQUENCE_ID FROM BOM_BILL_OF_MATERIALS WHERE ALTERNATE_BOM_DESIGNATOR IS NULL
View Text - HTML Formatted
SELECT ORGANIZATION_ID , ASSEMBLY_ITEM_ID , ASSEMBLY_TYPE , ALTERNATE_BOM_DESIGNATOR , COMMON_BILL_SEQUENCE_ID , BILL_SEQUENCE_ID FROM BOM_BILL_OF_MATERIALS WHERE ALTERNATE_BOM_DESIGNATOR IS NULL