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, Water Play, Boys, Batman, Caterpillar, General, Nerf Guns, Hot Wheels, Matchbox, Road Rippers, Spiderman, Thomas & Friends, Tonka, Construction, Meccano, Games, General, 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, Wheel Toys/Ride Ons, Specials, WEB_Best Sellers, Campaign Incentives ONLY, WEB_Whats New, General, Little Tikes, Shuffle, Peppa Pig, Little Learner, General, John Deere, Disney Cars, The Wiggles, Bunnykins, Guns/Swords, Playdoh, Dolls/Dolls Accessories, Zelfs, Minnie Mouse, AVAIL_PREORD, Bosch, NOT FOR WEBSITE, Shopkins, G&R WILLS ONLY, 2016 Mid Year Catalogue, 2016 Spring Catalogue, Fun Factory, General, Reading Books, Sydney Attractions Only, Disney Frozen, General, 2015 Imports, Little Live Pets, The Corps, Chalkie, General, Mega Bloks, VTech, BLC International Only, 2016 Easter Catalogue, 2016 Xmas Catalogue, Star Wars, Avengers, KIDSTUFF ONLY, Paw Patrol, CLARK RUBBER ONLY, Pacific Optics Only, Featured_Product, Minecraft, SOLD OUT - NO MORE AVAILABLE, General, Yvolution, Qixels, Steel Roder, 2016 Imports, Yokai, Finding Dory, ZURU Hamsters in a House, XSHOT Water Blasters, XSHOT Dart Blasters, Num Noms, Disney Tsum Tsum, AVAIL_2016_09, AVAIL_2016_10, AVAIL_2016_11, Lego, DC Superhero, My Fairy Garden, Poppit, Teletubbies, ZURU Micro Boats, Beados, Ooshies, Wild Science, Pool Toys Online ONLY, Toys For All ONLY, Games N Puzzles ONLY, The Grossery Gang, Twozies, Betty Spaghetty, Trolls, Fur-Real, LeapFrog, Secret Life of Pets, Ty Beanies, INACTIVE STOCK, Shimmer and Shine, Bunch O Balloons, AVAIL_2017_01, AVAIL_2017_02, AVAIL_2017_03, AVAIL_2017_04, AVAIL_2016_12, Dress Up & Role Play, Novelty, Shopkins Happy Places, 2017 Imports

People who ordered this also ordered: