CREATE OR REPLACE VIEW test2
AS
SELECT  mdgv.customer_id customer_id,
        NVL(rc.customer_number,0) customer_number,
        NVL(rc.customer_name,'Unidentified') customer_name,
        mdgv.payment_schedule_id payment_schedule_id,
        mdgv.trx_number trx_number,
        mdgv.trx_date trx_date,
        mdgv.due_date due_date,
        mdgv.gl_date_closed gl_date_closed,
        mdgv.amount amount
FROM    test1 mdgv,
        ra_customers rc
WHERE   mdgv.customer_id = rc.customer_id (+);