======================================================
SELECT STATEMENT   Cost = 11
  HASH JOIN SEMI
    HASH JOIN SEMI
      HASH JOIN
        TABLE ACCESS FULL record_master 
        TABLE ACCESS FULL Detail_record
      TABLE ACCESS FULL list_copy
    TABLE ACCESS FULL list_home
=====================================================