Call Stack
string 
string SELECT * FROM (SELECT JimStock.StockNo, JimStock.StockCode, JimStock.StockDesc, JimStock.Alive, JimStock.GLGroupNo, JimStock.ManufPartCode ,(SELECT IFNULL(SUM(JimStockTran.QtyB), 0) FROM JimStockTran WHERE (JimStockTran.Type = 'P') AND (JimStockTran.QtyB > 0) AND (JimStockTran.StockNo = JimStock.StockNo)) AS OnHand,(SELECT IFNULL(SUM(JimJobPart.Quantity), 0) FROM JimJobPart INNER JOIN JimJob ON JimJobPart.JobNo = JimJob.JobNo WHERE (JimJob.InvNo = - 1) AND (JimJobPart.StockNo = JimStock.StockNo)) AS Committed,(SELECT IFNULL(SUM(JimPODet.Qty), 0) FROM JimPODet, JimPO WHERE JimPODet.PONo = JimPO.PONo AND JimPO.POType = 0 AND JimPO.Status like '%Ordered%' AND JimPODet.StockNo = JimStock.StockNo) AS OnOrder,(SELECT COUNT(JimStockGroups.StockGroupNo) FROM JimStockGroups INNER JOIN JimStockGroup ON JimStockGroups.StockGroupNo = JimStockGroup.StockGroupNo WHERE (JimStockGroup.StockNo = JimStock.StockNo) AND JimStockGroups.RLevel > 0) AS Categories,(SELECT COUNT(JimStockGroups.StockGroupNo) FROM JimStockGroups INNER JOIN JimStockGroup ON JimStockGroups.StockGroupNo = JimStockGroup.StockGroupNo WHERE (JimStockGroup.StockNo = JimStock.StockNo) AND (JimStockGroups.StockGroupNo = 373) ) AS ForwardOrder ,(SELECT COUNT(JimStockGroups.StockGroupNo) FROM JimStockGroups INNER JOIN JimStockGroup ON JimStockGroups.StockGroupNo = JimStockGroup.StockGroupNo WHERE (JimStockGroup.StockNo = JimStock.StockNo) AND (JimStockGroups.StockGroup='AVAIL_PREORD') AND ( JimStockGroups.StockGroup LIKE '%AVAIL_%_%') ) AS PreOrder FROM JimStock WHERE (JimStock.StockNo = ?) AND JimStock.StockNo > 0) DATA WHERE (((OnHand > 0) OR (OnOrder > 0 AND GLGroupNo=2)) OR (ForwardOrder > 0) OR (PreOrder > 0)) AND Categories > 0 ORDER BY StockDesc
All Brands Catalogue ::
All Brands Toys Pty Ltd
25 Gassman Drive, Yatala, QLD 4207
Australia, ABN 84138039586
Call Kirsty
(07) 3287 1000

Stock Code
Pack Size
Price Login to view prices.
Categories Animals, Art & Craft, Crayola, Boys, Batman, Caterpillar, General, Hot Wheels, Matchbox, Road Rippers, Spiderman, Thomas & Friends, Tonka, Construction, Meccano, Games, Girls, Barbie, Disney Princess, Baby Born, General, My Little Pony, Infant & Preschool, Educational, Fisher Price, General, Toy Story, Jigsaw Puzzles, Radio Control, Science/Nature, Sports & Outdoor, Specials, WEB_Best Sellers, General, Little Tikes, Peppa Pig, Little Learner, John Deere, Disney Cars, Bunnykins, Guns/Swords, Playdoh, Dolls/Dolls Accessories, Minnie Mouse, AVAIL_PREORD, Bosch, NOT FOR WEBSITE, Shopkins, G&R WILLS ONLY, Disney Frozen, General, Little Live Pets, General, Mega Bloks, VTech, BLC International Only, Star Wars, Avengers, KIDSTUFF ONLY, Paw Patrol, Pacific Optics Only, Featured_Product, Qixels, ZURU Hamsters in a House, XSHOT Water Blasters, Num Noms, My Fairy Garden, ZURU Micro Boats, Beados, Ooshies, Wild Science, The Grossery Gang, Fur-Real, LeapFrog, Ty Beanies, INACTIVE STOCK, Bunch O Balloons, Dress Up & Role Play, Novelty, 2017 Imports, Air-Hogs, Powerpuff Girls, Etch A Sketch, Zoomer, Hatchimals, Royal Breeds, Nature Explorer, AVAIL_2017_09, AVAIL_2017_10, LEGO, General, TRANSPORT HERITAGE ONLY, Justice League, Bob The Builder, AVAIL_2017_11, AVAIL_2017_12, 2017 Christmas Catalogue, WWE, Transformers, Beyblade Burst, Nerf, Despicable Me, Doc McStuffins, PJ Masks, Oonies, Sesame St, Ben 10, MR TOYS ONLY, Spy Gear, Tech Deck, Super Wings, Kinetic Sand, ZURU Fidget, XSHOT Dart Blasters, Pokemon, Glimmies, Care Bears, Fireman Sam, Water Play - Intex,WAHU,Beach, LOL Surprise, Jo Jo Siwa, AVAIL_2018_01, AVAIL_2018_02, AVAIL_2018_03, AVAIL_2018_04, Turning Mecard, Cabbage Patch Kids, Pikmi Pops, 2018 Imports, HART SPORT ONLY

People who ordered this also ordered: