[Item_Type]="C"
and
[Product_Code]="A/111300"
and
not (deleted)
and
[Branch]="F"