SELECT ITE_BILL.COMPONENT AS item_type
          ,ITE_BILL.COMP_DESC AS description
          ,ITE_BILL.QUANTITY  AS qty
          ,ITE_BILL.PARENT    AS parent_id
          ,ITE_BILL.DRWG      AS dwg_num
      FROM ITE_BILL
     WHERE (PARENT='7531MD6010B' OR PARENT='7461RD1001' OR PARENT='7531MK7010B')