JOINS BETWEEN mtl_system_items,mtl_item_categories, mtl_categories_b, Ra_customer_trx_all, AND Ra_customer_trx_lines_all

SELECT  DISTINCT MSI.SEGMENT1,RCTL.CREATION_DATE,MCB.SEGMENT4
FROM mtl_system_items MSI,
     mtl_item_categories MIC,
     mtl_categories_b MCB,
     Ra_customer_trx_all RCTA,
     Ra_customer_trx_lines_all RCTL
WHERE MSI.INVENTORY_ITEM_ID=MIC.INVENTORY_ITEM_ID
   AND MIC.CATEGORY_ID=MCB.CATEGORY_ID
   AND RCTA.CUSTOMER_TRX_ID=RCTL.CUSTOMER_TRX_ID
   AND RCTL.INVENTORY_ITEM_ID=MSI.INVENTORY_ITEM_ID
    AND MCB.SEGMENT4 LIKE 'ABC%'
    AND RCTL.CREATION_DATE LIKE '%15';