On your CTE declaration you have @Pattern, @Room, & @tag. I'd change them to Pattern, Room, & Tag.

;with C_ORDERS_CTE (

co_num,

co_line,

item,

cust_num,

cust_seq,

qty_ordered,

qty_ready,

qty_shipped,

promise_date,

ship_date,

order_date,

stat,

Uf_PJ_AllocatedDate, ---as AvailableDate,

@Pattern, ---as pattern,

@Room, ---as room,

@tag)

change to

;with C_ORDERS_CTE (

co_num,

co_line,

item,

cust_num,

cust_seq,

qty_ordered,

qty_ready,

qty_shipped,

promise_date,

ship_date,

order_date,

stat,

Uf_PJ_AllocatedDate, ---as AvailableDate,

Pattern, ---as pattern,

Room, ---as room,

Tag)