>>WHERE (((PK_MOC.MOC_PART_NO) Not Like "*-CR" And (PK_MOC.MOC_PART_NO) Not Like "*RMA*" And (PK_MOC.MOC_PART_NO) Not Like "*RW" And >> (PK_MOC.MOC_PART_NO) Not Like "*RWK") AND ((PK_MOC.MOC_OHNUMBER) Not Like "FCST*") AND ((IIf([PK_RQ]![RQ_STATUS]="C" Or >> [PK_RQ]![RQ_QTY_ISS]>=[PK_RQ]![RQ_QTY_REQ],IIf([PK_RQ]![RQ_DATE_PROM]>=Date()-365 Or [PK_RQ]![RQ_DATE_REQ]>=Date()-365,True,False),True))=True) AND >> ((PK_OH.OH_STATUS)<=3) AND ((PK_MOC.MOC_OHTYPE)<>"Q") AND ((PK_RQ.RQ_O_TYPE)<>"X" Or (PK_RQ.RQ_O_TYPE) Is Null)); >>>>
>>WHERE ((MOC.MOC_PART_NO NOT LIKE '%-CR' AND MOC.MOC_PART_NO NOT LIKE '%RMA%' AND MOC.MOC_PART_NO NOT LIKE '%RW' AND MOC.MOC_PART_NO NOT LIKE '%RWK') AND >> (MOC.MOC_OHNUMBER NOT LIKE 'FCST%') AND >> (CASE WHEN RQ.RQ_STATUS = 'C' OR RQ.RQ_QTY_ISS >= RQ.RQ_QTY_REQ THEN >> CASE WHEN RQ.RQ_DATE_PROM >= GETDATE() - 365 OR RQ.RQ_DATE_REQ >= GETDATE() - 365 THEN 1 ELSE 0 END ELSE 0 >> END = 1) AND >> (OH.OH_STATUS <= 3) AND >> (MOC.MOC_OHTYPE <> 'Q') AND >> (RQ.RQ_O_TYPE <> 'X' OR RQ.RQ_O_TYPE IS NULL)) >> >>>>