supplier liability account detail in oracle apps

/* Formatted on 9/25/2014 9:05:48 AM (QP5 v5.115.810.9015) */
SELECT   VENDOR_NAME,
            gcc.SEGMENT1
         || ','
         || gcc.SEGMENT2
         || ','
         || gcc.SEGMENT3
         || ','
         || gcc.SEGMENT4
         || ','
         || gcc.SEGMENT5
         || ','
         || gcc.SEGMENT6
            liability_account
  FROM   ap_suppliers aps,
         ap_supplier_sites_all apss,
         GL_CODE_COMBINATIONS gcc
 WHERE       2 = 2
         AND aps.VENDOR_ID = apss.VENDOR_ID
         AND apss.ACCTS_PAY_CODE_COMBINATION_ID = gcc.CODE_COMBINATION_ID
         AND aps.VENDOR_ID = 723
         AND CODE_COMBINATION_ID = 114582