This second edition of the book includes all SQL scripts.This book is based on my experiences as a consultant over a period of thirteen years, working first for Oracle for four years, and then as a private consultant. I worked across three fields – Manufacturing, Supply Chain and Finance, being the only consultant I ever knew who was given both titles – Manufacturing and Financials Consultant – on different sites. This book should be of interest to all new consultants, to experienced consultants working outside of their specialised area, and to tech-savvy users who wish to create their own queries.The essays in this book are largely designed to cover the more complex areas of the system, including multi-step transactions such as intercompany and internal sales orders, outside processing and consignment stock. They also cover procedures which may be needed in every factory – how to check stock (physical inventory and cycle count), or how to investigate stock losses. The SQL scripts to give easy-to-use reports which can be downloaded into Excel. So many Oracle reports are difficult to use, especially where there is a lot of data. The SQL scripts also deal with the kind of problems which occur after a site has gone live, such as clearing up ahead of the inventory monthend. Again, some queries, notably in BOM and Routing, are there to validate data – for example to find finished goods with no BOM or route.
Populaire auteurs
Cram101 Textbook Reviews (948) J.S. Bach (447) Wolfgang Amadeus Mozart (305) Collectif (268) Schrijf als eerste een recensie over dit item (259) Doug Gelbert (238) Princess of Patterns (211) Charles Dickens (209) R.B. Grimm (197) Carolyn Keene (187) Jules Verne (183) Philipp Winterberg (180) William Shakespeare (174) Youscribe (172) Lucas Nicolato (169) Edgar Allan Poe (166) Herman Melville (166) Anonymous (165) Gilad Soffer (164) Robert Louis Stevenson (159)Populaire gewichtsboeken
418 KB 425 KB 435 KB 459 KB 445 KB 439 KB 386 KB 413 KB 493 KB 432 KB 455 KB 471 KB 421 KB 451 KB 485 KB 472 KB 416 KB 369 KB 419 KB 427 KB