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 = '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 like 'AVAIL_2014_%') ) 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 - Beach/Pool Toys, Boys, Batman, Caterpillar, Disney Cars, General, Nerf Guns, Hot Wheels, Matchbox, Road Rippers, Spiderman, Star Wars, Thomas & Friends, Tonka, Transformers, Construction, Meccano, Dress Up & Role Play, Games, General, Girls, Barbie, Disney Princess, Baby Born, Fur Real, General, Littlest Pet Shop, My Little Pony, Strollers & Prams, Infant & Preschool, Educational, Fisher Price, General, Playskool, Toy Story, Jigsaw Puzzles, Novelty, Radio Control, Science/Nature, Sports & Outdoor, Wheel Toys/Ride Ons, Specials, WEB_Best Sellers, WEB_Hot Stuffs Coming In, Campaign Incentives ONLY, WEB_Whats New, Dinosaur Train, Monster High, General, Playgro, Ausini Blocks, Schylling Tin Toys, Style Me Up, Geleez, Lamaze, Giggle & Hoot, Little Tikes, Shuffle, Fireman Sam, Peppa Pig, Trash Pack, Lalaloopsy, Octonauts, Teenage Mutant Ninja Turtles, Little Learner, Plush Toys, General, TY Beanies, General, Disney Planes, 2014 KIDSTUFF ONLY, John Deere, Model Kits, Disney Cars, Disney Fairies, The Wiggles, Bunnykins, Guns/Swords, Mighty Wheels, Blingles, Playdoh, Doc McStuffins, Horse Play, Dolls/Dolls Accessories, Iron Man, Huntsman, Micro Chargers, Zelfs, Despicable Me, Minnie Mouse, 2014 Imports, AVAIL_2014_02, AVAIL_2014_PREORD, WEB_Clearance, AVAIL_2014_01, AVAIL_2014_03, AVAIL_2014_04, AVAIL_2014_05, AVAIL_2014_06, AVAIL_2014_07, AVAIL_2014_08, AVAIL_2014_09, AVAIL_2014_10, AVAIL_2014_11, AVAIL_2014_12, AVAIL_2014_FWDORD, Pillow Pets, Air Hogs, Power Rangers, Spy, Nerf Rebelle, Bosch, Catalogue, NOT FOR WEBSITE, Shopkins, G&R WILLS ONLY, GoldieBlox, Lite Brix, 2014 Mid Year Catalogue, Halloween 2014, Halloween 2014, 2014 Spring Catalogue, General, Leapfrog

People who ordered this also ordered: