Query to get the Liability & Prepayment Account details for Vendor

select
pvs.org_id ,
hou.name,
pv.segment1 SUPPLIER_NUMBER,
pv.VENDOR_NAME,
pvs.VENDOR_SITE_CODE,
ADDRESS_LINE1,
ADDRESS_LINE2,
ADDRESS_LINE3
CITY,
STATE,
ZIP,
PROVINCE,
COUNTRY ,
          gcc.segment1
           || '.'
           || gcc.segment2
           || '.'
           || gcc.segment3
           || '.'
           || gcc.segment4
           || '.'
           || gcc.segment5
           || '.'
           || gcc.segment6
           || '.'
           || gcc.segment7
           || '.'
           || gcc.segment8
              "LIABILITY_ACCOUNT",
        gcc_p.segment1
           || '.'
           || gcc_p.segment2
           || '.'
           || gcc_p.segment3
           || '.'
           || gcc_p.segment4
           || '.'
           || gcc_p.segment5
           || '.'
           || gcc_p.segment6
           || '.'
           || gcc_p.segment7
           || '.'
           || gcc_p.segment8
              "PREPAYMENT_ACCOUNT",   
pv.START_DATE_ACTIVE,
pv.end_DATE_ACTIVE                       
--pvs.ACCTS_PAY_CODE_COMBINATION_ID,
--pvs.PREPAY_CODE_COMBINATION_ID
--INACTIVE_DATE
from
po_vendors pv,
po_vendor_sites_all pvs,
gl_code_combinations gcc,
gl_code_combinations gcc_p,
hr_operating_units hou
where pv.vendor_id = pvs.vendor_id
and   pvs.org_id = hou.ORGANIZATION_ID
AND pvs.ACCTS_PAY_CODE_COMBINATION_ID = gcc.CODE_COMBINATION_ID(+)
AND pvs.PREPAY_CODE_COMBINATION_ID = gcc_p.CODE_COMBINATION_ID(+)
and pvs.org_id =111
and pv.VENDOR_NAME ='SSS SERVICES LTD'