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, Megabloks, Dress Up & Role Play, Games, General, Girls, Barbie, Disney Princess, Baby Born, Dora the Explorer, Fur Real, General, Littlest Pet Shop, My Little Pony, Strollers & Prams, Infant & Preschool, Bath Toys, Educational, Fisher Price, General, Playskool, Sesame Street, Toy Story, Winnie the Pooh, Jigsaw Puzzles, Musical Instruments, 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, Zoob, Monster High, General, Playgro, Avengers, Ausini Blocks, Schylling Tin Toys, Moshi Monsters, Colour Freedom, Style Me Up, Jake & The Neverland Pirates, Geleez, Lamaze, Giggle & Hoot, Little Tikes, Shuffle, Scooby Doo, Fireman Sam, Peppa Pig, Bruder, Trash Pack, Lalaloopsy, Octonauts, Teenage Mutant Ninja Turtles, 2013 Imports, Little Learner, 2013 Xmas Catalogue ONLY, Plush Toys, Baby World, Pokemon, Creativity For Kids, General, One Direction, TY Beanies, General, Max Steel, Disney Planes, 2014 KIDSTUFF ONLY, Card Games, Kenworth Trucks, Majorette, John Deere, Model Kits, Bananas In Pyjamas, Disney Cars, Disney Fairies, The Wiggles, Bunnykins, Guns/Swords, Mighty Wheels, Blingles, Playdoh, Sticky Mosaics, Doc McStuffins, Monsters University, Horse Play, Dolls/Dolls Accessories, 2013 Spring CAT, Iron Man, Huntsman, Micro Chargers, The Corps, Workman, Zelfs, Paint & Accessories, Despicable Me, M.A.R.S. Robots, 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, Ben 10, Power Rangers, Spy, Captain America, Nerf Rebelle, Bosch, Catalogue, NOT FOR WEBSITE, Shopkins, G&R WILLS ONLY, GoldieBlox, Lite Brix

People who ordered this also ordered: