CREATE VIEW SLS_RCPT_V (P#, S#, D#, SLS_AMT,  SLS_QTY,  SLS_ADJ_AMT,  SLS_ADJ_QTY, 

                                    RCPT_AMT, RCPT_QTY, RCPT_ADJ_AMT, RCPT_ADJ_QTY ) as

SELECT P#, S#, D#,      

    SLS_AMT,           SLS_QTY ,          cast(null as dec), cast(null as dec),

    cast(null as dec), cast(null as dec), cast(null as dec), cast(null as dec)

  FROM SLS

union all

SELECT P#, S#, D#, 

    cast(null as dec), cast(null as dec), SLS_ADJ_AMT,       SLS_ADJ_QTY,

    cast(null as dec), cast(null as dec), cast(null as dec), cast(null as dec)

  FROM SLS_ADJ

union all

SELECT P#, S#, D#, 

    cast(null as dec), cast(null as dec), cast(null as dec), cast(null as dec),

    RCPT_AMT,          RCPT_QTY,          cast(null as dec), cast(null as dec)

  FROM RCPT

union all

SELECT P#, S#, D#, 

    cast(null as dec), cast(null as dec), cast(null as dec), cast(null as dec),

    cast(null as dec), cast(null as dec), RCPT_ADJ_AMT,      RCPT_ADJ_QTY

  FROM RCPT_ADJ

;