| 1 |
- CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `aidopdev`.`vscm_cgshrk` AS select `d`.`Receiver` AS `Receiver`,`d`.`Line` AS `Line`,`d`.`QtyReceived` AS `QtyReceived`,`m`.`PurOrd` AS `OrdNbr`,`m`.`Line` AS `OrdLine`,`d`.`Delivery` AS `Delivery`,`d`.`ItemNum` AS `ItemNum`,`d`.`CreateTime` AS `CreateTime`,`d`.`QCNbr` AS `QCNbr`,`d`.`StatusByQC` AS `StatusByQC`,`d`.`QCDescr` AS `QCDescr`,`d`.`RctQty` AS `RctQty`,`d`.`QtyReturn` AS `QtyReturn`,`m`.`QtyOrded` AS `QtyOrded`,if((`m`.`ReceiptQty` >= `m`.`RctQty`),`m`.`ReceiptQty`,`m`.`RctQty`) AS `ReceiptQty`,`m`.`RctQty` AS `yssl`,`m`.`QtyReturned` AS `QtyReturned`,`d`.`LotSerial` AS `LotSerial` from ((`PurOrdDetail` `m` left join `PurOrdRctDetail` `d` on(((`d`.`Domain` = `m`.`Domain`) and (`d`.`OrdNbr` = `m`.`PurOrd`) and (`d`.`OrdLine` = `m`.`Line`) and (`d`.`RctType` = 'temp')))) left join `PurOrdRctMaster` `p` on(((`d`.`Domain` = `p`.`Domain`) and (`d`.`Receiver` = `p`.`Receiver`))));
|
