SELECT k.`ID` AS attribute1, CAST(k.`KIT_number` AS CHAR) AS attribute6, k.Sapphire_Product_Name AS attribute7, k.`sapphire_child_reqid` AS attribute8 , ( CASE WHEN k.`hotlist_Status` = 0 THEN 'NOT_APPLICABLE' WHEN k.`hotlist_Status` = 1 THEN 'ACCEPTED' ELSE 'NOT_APPLICABLE' END ) AS attribute9 FROM `kit_details` k WHERE k.`Merchant_ID` = '164691769' AND k.`Sapphire_Child_ReqID`='CIMS\-MO07254591\/INV\/07\/25\/1' and k.`cbs_status` = 'Unused' and k.`hotlist_Status` = '0' and k.`dispatch_status` in ('Delivered','instock','Dispatched') order by k.`outward_date` desc -- k.`Sapphire_Child_ReqID` asc LIMIT 0,1000 |
3
|
3
|
0
|
|
0.00
|
Return
Main page
Update
PDF
Day
Week
All
Find usages