cof_dunningdetails_v

SELECT dr.c_dunningrun_id,

    dr.ad_client_id,

    dr.ad_org_id,

    dr.isactive,

    dr.created,

    dr.createdby,

    dr.updated,

    dr.updatedby,

    dr.dunningdate,

    dr.c_dunninglevel_id,

    dr.processed,

    dr.processing,

    dr.sendit,

    dr.description,

    dr.c_dunning_id,

    dr.c_dunningrun_uu,

    dre.c_dunningrunentry_id,

    dre.isactive AS entry_active,

    dre.c_bpartner_id,

    dre.c_bpartner_location_id,

    dre.ad_user_id,

    dre.c_currency_id,

    dre.salesrep_id,

    dre.amt,

    dre.qty,

    dre.note,

    dre.processed AS entry_processed,

    dre.cof_dunningstatus,

    dre.cof_datescheduled,

    dre.cof_processing

   FROM (c_dunningrun dr

     LEFT JOIN c_dunningrunentry dre USING (c_dunningrun_id));