0 - 2 of 2 tags for SQL syntax

I'm geting an error 3782 when trying to add the last 2 fields in the first selet statement and I don't know what is wrong.  Any help would be appreciated.  Thanks.....
    mp.mop_desc as "Card Type",
    ph.CR_CARD_NBR  as "CC Last 4",
    ph.name as Card_Holder,

Hi guys,
My first post here (I've used other threads to help solve problems but stuck and haven't found a solution so looking for a method or hint).
I have a table that has commitment in it (qty of units coming in against future weeks); imagine like so;