<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:blogger='http://schemas.google.com/blogger/2008' xmlns:georss='http://www.georss.org/georss' xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-4637354759159188895</id><updated>2023-11-16T11:33:21.313-05:00</updated><category term="F4105"/><category term="F30026"/><category term="F3111"/><category term="F3112"/><category term="F4102"/><category term="F41021"/><category term="F4801"/><category term="Fiscal Period"/><category term="Purchase Order EOne JDE"/><title type='text'>JD Edwards EnterpriseOne</title><subtitle type='html'></subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://jdekumar.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default?redirect=false'/><link rel='alternate' type='text/html' href='http://jdekumar.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><link rel='next' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default?start-index=26&amp;max-results=25&amp;redirect=false'/><author><name>Sampath Vuluvala</name><uri>http://www.blogger.com/profile/14637292411768534520</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>81</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-4637354759159188895.post-3559233002981209099</id><published>2023-08-21T10:23:00.005-04:00</published><updated>2023-08-21T10:26:52.388-04:00</updated><title type='text'>New Deals!</title><content type='html'>&lt;p&gt;&amp;nbsp;https://www.amazon.com/gp/product/B0B874CNFW/ref=ppx_yo_dt_b_asin_title_o00_s00?ie=UTF8&amp;amp;amp;th=1&amp;amp;_encoding=UTF8&amp;amp;tag=samdeals0a-20&amp;amp;linkCode=ur2&amp;amp;linkId=4e09b26585c482261b10b786ff72fbd7&amp;amp;camp=1789&amp;amp;creative=9325&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;&amp;lt;a target=&quot;_blank&quot; href=&quot;https://www.amazon.com/Premium-Stainless-Steel-Pepper-Grinder/dp/B09SVMXBYC/ref=zg_bsms_c_kitchen_sccl_7/136-9225689-8945458?pd_rd_w=0872w&amp;amp;amp;content-id=amzn1.sym.309d45c5-3eba-4f62-9bb2-0acdcf0662e7&amp;amp;amp;pf_rd_p=309d45c5-3eba-4f62-9bb2-0acdcf0662e7&amp;amp;amp;pf_rd_r=G7RMXD4WCGZ1N6KQV4PS&amp;amp;amp;pd_rd_wg=bS34F&amp;amp;amp;pd_rd_r=c7fe1775-5c32-442d-a281-8d7d68e2d6ee&amp;amp;amp;pd_rd_i=B09SVMXBYC&amp;amp;amp;psc=1&amp;amp;_encoding=UTF8&amp;amp;tag=samdeals0a-20&amp;amp;linkCode=ur2&amp;amp;linkId=a4ff3e68eefc3936870a0458ea310f15&amp;amp;camp=1789&amp;amp;creative=9325&quot;&amp;gt;Premium Salt and Pepper Grinder Set of 2&amp;lt;/a&amp;gt;&lt;/p&gt;</content><link rel='replies' type='application/atom+xml' href='http://jdekumar.blogspot.com/feeds/3559233002981209099/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://jdekumar.blogspot.com/2023/08/new-deals.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/3559233002981209099'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/3559233002981209099'/><link rel='alternate' type='text/html' href='http://jdekumar.blogspot.com/2023/08/new-deals.html' title='New Deals!'/><author><name>Sampath Vuluvala</name><uri>http://www.blogger.com/profile/14637292411768534520</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4637354759159188895.post-2816103248583544781</id><published>2019-09-27T10:55:00.001-04:00</published><updated>2020-02-08T20:23:28.160-05:00</updated><title type='text'>More about going Solar!</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;b&gt;&lt;br /&gt;&lt;/b&gt;
&lt;b&gt;FAQs&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;&lt;br /&gt;&lt;/b&gt;
&lt;b&gt;How much will my solar panels cost?&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;Every household has different needs when it comes to energy consumption. Customized solutions, these solar energy systems are designed for your homes’ individual requirements, which will be determined by your savings goal and our team of solar home specialist’s recommendations. Contact me for free, no-hassle quotes to give you a better idea of an exact price. We have a special refferal fee for each in house appointment.&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;&lt;br /&gt;&lt;/b&gt;
&lt;b&gt;Solar energy works – but who can afford it?&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;Solar energy used to be pricy, but with advances in technology and the growth of the industry, as well as with with state and federal incentives and innovative financing programs, solar is not only a much more affordable energy option, it actually pays for itself through savings and the additional income your system will generate for you.&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;&lt;br /&gt;&lt;/b&gt;
&lt;b&gt;Do solar panels work at night and on cloudy days?&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;It doesn’t have to be completely sunny for your panels to produce electricity. In cloudy or overcast weather, your panel production won’t be 100%, but they will still be producing power. Typically, winter months can produce the same or more power per day because the position of the sun. Solar panels can handle some pretty tough weather. Solar panels are guaranteed to withstand one-inch hail at 55 miles per hour and are also built to withstand direct lightning strikes.&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;&lt;br /&gt;&lt;/b&gt;
&lt;b&gt;Will a solar electric system produce enough energy to cover all my electricity needs?&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;Certainly! I have had almost zero ($0) electric bill with the benefits of net metering. Having said that, on average, most homeowners and businesses decrease their annual energy costs by&amp;nbsp; 25-50%. With utility costs climbing each year, solar energy can tremendously generate savings over the next 20 years and protect you from the inevitable hikes in energy prices.&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;&lt;br /&gt;&lt;/b&gt;
&lt;b&gt;Do I need to replace my roof before installing solar?&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;No. You are not required to replace your roof. Our experts will determine if your roof is in good condition. If you know your roof needs maintenance in the near term or we determine so, it would be in your best interest to complete the repair or install the new roof before the solar panels. Otherwise, it would be costly to remove the panels to repair the roof and then re-install the panels.&amp;nbsp;&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;Solar panels will shade that area of the roof from harmful ultraviolet sunlight and also protect your roof from the elements. Solar panels generally weigh 2.5lbs./sq.ft., about the same as a second layer of shingles.&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;&lt;br /&gt;&lt;/b&gt;
&lt;b&gt;How long will my solar power system last?&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;We take care of you. The solar panel warranty is 25 years. Panels are projected to continue to work for up to 50 years, with some loss in efficiency. The inverter warranty averages from 15-20 years, depending on the type needed for your installation.&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;&lt;br /&gt;&lt;/b&gt;
&lt;b&gt;How does Net Metering work?&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;When the solar panels are installed and your utility installs the Net Meter, you begin producing power. Net Metering is the system that utilities use to credit solar energy system owners for the electricity produced by their solar panels. You only pay for the electricity that you use beyond what your solar panels can generate. Any excess power your home doesn’t use will be sent back to your utility company. Your electric meter will run backwards. You will feed excess energy to the utility company during the day and then receive it back during the nighttime, at no cost. Net Metering differs from state to state and differs between utilities. Make sure you ask about your specific area.&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;&lt;br /&gt;&lt;/b&gt;
&lt;b&gt;What happens if the power goes out?&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;For safety reasons, your home solar power system will automatically shut off if the power goes out. This is to protect utility workers who might be working on power lines in the event of an outage. It is not safe to send power out to the grid where workers are attempting to fix a power outage problem. You will not have power during this time unless you were to have a battery backup system installed to support a small portion of your home’s electricity needs.&lt;/b&gt;&lt;br /&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;b&gt;&lt;br /&gt;&lt;/b&gt;
&lt;b&gt;Visit for the following link for more info&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;&lt;br /&gt;&lt;/b&gt;
&lt;b&gt;Tax Credit:&lt;/b&gt;&lt;br /&gt;
&lt;a href=&quot;https://recsolar.com/blogs/how-to-calculate-the-30-federal-investment-tax-credit-for-solar/&quot;&gt;https://recsolar.com/blogs/how-to-calculate-the-30-federal-investment-tax-credit-for-solar/&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
SREC:&lt;br /&gt;
&lt;a href=&quot;https://recsolar.com/blogs/solar-finance-101-whats-an-srec-and-how-much-is-it-worth/&quot;&gt;https://recsolar.com/blogs/solar-finance-101-whats-an-srec-and-how-much-is-it-worth/&lt;/a&gt;&lt;br /&gt;
&lt;a href=&quot;http://www.ncsl.org/research/energy/renewable-portfolio-standards.aspx&quot;&gt;http://www.ncsl.org/research/energy/renewable-portfolio-standards.aspx&lt;/a&gt;&lt;br /&gt;
&lt;b&gt;&lt;br /&gt;&lt;/b&gt;
&lt;b&gt;Net Metering:&lt;/b&gt;&lt;br /&gt;
&lt;a href=&quot;https://www.seia.org/initiatives/net-metering&quot;&gt;https://www.seia.org/initiatives/net-metering&lt;/a&gt;&lt;br /&gt;
https://www.youtube.com/watch?v=JlePd31gbEE&lt;br /&gt;
&lt;br /&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://jdekumar.blogspot.com/feeds/2816103248583544781/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://jdekumar.blogspot.com/2019/09/more-about-going-solar.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/2816103248583544781'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/2816103248583544781'/><link rel='alternate' type='text/html' href='http://jdekumar.blogspot.com/2019/09/more-about-going-solar.html' title='More about going Solar!'/><author><name>Sampath Vuluvala</name><uri>http://www.blogger.com/profile/14637292411768534520</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4637354759159188895.post-4618568110640563121</id><published>2019-09-27T10:38:00.000-04:00</published><updated>2019-09-27T10:43:18.912-04:00</updated><title type='text'>My Solar Production Updates</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;img height=&quot;400&quot; src=&quot;https://scontent-atl3-1.xx.fbcdn.net/v/t1.0-9/70717383_10218848081608384_2965647855299067904_n.jpg?_nc_cat=111&amp;amp;_nc_oc=AQmj5IiAiJ6Hib8lbR3nRejmwmM3ibQUjxjYKGXGo8LKvddBTbdJX07gypGC9EIqmK4&amp;amp;_nc_ht=scontent-atl3-1.xx&amp;amp;oh=f335b72bf0086305b0ab5ff4bbea52ca&amp;amp;oe=5DFF0422&quot; width=&quot;368&quot; /&gt;&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjsKEPCLoe45wJO-5clkPxPM6F_fvpR5nrV0cg9ki9jsMiPmKKNxMt1L-loCMQk6TLIbYgZGONC3G_rjTOL4OtOdITHywOJGP3Flc_QmGbB6iXhxtiVglpjcjJERrLK-cidAU0X9ajfgdvk/s1600/2019-09-24_15-16-11.png&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; data-original-height=&quot;701&quot; data-original-width=&quot;1158&quot; height=&quot;193&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjsKEPCLoe45wJO-5clkPxPM6F_fvpR5nrV0cg9ki9jsMiPmKKNxMt1L-loCMQk6TLIbYgZGONC3G_rjTOL4OtOdITHywOJGP3Flc_QmGbB6iXhxtiVglpjcjJERrLK-cidAU0X9ajfgdvk/s320/2019-09-24_15-16-11.png&quot; width=&quot;320&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgF-3GUC3T27z1j7fMiPgoacVk77liG-93bTHujk48MrHzeD83jmmavVu-V16MJR1Hi9hw7xEEYML1I16zpv73FUOZ1zz9IiJMjsWhyphenhyphenRPNjr1jzogKI1R5DrVLbdrfTYofeWFyHTKJOu1mK/s1600/2019-09-27_9-40-29.png&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; data-original-height=&quot;692&quot; data-original-width=&quot;1156&quot; height=&quot;191&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgF-3GUC3T27z1j7fMiPgoacVk77liG-93bTHujk48MrHzeD83jmmavVu-V16MJR1Hi9hw7xEEYML1I16zpv73FUOZ1zz9IiJMjsWhyphenhyphenRPNjr1jzogKI1R5DrVLbdrfTYofeWFyHTKJOu1mK/s320/2019-09-27_9-40-29.png&quot; width=&quot;320&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://jdekumar.blogspot.com/feeds/4618568110640563121/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://jdekumar.blogspot.com/2019/09/my-solar-production-updates.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/4618568110640563121'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/4618568110640563121'/><link rel='alternate' type='text/html' href='http://jdekumar.blogspot.com/2019/09/my-solar-production-updates.html' title='My Solar Production Updates'/><author><name>Sampath Vuluvala</name><uri>http://www.blogger.com/profile/14637292411768534520</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjsKEPCLoe45wJO-5clkPxPM6F_fvpR5nrV0cg9ki9jsMiPmKKNxMt1L-loCMQk6TLIbYgZGONC3G_rjTOL4OtOdITHywOJGP3Flc_QmGbB6iXhxtiVglpjcjJERrLK-cidAU0X9ajfgdvk/s72-c/2019-09-24_15-16-11.png" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4637354759159188895.post-2804870427332488267</id><published>2019-09-27T10:35:00.003-04:00</published><updated>2019-09-27T10:35:36.777-04:00</updated><title type='text'>Going Solar!</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
I recently went solar. Here are few pictures:&lt;br /&gt;
&lt;br /&gt;
&lt;img src=&quot;https://scontent-atl3-1.xx.fbcdn.net/v/t1.0-9/69822944_10218755380890924_6020914665700196352_n.jpg?_nc_cat=102&amp;amp;_nc_oc=AQns1yitfrpSulgyAq2APb-JjUjK9kKT3DWuGXEpujNY8vZ0O9r3-QOCsUdWJ4LNMz8&amp;amp;_nc_ht=scontent-atl3-1.xx&amp;amp;oh=4644d0cf4f8bb9cdcf68007e37b471e3&amp;amp;oe=5E3BC24B&quot; /&gt;&lt;br /&gt;
&lt;img src=&quot;https://scontent-atl3-1.xx.fbcdn.net/v/t1.0-9/70703408_10218755380970926_5909994133098856448_n.jpg?_nc_cat=110&amp;amp;_nc_oc=AQn4EvOFF1a5v-DZdrvWHxzCzoiMJo6BwxhkH2gE_qJ5soxJADdLyl0XVGHA4ELcjlM&amp;amp;_nc_ht=scontent-atl3-1.xx&amp;amp;oh=14e892bfe1a5b782024e571dfe210083&amp;amp;oe=5DFB17C8&quot; /&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;img src=&quot;https://scontent-atl3-1.xx.fbcdn.net/v/t1.0-9/70029180_10218755380490914_7616125563077394432_n.jpg?_nc_cat=102&amp;amp;_nc_oc=AQkzMVm2PIUyQF3rAustylen0LomlgEhj5JMlI-H6ojKeJibF2kKPT0j67KGug-bUik&amp;amp;_nc_ht=scontent-atl3-1.xx&amp;amp;oh=287a13cea4f80c145a95535fa330bda8&amp;amp;oe=5DF5223B&quot; /&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;img src=&quot;https://scontent-atl3-1.xx.fbcdn.net/v/t1.0-9/69622011_10218755380570916_8125603963937488896_n.jpg?_nc_cat=106&amp;amp;_nc_oc=AQmY_yCTdVobIkdB9sAlOD-d2GN22V1dYN_25FIkobqBuaeR0fyUix4WmZV3h7msGzc&amp;amp;_nc_ht=scontent-atl3-1.xx&amp;amp;oh=27df2f921520b9dc0282512b3e2b22e7&amp;amp;oe=5E3A6B5D&quot; /&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://jdekumar.blogspot.com/feeds/2804870427332488267/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://jdekumar.blogspot.com/2019/09/going-solar.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/2804870427332488267'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/2804870427332488267'/><link rel='alternate' type='text/html' href='http://jdekumar.blogspot.com/2019/09/going-solar.html' title='Going Solar!'/><author><name>Sampath Vuluvala</name><uri>http://www.blogger.com/profile/14637292411768534520</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4637354759159188895.post-7145688629065735153</id><published>2016-08-02T15:06:00.002-04:00</published><updated>2016-08-02T15:06:31.082-04:00</updated><title type='text'>compare as off with cardex for FY 15 transactions</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
-- compare as off with cardex for FY 15 transactions&lt;br /&gt;
SELECT ILITM &quot;Short Item&quot;, ILLITM &quot;Item&quot;, ILMCU &quot;Branch&quot;, ILLOCN &quot;Location&quot;, ILLOTN &quot;Lot Number&quot;, ILGLPT &quot;GL Class&quot;, ibglpt &quot;item gl class&quot;, IMUOM1 &quot;Primary UOM&quot; , ILTRUM &quot;Transaction UOM&quot;,&lt;br /&gt;
SUM(ILTRQT)/100000 &quot;Ledger Qty&quot;, (SUM(ILTRQT)/100000)/(nvl((SELECT umconv/10000000 FROM uspddta.F41002 where umitm = ilitm and umum = imuom1 and umrum = iltrum),1)) &quot;CS Conv&quot;,&lt;br /&gt;
(SELECT &amp;nbsp;( t2.incmqt+t2.innq01+t2.innq02+t2.innq03+t2.innq04+t2.innq05+t2.innq06+t2.innq07+t2.innq08+t2.innq09+t2.innq10+t2.innq11+t2.innq12+t2.innq13) &amp;nbsp;/100000 FROM uspddta.f41112 t2&lt;br /&gt;
WHERE t2.infy = 15 AND t2.inctry = 20 AND t2.indct = &#39;BF&#39; AND t2.initm = ilitm AND t2.inmcu = ilmcu AND t2.inlocn = illocn AND t2.inlotn = illotn AND t2.inglpt = ilglpt ) &quot;As of Qty FY15&quot;&lt;br /&gt;
FROM uspddta.f4111, uspddta.f4101, uspddta.f4102&lt;br /&gt;
WHERE /*ilitm IN(173345) AND*/ imitm = ilitm AND ibitm = ilitm AND ibmcu = ilmcu&lt;br /&gt;
AND ildgl &amp;lt;= 116182 /* ILMCU LIKE &#39; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;B%&#39; &amp;nbsp;/*and illocn = &#39;HOLD&#39;*/&lt;br /&gt;
GROUP BY ILITM, ILLITM, ILMCU, ILLOCN, ILLOTN, ILGLPT,IBGLPT, &amp;nbsp;ILTRUM, IMUOM1;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://jdekumar.blogspot.com/feeds/7145688629065735153/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://jdekumar.blogspot.com/2016/08/compare-as-off-with-cardex-for-fy-15.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/7145688629065735153'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/7145688629065735153'/><link rel='alternate' type='text/html' href='http://jdekumar.blogspot.com/2016/08/compare-as-off-with-cardex-for-fy-15.html' title='compare as off with cardex for FY 15 transactions'/><author><name>Sampath Vuluvala</name><uri>http://www.blogger.com/profile/14637292411768534520</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4637354759159188895.post-8298972674601101102</id><published>2016-03-02T16:29:00.002-05:00</published><updated>2016-03-02T16:29:09.031-05:00</updated><title type='text'>INCORRECT GL CLASS IN ITEM AS OFF</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;br /&gt;
select * from USPDDTA.F41112 where INDCT = &#39;BF&#39; and INFY = 15 and INCTRY = 20 and INMCU like &#39; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; FS%&#39; and&lt;br /&gt;
(INCMQT+INNQ01+INNQ02+INNQ03+INNQ04+INNQ05+INNQ06+INNQ07+INNQ08+INNQ09+INNQ10+INNQ11+INNQ12+INNQ13+innq14) &amp;lt;&amp;gt; 0 and&lt;br /&gt;
not exists (select * from USPDDTA.F4102 where IBITM = INITM and IBMCU = INMCU and IBGLPT = INGLPT)&lt;br /&gt;
and INGLPT not like &#39;FG%&#39;&lt;br /&gt;
and exists (select * from uspddta.F4102 T1 where T1.ibitm = initm and T1.ibmcu = inmcu and T1.ibglpt like &#39;FG%&#39;)&lt;br /&gt;
order by initm, inmcu,inlocn, inlotn, inglpt;&lt;br /&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://jdekumar.blogspot.com/feeds/8298972674601101102/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://jdekumar.blogspot.com/2016/03/incorrect-gl-class-in-item-as-off.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/8298972674601101102'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/8298972674601101102'/><link rel='alternate' type='text/html' href='http://jdekumar.blogspot.com/2016/03/incorrect-gl-class-in-item-as-off.html' title='INCORRECT GL CLASS IN ITEM AS OFF'/><author><name>Sampath Vuluvala</name><uri>http://www.blogger.com/profile/14637292411768534520</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4637354759159188895.post-100472883276752648</id><published>2016-02-03T11:35:00.001-05:00</published><updated>2016-02-03T11:35:42.753-05:00</updated><title type='text'>Last item used - SLOB</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;br /&gt;
&lt;br /&gt;
--Last item used in branch&lt;br /&gt;
select LIMCU &quot;Branch Plant&quot;, TRIM(IBLITM) &quot;Item Number&quot;, (select IMDSC1 from USPDDTA.F4101 where LIITM = IMITM) &quot;Description&quot;,&lt;br /&gt;
IBSRP3 &quot;prod line&quot;, IBGLPT &quot;GL Class&quot;, TRIM(LILOCN) &quot;Location&quot;, TRIM(LILOTN) &quot;Lot Number&quot;,LIPQOH/100000 &quot;Quantity on Hand&quot;,&lt;br /&gt;
TO_DATE(TO_CHAR(IODLEJ+1900000),&#39;YYYYDDD&#39;) &quot;Lot Effectivity Date&quot;, &amp;nbsp;IOLOTS &quot;Lot Status Code&quot;,&lt;br /&gt;
(select TO_DATE(TO_CHAR(max(C2.ILTRDJ)+1900000),&#39;YYYYDDD&#39;) from USPDDTA.F4111 C2&lt;br /&gt;
&amp;nbsp; &amp;nbsp;where C2.ILITM = IBITM and C2.ILMCU = IBMCU and C2.ILDCT in (&#39;IM&#39;, &#39;RI&#39;,&#39;OV&#39;)&lt;br /&gt;
&amp;nbsp; &amp;nbsp;/*and C2.ilmcu in (&#39; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; FSI&#39;, &#39; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; FSO&#39;, &#39; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; FST&#39;, &#39; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; FSX&#39;)*/) &amp;nbsp;&quot;Last Item b/p used Tran Date&quot;&lt;br /&gt;
from USPDDTA.F41021, USPDDTA.F4108, USPDDTA.F4102&lt;br /&gt;
where LIITM = IOITM(+) and LIMCU = IOMCU(+) and LILOTN = IOLOTN(+) and LIITM = IBITM and LIMCU = IBMCU&lt;br /&gt;
and iodlej &amp;lt;=115215 and iodlej &amp;lt;&amp;gt; 0&lt;br /&gt;
and LIPQOH &amp;gt; 0&lt;br /&gt;
and LIMCU in (&#39; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; FSI&#39;, &#39; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; FSO&#39;, &#39; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; FST&#39;, &#39; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; FSX&#39;)&lt;br /&gt;
and not exists (select * from USPDDTA.F4111 C1 where C1.ILITM = LIITM and C1.ILMCU = LIMCU and C1.ILDCT in (&#39;IM&#39;, &#39;RI&#39;,&#39;OV&#39;) and C1.ILTRDJ &amp;gt; 115215)&lt;br /&gt;
order by IBMCU, IBLITM, LILOCN, IOLOTN;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
--Last item used&lt;br /&gt;
select LIMCU &quot;Branch Plant&quot;, TRIM(IBLITM) &quot;Item Number&quot;, (select IMDSC1 from USPDDTA.F4101 where LIITM = IMITM) &quot;Description&quot;,&lt;br /&gt;
IBSRP3 &quot;prod line&quot;, IBGLPT &quot;GL Class&quot;, TRIM(LILOCN) &quot;Location&quot;, TRIM(LILOTN) &quot;Lot Number&quot;,LIPQOH/100000 &quot;Quantity on Hand&quot;,&lt;br /&gt;
TO_DATE(TO_CHAR(IODLEJ+1900000),&#39;YYYYDDD&#39;) &quot;Lot Effectivity Date&quot;, &amp;nbsp;IOLOTS &quot;Lot Status Code&quot;,&lt;br /&gt;
(select TO_DATE(TO_CHAR(max(C2.ILTRDJ)+1900000),&#39;YYYYDDD&#39;) from USPDDTA.F4111 C2&lt;br /&gt;
&amp;nbsp; &amp;nbsp;where C2.ILITM = IBITM and C2.ILDCT in (&#39;IM&#39;, &#39;RI&#39;,&#39;OV&#39;)&lt;br /&gt;
&amp;nbsp; &amp;nbsp;and C2.ilmcu in (&#39; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; FSI&#39;, &#39; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; FSO&#39;, &#39; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; FST&#39;, &#39; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; FSX&#39;)) &amp;nbsp;&quot;Last Item used Tran Date&quot;&lt;br /&gt;
from USPDDTA.F41021, USPDDTA.F4108, USPDDTA.F4102&lt;br /&gt;
where LIITM = IOITM(+) and LIMCU = IOMCU(+) and LILOTN = IOLOTN(+) and LIITM = IBITM and LIMCU = IBMCU&lt;br /&gt;
and iodlej &amp;lt;=115215&lt;br /&gt;
and LIPQOH &amp;gt; 0&lt;br /&gt;
and LIMCU in (&#39; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; FSI&#39;, &#39; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; FSO&#39;, &#39; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; FST&#39;, &#39; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; FSX&#39;)&lt;br /&gt;
and not exists (select * from USPDDTA.F4111 C1 where C1.ILITM = LIITM and C1.ILMCU in (&#39; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; FSI&#39;, &#39; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; FSO&#39;, &#39; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; FST&#39;, &#39; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; FSX&#39;) and C1.ILDCT in (&#39;IM&#39;, &#39;RI&#39;,&#39;OV&#39;) and C1.ILTRDJ &amp;gt; 115215)&lt;br /&gt;
order by IBMCU, IBLITM, LILOCN, IOLOTN;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://jdekumar.blogspot.com/feeds/100472883276752648/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://jdekumar.blogspot.com/2016/02/last-item-used-slob.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/100472883276752648'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/100472883276752648'/><link rel='alternate' type='text/html' href='http://jdekumar.blogspot.com/2016/02/last-item-used-slob.html' title='Last item used - SLOB'/><author><name>Sampath Vuluvala</name><uri>http://www.blogger.com/profile/14637292411768534520</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4637354759159188895.post-4702910742788685805</id><published>2016-01-26T08:25:00.002-05:00</published><updated>2016-01-26T08:25:39.291-05:00</updated><title type='text'>security table queries</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
SELECT ABALPH, FSOBNM, RLFRROLE, RLTOROLE &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &lt;br /&gt;
FROM sy910.F00950, sy910.F95921, sy910.F0092, PRDNDTA.F0101 &amp;nbsp; &amp;nbsp;&lt;br /&gt;
WHERE FSOBNM = &#39;P3006&#39; AND &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp;FSUSER = RLFRROLE AND&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp;RLTOROLE &amp;nbsp;= ULUSER AND &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp;ULAN8 = ABAN8 ;&lt;br /&gt;
&lt;br /&gt;
SELECT&lt;br /&gt;
&amp;nbsp; sy910.F95921.RLTOROLE &quot;USER&quot;,&lt;br /&gt;
&amp;nbsp; sy910.F95921.RLFRROLE &quot;ROLE&quot;,&lt;br /&gt;
&amp;nbsp; sy910.F95921.RLEFFDATE,&lt;br /&gt;
&amp;nbsp; sy910.F95921.RLEXPIRDATE,&lt;br /&gt;
&amp;nbsp; sy910.F00950.fssety,&lt;br /&gt;
&amp;nbsp; sy910.F00950.FSOBNM,&lt;br /&gt;
&amp;nbsp; trim(sy910.F00950.fsfrdv) &quot;version&quot;,&lt;br /&gt;
&amp;nbsp; sy910.F00950.fssy,&lt;br /&gt;
&amp;nbsp; sy910.F00950.fsfmnm,&lt;br /&gt;
&amp;nbsp; sy910.F00950.fsinsl,&lt;br /&gt;
&amp;nbsp; sy910.F00950.fsrun,&lt;br /&gt;
&amp;nbsp; sy910.F00950.FSVWYN,&lt;br /&gt;
&amp;nbsp; sy910.F00950.FSA &quot;Add&quot;,&lt;br /&gt;
&amp;nbsp; sy910.F00950.FSCHNG &quot;Change&quot;,&lt;br /&gt;
&amp;nbsp; sy910.F00950.FSDLT &quot;Delete&quot;,&lt;br /&gt;
&amp;nbsp; sy910.F00950.FSIOK &quot;OK/Select&quot;,&lt;br /&gt;
&amp;nbsp; sy910.F00950.fsicpy &quot;Copy&quot;,&lt;br /&gt;
&amp;nbsp; sy910.F00950.fsiupt,&lt;br /&gt;
&amp;nbsp; sy910.F00950.fsatn1,&lt;br /&gt;
&amp;nbsp; sy910.F00950.fsatn2,&lt;br /&gt;
&amp;nbsp; sy910.F00950.fsatn3,&lt;br /&gt;
&amp;nbsp; sy910.F95921.RLUPMJ,&lt;br /&gt;
&amp;nbsp; SY910.F95921.RLUPMT,&lt;br /&gt;
&amp;nbsp; TO_DATE(TO_CHAR(sy910.F00950.fsupmj+1900000),&#39;YYYYDDD&#39;)&quot;UPMJ&quot;,&lt;br /&gt;
&amp;nbsp; sy910.F00950.fsupmt,&lt;br /&gt;
&amp;nbsp; sy910.F0093.llll,&lt;br /&gt;
&amp;nbsp; sy910.F0093.llseq&lt;br /&gt;
FROM&lt;br /&gt;
&amp;nbsp; sy910.F95921,&lt;br /&gt;
&amp;nbsp; sy910.F00950,&lt;br /&gt;
&amp;nbsp; sy910.F0093&lt;br /&gt;
WHERE&lt;br /&gt;
&amp;nbsp; sy910.F00950.FSUSER &amp;nbsp; &amp;nbsp; &amp;nbsp; = sy910.F95921.RLFRROLE&lt;br /&gt;
and LLUSER &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;= RLFRROLE&lt;br /&gt;
/*AND sy910.F95921.RLEFFDATE &amp;lt;= 115240&lt;br /&gt;
AND&lt;br /&gt;
&amp;nbsp; (&lt;br /&gt;
&amp;nbsp; &amp;nbsp; sy910.F95921.RLEXPIRDATE &amp;gt;= 115240&lt;br /&gt;
&amp;nbsp; or SY910.F95921.RLEXPIRDATE = 0&lt;br /&gt;
&amp;nbsp; )*/&lt;br /&gt;
and SY910.F0093.LLLL &amp;nbsp; &amp;nbsp; &amp;nbsp; = &#39;JUSPD910&#39;&lt;br /&gt;
and sy910.F95921.RLTOROLE &amp;nbsp;in ( /*&#39;BMANDA01&#39;, &#39;JKAMAR01&#39;,&#39;KYADAP01&#39;, &#39;CSINGA01&#39;,&#39;SVULUV01&#39;, &#39;KBHASK01&#39;, &#39;SKANN01&#39;*/ &#39;MSEEFR01&#39;)&lt;br /&gt;
and SY910.F95921.RLTOROLE not like &#39;STRE%&#39;&lt;br /&gt;
AND SY910.F95921.RLTOROLE NOT LIKE &#39;TEST%&#39;&lt;br /&gt;
/*AND SY910.F95921.RLFRROLE NOT IN(&#39;P:USPROCHG&#39;, &#39;USHRSECURE&#39;)*/&lt;br /&gt;
/*AND SY910.F95921.RLFRROLE IN (&#39;USBTF2SF&#39;, &#39;USBTF2PLN&#39;)*/&lt;br /&gt;
and &amp;nbsp;sy910.F00950.FSOBNM &amp;nbsp;like &#39;%4116%&#39;/* in(&#39;R04431&#39;, &#39;R04431A&#39;, &#39;P48013&#39;)*/&lt;br /&gt;
ORDER BY&lt;br /&gt;
&amp;nbsp; sy910.F95921.RLFRROLE,&lt;br /&gt;
&amp;nbsp; sy910.F00950.FSOBNM,&lt;br /&gt;
&amp;nbsp; sy910.F00950.FSFRDV,&lt;br /&gt;
&amp;nbsp; sy910.F95921.RLTOROLE, sy910.F00950.FSSETY;&lt;br /&gt;
&amp;nbsp;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&amp;nbsp;select * from sy910.f95921 where rltorole in &amp;nbsp;( &#39;BMANDA01&#39;, &#39;JKAMAR01&#39;,&#39;KYADAP01&#39;, &#39;CSINGA01&#39;,&#39;SVULUV01&#39;, &#39;KBHASK01&#39;, &#39;SKANN01&#39;) order by rlfrrole, rltorole;&lt;br /&gt;
&lt;br /&gt;
&amp;nbsp;select * from sy910.F00950 where fsuser = &#39;P:DEV&#39;;&lt;br /&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://jdekumar.blogspot.com/feeds/4702910742788685805/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://jdekumar.blogspot.com/2016/01/security-table-queries.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/4702910742788685805'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/4702910742788685805'/><link rel='alternate' type='text/html' href='http://jdekumar.blogspot.com/2016/01/security-table-queries.html' title='security table queries'/><author><name>Sampath Vuluvala</name><uri>http://www.blogger.com/profile/14637292411768534520</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4637354759159188895.post-8716528550280487718</id><published>2016-01-26T03:59:00.001-05:00</published><updated>2016-01-26T03:59:12.656-05:00</updated><title type='text'>JDE clean up of payment tables when supplier hold code causes orphaned records</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
select * from uspddta.F04571;&lt;br /&gt;
&lt;br /&gt;
select * from uspddta.F04572;&lt;br /&gt;
&lt;br /&gt;
select * from uspddta.F04573;&lt;br /&gt;
&lt;br /&gt;
select * from uspddta.F0411 where rppst = &#39;#&#39;;&lt;br /&gt;
&lt;br /&gt;
UPDATE uspddta.F0411&lt;br /&gt;
SET rppst = &#39;A&#39;&lt;br /&gt;
WHERE&lt;br /&gt;
rppst = &#39;#&#39; and exists(select * from uspddta.F04573 where rpkco = kikco and rpdoc = kidoc and rpdct = kidct and rpsfx = kisfx and kihdc = 27252);&lt;br /&gt;
&lt;br /&gt;
DELETE uspddta.F04573 WHERE kihdc = 27252;&lt;br /&gt;
DELETE uspddta.F04572 WHERE NOT EXISTS (SELECT * FROM uspddta.F04573 WHERE &amp;nbsp;kihdc = kkhdc AND kickc = kkckc);&lt;br /&gt;
&lt;br /&gt;
DELETE uspddta.F04571 where not exists (select * from uspddta.F04572 where &amp;nbsp;kkhdc = khhdc);&lt;br /&gt;
&lt;br /&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://jdekumar.blogspot.com/feeds/8716528550280487718/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://jdekumar.blogspot.com/2016/01/jde-clean-up-of-payment-tables-when.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/8716528550280487718'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/8716528550280487718'/><link rel='alternate' type='text/html' href='http://jdekumar.blogspot.com/2016/01/jde-clean-up-of-payment-tables-when.html' title='JDE clean up of payment tables when supplier hold code causes orphaned records'/><author><name>Sampath Vuluvala</name><uri>http://www.blogger.com/profile/14637292411768534520</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4637354759159188895.post-2171829352606499860</id><published>2016-01-21T09:27:00.004-05:00</published><updated>2016-01-21T09:27:26.164-05:00</updated><title type='text'>simulated not equal to frozen detailed by cost element</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
SELECT ibitm, iblitm, ibaitm, ibmcu, ibstkt,ibacq/100000 &quot;ACQ&quot;, ieledg &quot;LEDG&quot;, iecost &quot;COST&quot;,iexsmc/10000 &quot;SIM NET&quot;, iexscr/10000 &quot;SIM TOT&quot;, iestdc/10000 &quot;FRZ NET&quot;, iecsl/10000 &quot;FRZ TOT&quot;,&lt;br /&gt;
(select COUNCS/10000 from USPDDTA.F4105 where &amp;nbsp;COITM = IBITM&lt;br /&gt;
and COMCU = IBMCU and COLEDG = IELEDG ) &quot;std cost&quot; &amp;nbsp;&lt;br /&gt;
FROM uspddta.F4102,uspddta.F30026 WHERE ibitm = ieitm AND ibmcu = iemmcu AND ieledg in( &#39;07&#39; ,&#39;05&#39;) AND iexscr &amp;lt;&amp;gt; iecsl and ibstkt &amp;lt;&amp;gt; &#39;O&#39;&lt;br /&gt;
ORDER BY ibitm, ibmcu, ieledg, iecost;&lt;br /&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://jdekumar.blogspot.com/feeds/2171829352606499860/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://jdekumar.blogspot.com/2016/01/simulated-not-equal-to-frozen-detailed.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/2171829352606499860'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/2171829352606499860'/><link rel='alternate' type='text/html' href='http://jdekumar.blogspot.com/2016/01/simulated-not-equal-to-frozen-detailed.html' title='simulated not equal to frozen detailed by cost element'/><author><name>Sampath Vuluvala</name><uri>http://www.blogger.com/profile/14637292411768534520</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4637354759159188895.post-2940175473080776256</id><published>2016-01-21T09:27:00.001-05:00</published><updated>2016-01-21T09:27:06.424-05:00</updated><title type='text'>simulated not equal to frozen summarized</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
SELECT ibitm, iblitm, ibaitm, ibmcu, ibstkt,ibacq/100000 &quot;ACQ&quot;,&lt;br /&gt;
(SELECT sum(lipqoh)/100000 FROM uspddta.F41021 LI WHERE LI.LIITM = IBITM AND LI.LIMCU = IBMCU ) &quot;Inv_Onhand&quot;,&lt;br /&gt;
ieledg &quot;Ledger Type&quot;, sum(iexsmc)/10000,sum( iexscr)/10000, sum(iestdc)/10000, sum(iecsl)/10000,&lt;br /&gt;
(SELECT councs/10000 FROM uspddta.F4105 WHERE &amp;nbsp;COITM = ibitm&lt;br /&gt;
AND COMCU = ibmcu and coledg = ieledg ) &quot;std cost&quot;&lt;br /&gt;
from uspddta.F4102,uspddta.F30026&lt;br /&gt;
where IBITM = IEITM and IBMCU = IEMMCU and IELEDG in( &#39;07&#39; ,&#39;05&#39;) and IBSTKT &amp;lt;&amp;gt; &#39;O&#39;&lt;br /&gt;
GROUP BY ibitm, iblitm, ibaitm, ibmcu,ibstkt,ibacq, ieledg&lt;br /&gt;
HAVING (sum(iexscr) &amp;lt;&amp;gt; sum(iecsl) OR sum(iecsl) &amp;lt;&amp;gt; (SELECT councs FROM uspddta.F4105 WHERE &amp;nbsp;COITM = ibitm&lt;br /&gt;
and COMCU = IBMCU and COLEDG = IELEDG )) ;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://jdekumar.blogspot.com/feeds/2940175473080776256/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://jdekumar.blogspot.com/2016/01/simulated-not-equal-to-frozen-summarized.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/2940175473080776256'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/2940175473080776256'/><link rel='alternate' type='text/html' href='http://jdekumar.blogspot.com/2016/01/simulated-not-equal-to-frozen-summarized.html' title='simulated not equal to frozen summarized'/><author><name>Sampath Vuluvala</name><uri>http://www.blogger.com/profile/14637292411768534520</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4637354759159188895.post-3007439169004058919</id><published>2016-01-21T09:26:00.001-05:00</published><updated>2016-01-21T09:26:30.217-05:00</updated><title type='text'>Compare costs between Master Branch plant (KWP) Vs other branch plants</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
SELECT IB.ibitm, IB.iblitm, IB.ibaitm, IB.ibmcu,&lt;br /&gt;
IE1.ieledg,&lt;br /&gt;
sum( IE1.iexscr)/10000 &quot;Simulated Cost&quot;,&lt;br /&gt;
(select sum(IE3.iexscr)/10000 &amp;nbsp;from uspddta.F30026 IE3 where IE3.IEITM = IE1.IEITM AND IE3.IEledg = IE1.ieledg and IE3.IEMMCU = &#39; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; KWP&#39;) &quot;Simulated_Cost_KWP&quot;,&lt;br /&gt;
sum(IE1.iecsl)/10000 &quot;Frozen_Cost&quot;,&lt;br /&gt;
(select sum(IE2.iecsl)/10000 &amp;nbsp;from uspddta.F30026 IE2 where IE2.IEITM = IE1.IEITM AND IE2.IEledg = IE1.ieledg and IE2.IEMMCU = &#39; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; KWP&#39;) &quot;Frozen_Cost_KWP&quot;,&lt;br /&gt;
(SELECT CO1.councs/10000 FROM uspddta.F4105 CO1 WHERE &amp;nbsp;CO1.COITM = IB.ibitm&lt;br /&gt;
AND CO1.COMCU = IB.ibmcu AND CO1.coledg = IE1.ieledg ) &quot;std cost&quot; ,&lt;br /&gt;
(SELECT CO2.councs/10000 FROM uspddta.F4105 CO2 WHERE &amp;nbsp;CO2.COITM = IB.ibitm&lt;br /&gt;
AND CO2.COMCU = &#39; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; KWP&#39; AND CO2.coledg = IE1.ieledg ) &quot;Std_Cost_KWP&quot; ,&lt;br /&gt;
(select sum(lipqoh)/100000 from uspddta.F41021 LI where LI.LIITM = IB.IBITM and LI.LIMCU = IB.IBMCU ) &quot;Inv_Onhand&quot;&lt;br /&gt;
FROM uspddta.F4102 IB,uspddta.F30026 IE1&lt;br /&gt;
WHERE IB.ibitm = IE1.ieitm AND IB.ibmcu = IE1.iemmcu AND IE1.ieledg in(&#39;99&#39;, &#39;07&#39; )&lt;br /&gt;
AND IB.IBLITM LIKE &#39;8%&#39; &amp;nbsp;and IBLITM not like &#39;8I%&#39;&lt;br /&gt;
and IB.IBMCU &amp;lt;&amp;gt; &amp;nbsp;&#39; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; KWP&#39;&lt;br /&gt;
GROUP BY IB.ibitm,IE1.IEITM, IB.iblitm, IB.ibaitm, IB.ibmcu, IE1.ieledg&lt;br /&gt;
ORder BY IB.ibitm,IE1.IEITM, IB.iblitm, IB.ibaitm, IB.ibmcu, IE1.ieledg;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://jdekumar.blogspot.com/feeds/3007439169004058919/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://jdekumar.blogspot.com/2016/01/compare-costs-between-master-branch.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/3007439169004058919'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/3007439169004058919'/><link rel='alternate' type='text/html' href='http://jdekumar.blogspot.com/2016/01/compare-costs-between-master-branch.html' title='Compare costs between Master Branch plant (KWP) Vs other branch plants'/><author><name>Sampath Vuluvala</name><uri>http://www.blogger.com/profile/14637292411768534520</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4637354759159188895.post-6711022395356592625</id><published>2012-12-18T15:11:00.002-05:00</published><updated>2012-12-18T15:11:29.625-05:00</updated><title type='text'>Standard Cost Restatement Inv On Hand  - F30026 Vs F4105 07 Vs FY </title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;br /&gt;
SELECT IBITM,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;IBLITM,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;IBAITM,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;IBMCU,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;IBGLPT,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;LIGLPT,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;SUM(LIPQOH) / 1000,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;NVL((SELECT SUM(IECSL) / 10000&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;FROM PRODDTA.F30026&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; WHERE IBITM = IEITM&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; AND IBMCU = IEMMCU&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; AND IELEDG = &#39;07&#39;&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; AND IELOCN = &#39; &#39;&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; AND IELOTN = &#39; &#39;),&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;0) &quot;F30026_07_COST&quot;,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;NVL((SELECT SUM(IECSL) / 10000&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;FROM PRODDTA.F30026&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; WHERE IBITM = IEITM&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; AND IBMCU = IEMMCU&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; AND IELEDG = &#39;FY&#39;&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; AND IELOCN = &#39; &#39;&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; AND IELOTN = &#39; &#39;),&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;0) &quot;F30026_FY_COST&quot;,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;NVL((SELECT SUM(COUNCS) / 10000&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;FROM PRODDTA.F4105&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; WHERE IBITM = COITM&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; AND IBMCU = COMCU&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; AND COLEDG = &#39;07&#39;&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; AND COLOCN = &#39; &#39;&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; AND COLOTN = &#39; &#39;),&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;0) &quot;F4105_07_COST&quot;,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;NVL((SELECT SUM(COUNCS) / 10000&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;FROM PRODDTA.F4105&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; WHERE IBITM = COITM&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; AND IBMCU = COMCU&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; AND COLEDG = &#39;FY&#39;&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; AND COLOCN = &#39; &#39;&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; AND COLOTN = &#39; &#39;),&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;0) &quot;F4105_FY_COST&quot;&lt;br /&gt;
&amp;nbsp; FROM PRODDTA.F4102, PRODDTA.F41021&lt;br /&gt;
&amp;nbsp;WHERE LIPQOH &amp;lt;&amp;gt; 0&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND IBITM = LIITM&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND IBMCU = LIMCU&lt;br /&gt;
&amp;nbsp;GROUP BY IBITM, IBLITM, IBAITM, IBMCU, IBGLPT, LIGLPT&lt;br /&gt;
HAVING SUM(LIPQOH) &amp;lt;&amp;gt; 0;&lt;br /&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://jdekumar.blogspot.com/feeds/6711022395356592625/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://jdekumar.blogspot.com/2012/12/standard-cost-restatement-inv-on-hand.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/6711022395356592625'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/6711022395356592625'/><link rel='alternate' type='text/html' href='http://jdekumar.blogspot.com/2012/12/standard-cost-restatement-inv-on-hand.html' title='Standard Cost Restatement Inv On Hand  - F30026 Vs F4105 07 Vs FY '/><author><name>Sampath Vuluvala</name><uri>http://www.blogger.com/profile/14637292411768534520</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4637354759159188895.post-6889361333611743372</id><published>2012-12-13T11:19:00.001-05:00</published><updated>2012-12-13T11:19:59.467-05:00</updated><title type='text'>Find SID</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;


&lt;span class=&quot;left&quot; style=&quot;font-family: Tahoma; font-size: 10pt;&quot;&gt;select sid, osuser, machine, b.username, b.module, b.process, executions, sql_text&lt;br /&gt;from v$process a, v$session b, v$sqlarea c &lt;br /&gt;where b.sql_address=c.address &lt;br /&gt;and b.status=&#39;ACTIVE&#39; &lt;br /&gt;and b.type not in (&#39;BACKGROUND&#39;) &lt;br /&gt;and b.paddr= a.addr &lt;br /&gt;and a.addr = b.paddr &lt;br /&gt;and b.sql_id = c.sql_id&lt;br /&gt;and  b.process = &#39;&amp;lt;wsj process id&amp;gt;&#39;&lt;/span&gt;&amp;nbsp;&lt;table&gt;
&lt;/table&gt;
&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://jdekumar.blogspot.com/feeds/6889361333611743372/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://jdekumar.blogspot.com/2012/12/find-sid.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/6889361333611743372'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/6889361333611743372'/><link rel='alternate' type='text/html' href='http://jdekumar.blogspot.com/2012/12/find-sid.html' title='Find SID'/><author><name>Sampath Vuluvala</name><uri>http://www.blogger.com/profile/14637292411768534520</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4637354759159188895.post-1045405071459679781</id><published>2012-09-25T13:22:00.001-04:00</published><updated>2012-09-25T13:38:18.052-04:00</updated><title type='text'>Asof Integrity Check with Cardex - AMOUNTs</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;b&gt;&lt;span style=&quot;color: #ff9900; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: #ff9900; font-size: x-small;&quot;&gt; 
SELECT&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;/div&gt;
&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt; INITM,&lt;/span&gt;&lt;/span&gt;INMCU,&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;&lt;span style=&quot;color: #ff9900; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: #ff9900; font-size: x-small;&quot;&gt;SUM&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt;(INCUMA + INAN01 + INAN02 + INAN03 + INAN04 + INAN05 + INAN06 +&lt;/span&gt;&lt;/span&gt;INAN07 + INAN08 + INAN09 + INAN10 + INAN11 + INAN12 + INAN13 +&lt;br /&gt;
INAN14) / &lt;br /&gt;
&lt;b&gt;&lt;i&gt;&lt;span style=&quot;color: #666699; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: #666699; font-size: x-small;&quot;&gt;100&lt;/span&gt;&lt;/span&gt;&lt;/i&gt;&lt;/b&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt; &quot;Asof_Amount&quot;,&lt;/span&gt;&lt;/span&gt;(&lt;br /&gt;
&lt;b&gt;&lt;span style=&quot;color: #ff9900; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: #ff9900; font-size: x-small;&quot;&gt;SELECT&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt; &lt;/span&gt;&lt;/span&gt;&lt;b&gt;&lt;span style=&quot;color: #ff9900; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: #ff9900; font-size: x-small;&quot;&gt;SUM&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt;(ILPAID) / &lt;/span&gt;&lt;/span&gt;&lt;b&gt;&lt;i&gt;&lt;span style=&quot;color: #666699; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: #666699; font-size: x-small;&quot;&gt;100&lt;/span&gt;&lt;/span&gt;&lt;/i&gt;&lt;/b&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt;&lt;/span&gt;&lt;/span&gt;&lt;b&gt;&lt;span style=&quot;color: #ff9900; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: #ff9900; font-size: x-small;&quot;&gt;FROM&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt; PRODDTA.F4111&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;b&gt;&lt;span style=&quot;color: #ff9900; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: #ff9900; font-size: x-small;&quot;&gt;WHERE&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt; INITM = ILITM&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;b&gt;&lt;span style=&quot;color: #ff9900; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: #ff9900; font-size: x-small;&quot;&gt;AND&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt; INMCU = ILMCU&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;b&gt;&lt;span style=&quot;color: #ff9900; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: #ff9900; font-size: x-small;&quot;&gt;AND&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt; ILDGL &amp;gt;= &lt;/span&gt;&lt;/span&gt;&lt;b&gt;&lt;i&gt;&lt;span style=&quot;color: #666699; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: #666699; font-size: x-small;&quot;&gt;112001&lt;/span&gt;&lt;/span&gt;&lt;/i&gt;&lt;/b&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt;&lt;/span&gt;&lt;/span&gt;&lt;b&gt;&lt;span style=&quot;color: #ff9900; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: #ff9900; font-size: x-small;&quot;&gt;AND&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt; ILIPCD = &lt;/span&gt;&lt;/span&gt;&lt;b&gt;&lt;i&gt;&lt;span style=&quot;color: blue; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: blue; font-size: x-small;&quot;&gt;&#39;Y&#39;&lt;/span&gt;&lt;/span&gt;&lt;/i&gt;&lt;/b&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt;&lt;/span&gt;&lt;/span&gt;&lt;b&gt;&lt;span style=&quot;color: #ff9900; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: #ff9900; font-size: x-small;&quot;&gt;GROUP&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt; &lt;/span&gt;&lt;/span&gt;&lt;b&gt;&lt;span style=&quot;color: #ff9900; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: #ff9900; font-size: x-small;&quot;&gt;BY&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt; ILITM, ILMCU) &quot;Cardex_AMT&quot;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;b&gt;&lt;span style=&quot;color: #ff9900; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: #ff9900; font-size: x-small;&quot;&gt;FROM&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt; PRODDTA.F41112&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;b&gt;&lt;span style=&quot;color: #ff9900; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: #ff9900; font-size: x-small;&quot;&gt;WHERE&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt; INITM &lt;/span&gt;&lt;/span&gt;&lt;b&gt;&lt;span style=&quot;color: #ff9900; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: #ff9900; font-size: x-small;&quot;&gt;IN&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt; (&lt;/span&gt;&lt;/span&gt;&lt;b&gt;&lt;i&gt;&lt;span style=&quot;color: #666699; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: #666699; font-size: x-small;&quot;&gt;422012&lt;/span&gt;&lt;/span&gt;&lt;/i&gt;&lt;/b&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt;, &lt;/span&gt;&lt;/span&gt;&lt;b&gt;&lt;i&gt;&lt;span style=&quot;color: #666699; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: #666699; font-size: x-small;&quot;&gt;424742&lt;/span&gt;&lt;/span&gt;&lt;/i&gt;&lt;/b&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt;)&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;b&gt;&lt;span style=&quot;color: #ff9900; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: #ff9900; font-size: x-small;&quot;&gt;AND&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt; INDCT = &lt;/span&gt;&lt;/span&gt;&lt;b&gt;&lt;i&gt;&lt;span style=&quot;color: blue; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: blue; font-size: x-small;&quot;&gt;&#39;BF&#39;&lt;/span&gt;&lt;/span&gt;&lt;/i&gt;&lt;/b&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt;&lt;/span&gt;&lt;/span&gt;&lt;b&gt;&lt;span style=&quot;color: #ff9900; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: #ff9900; font-size: x-small;&quot;&gt;AND&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt; INCTRY = &lt;/span&gt;&lt;/span&gt;&lt;b&gt;&lt;i&gt;&lt;span style=&quot;color: #666699; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: #666699; font-size: x-small;&quot;&gt;20&lt;/span&gt;&lt;/span&gt;&lt;/i&gt;&lt;/b&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt;&lt;/span&gt;&lt;/span&gt;&lt;b&gt;&lt;span style=&quot;color: #ff9900; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: #ff9900; font-size: x-small;&quot;&gt;AND&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt; INFY = &lt;/span&gt;&lt;/span&gt;&lt;b&gt;&lt;i&gt;&lt;span style=&quot;color: #666699; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: #666699; font-size: x-small;&quot;&gt;12&lt;/span&gt;&lt;/span&gt;&lt;/i&gt;&lt;/b&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt;&lt;/span&gt;&lt;/span&gt;&lt;b&gt;&lt;span style=&quot;color: #ff9900; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: #ff9900; font-size: x-small;&quot;&gt;GROUP&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt; &lt;/span&gt;&lt;/span&gt;&lt;b&gt;&lt;span style=&quot;color: #ff9900; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: #ff9900; font-size: x-small;&quot;&gt;BY&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: navy; font-size: x-small;&quot;&gt; INITM, INMCU;&lt;/span&gt;&lt;/span&gt;</content><link rel='replies' type='application/atom+xml' href='http://jdekumar.blogspot.com/feeds/1045405071459679781/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://jdekumar.blogspot.com/2012/09/asof-integrity-check-with-cardex-amounts.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/1045405071459679781'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/1045405071459679781'/><link rel='alternate' type='text/html' href='http://jdekumar.blogspot.com/2012/09/asof-integrity-check-with-cardex-amounts.html' title='Asof Integrity Check with Cardex - AMOUNTs'/><author><name>Sampath Vuluvala</name><uri>http://www.blogger.com/profile/14637292411768534520</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4637354759159188895.post-7735214771602540788</id><published>2012-08-29T07:41:00.000-04:00</published><updated>2012-08-29T07:41:01.790-04:00</updated><title type='text'>SOA with JD Edwards Real Time Events</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;span style=&quot;background-color: white; color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: x-small; line-height: 18px;&quot;&gt;This article provides basic steps to configure a Real time event in JDE and consume in Oracle SOA server.&lt;/span&gt;
&lt;br /&gt;
&lt;span style=&quot;background-color: white; color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: x-small; line-height: 18px;&quot;&gt;&lt;br /&gt;&lt;/span&gt;
&lt;a href=&quot;http://gauravguptax.blogspot.com/2012/08/soa-with-jd-edwards-real-time-events.html?goback=%2Egde_114133_member_154503430&quot;&gt;http://gauravguptax.blogspot.com/2012/08/soa-with-jd-edwards-real-time-events.html?goback=%2Egde_114133_member_154503430&lt;/a&gt;
&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://jdekumar.blogspot.com/feeds/7735214771602540788/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://jdekumar.blogspot.com/2012/08/soa-with-jd-edwards-real-time-events.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/7735214771602540788'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/7735214771602540788'/><link rel='alternate' type='text/html' href='http://jdekumar.blogspot.com/2012/08/soa-with-jd-edwards-real-time-events.html' title='SOA with JD Edwards Real Time Events'/><author><name>Sampath Vuluvala</name><uri>http://www.blogger.com/profile/14637292411768534520</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4637354759159188895.post-8905345697627615769</id><published>2012-08-16T05:44:00.001-04:00</published><updated>2012-08-16T05:45:32.173-04:00</updated><title type='text'>Cost Changes</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
SELECT T0.CMITM,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T0.CMLITM,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T0.CMAITM,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T0.CMMCU,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T0.CMSRCCNTMJ,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T0.CMSRCCNTMI,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T1.IEITM,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T1.IELITM,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T1.IEAITM,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T1.IEMMCU,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T1.IELOCN,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T1.IELOTN,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T1.IELEDG,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T1.IECOST,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T1.IELOTG,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T1.IESTDC,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T1.IEXSMC,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T1.IECSL,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T1.IEXSCR,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T1.IESCTC,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T1.IEXSFC,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T1.IESTFC,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T1.IEXSF,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T1.IERATS,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T1.IEXSRC,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T1.IERTSD,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T1.IEXSR,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T1.IEPFLG,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T1.IEUSER,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T1.IEPID,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T1.IEJOBN,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T1.IEUPMJ,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T1.IETDAY,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T1.IEOPSQ,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T1.IEMCUL,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T1.IEWMCU,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T1.IELDA,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T1.IETBM,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T1.IEACQ,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T1.IEF,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T2.COITM,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T2.COLITM,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T2.COAITM,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T2.COMCU,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T2.COLOCN,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T2.COLOTN,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T2.COLOTG,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T2.COLEDG,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T2.COUNCS,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T2.COCSPO,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T2.COCSIN,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T2.COURCD,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T2.COURDT,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T2.COURAT,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T2.COURAB,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T2.COURRF,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T2.COUSER,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T2.COPID,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T2.COJOBN,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T2.COUPMJ,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T2.COTDAY,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T2.COCCFL,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T2.COCRCS,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T2.COOSTC,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T2.COSTOC,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T3.MCMCU,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T3.MCSTYL,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T3.MCCO&lt;br /&gt;&amp;nbsp; FROM TESTDTA.F554101T T0,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; TESTDTA.F30026&amp;nbsp;&amp;nbsp; T1,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; TESTDTA.F4105&amp;nbsp;&amp;nbsp;&amp;nbsp; T2,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; TESTDTA.F0006&amp;nbsp;&amp;nbsp;&amp;nbsp; T3&lt;br /&gt;&amp;nbsp;WHERE ((T1.IEUPMJ &amp;gt;= 112160 AND T1.IELEDG = &#39;07&#39; AND T1.IECOST = &#39;A1&#39; AND&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T3.MCCO = &#39;00100&#39; OR T3.MCSTYL = &#39;BP&#39; AND T3.MCSTYL = &#39;VP&#39;))&lt;br /&gt;&amp;nbsp;&amp;nbsp; AND (T0.CMITM = T1.IEITM AND T0.CMMCU = T1.IEMMCU AND&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T1.IEITM = T2.COITM AND T1.IEMMCU = T2.COMCU AND&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; T1.IELEDG = T2.COLEDG AND T0.CMMCU = T3.MCMCU)&lt;br /&gt;&amp;nbsp;ORDER BY T2.COITM ASC, T2.COMCU ASC&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://jdekumar.blogspot.com/feeds/8905345697627615769/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://jdekumar.blogspot.com/2012/08/cost-changes.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/8905345697627615769'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/8905345697627615769'/><link rel='alternate' type='text/html' href='http://jdekumar.blogspot.com/2012/08/cost-changes.html' title='Cost Changes'/><author><name>Sampath Vuluvala</name><uri>http://www.blogger.com/profile/14637292411768534520</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4637354759159188895.post-1607442307954951718</id><published>2012-08-08T17:41:00.003-04:00</published><updated>2012-08-09T07:33:54.340-04:00</updated><title type='text'>As of Std Cost vs Item Std Cost</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
SELECT INMCU &quot;BRANCH_PLANT&quot;,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; INLITM &quot;GLOBAL_CODE&quot;,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; INAITM &quot;LEGACY_CODE&quot;,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; (SELECT IMDSC1 FROM PRODDTA.F4101 WHERE INITM = IMITM) &quot;ITEM_DESCRIPTION&quot;,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; INGLPT &quot;GL_CATEGORY&quot;,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; INLOCN &quot;LOCATION&quot;,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; INLOTN &quot;LOT&quot;,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; INNQ08 / 1000 &quot;QUANTITY&quot;,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; INAN08 / 100 &quot;AMOUNT&quot;,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; (INAN08 / 100) / (INNQ08 / 1000) &quot;AS_OF_STD_COST&quot;,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; (SELECT COUNCS / 10000&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; FROM PRODDTA.F4105&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; WHERE INITM = COITM&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; AND INMCU = COMCU&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; AND COLEDG = &#39;07&#39;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; AND COLOCN = &#39; &#39;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; AND COLOTN = &#39; &#39;) &quot;ITEM_STD_COST&quot;&lt;br /&gt;&amp;nbsp; FROM PRODDTA.F41112&lt;br /&gt;&amp;nbsp;WHERE INDCT = &#39;BF&#39;&lt;br /&gt;&amp;nbsp;&amp;nbsp; AND INFY = 12&lt;br /&gt;&amp;nbsp;&amp;nbsp; AND INCTRY = 20&lt;br /&gt;&amp;nbsp;&amp;nbsp; AND INMCU LIKE &#39;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; 205%&#39;&lt;br /&gt;&amp;nbsp;&amp;nbsp; AND INNQ08 &amp;lt;&amp;gt; 0;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://jdekumar.blogspot.com/feeds/1607442307954951718/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://jdekumar.blogspot.com/2012/08/as-of-std-cost-vs-item-std-cost.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/1607442307954951718'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/1607442307954951718'/><link rel='alternate' type='text/html' href='http://jdekumar.blogspot.com/2012/08/as-of-std-cost-vs-item-std-cost.html' title='As of Std Cost vs Item Std Cost'/><author><name>Sampath Vuluvala</name><uri>http://www.blogger.com/profile/14637292411768534520</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4637354759159188895.post-1262252748419819340</id><published>2012-07-18T14:44:00.002-04:00</published><updated>2012-07-18T14:44:48.485-04:00</updated><title type='text'>Transaction Nature &amp; Suffix F7611B Vs F76432 Integrity</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;br /&gt;
SELECT T1.PRITM,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.PRLITM,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.PRMCU,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.PRKCOO,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.PRDOCO,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.PRDCTO,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.PRLNID,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.PRSFXO,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.PRDOC,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.PRDCT,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.PRGLC,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;(SELECT T2.PJBNOP || T2.PJBSOP&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; FROM PRODDTA.F76432 T2&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;WHERE T1.PRDOCO = T2.PJDOCO&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;AND T1.PRDCTO = T2.PJDCTO&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;AND T1.PRLNID = T2.PJLNID&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;AND T1.PRKCOO = T2.PJKCOO&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;AND T1.PRSFXO = T2.PJSFXO) &quot;F76432_Trans_Nat_Sfx&quot;,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;(T3.FDBNOP || T3.FDBSOP) &quot;F7611B_Trans_Nat_Sfx&quot;,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;(SELECT TO_DATE(CONCAT(&#39;20&#39;,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; CONCAT(SUBSTR(TO_CHAR(T1.PRTRDJ), 2, 2),&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;SUBSTR(TO_CHAR(T1.PRTRDJ), 4, 3))),&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&#39;YYYYDDD&#39;)&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; FROM DUAL) AS TRANSACTIONDATE,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;(SELECT TO_DATE(CONCAT(&#39;20&#39;,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; CONCAT(SUBSTR(TO_CHAR(T1.PRDGL), 2, 2),&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;SUBSTR(TO_CHAR(T1.PRDGL), 4, 3))),&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&#39;YYYYDDD&#39;)&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; FROM DUAL) AS GLDATE,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;SUM(T1.PRQTYS / 1000),&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;SUM(T1.PRAREC / 100)&lt;br /&gt;
&amp;nbsp; FROM PRODDTA.F43121 T1, PRODDTA.F7611B T3&lt;br /&gt;
&amp;nbsp;WHERE T1.PRMATC = 1&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND T1.PRDCT = &#39;OV&#39;&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND T1.PRDGL &amp;gt;= 112153&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND T1.PRDGL &amp;lt;= 112182&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND T1.PRDOCO = 138019&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND T1.PRDOCO = T3.FDDOCO&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND T1.PRDCTO = T3.FDPDCT&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND T1.PRKCOO = T3.FDKCOO&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND T1.PRLNID = T3.FDLNID&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND T1.PRSFXO = T3.FDSFXO&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND T1.PRDCT = T3.FDDCTO&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND T1.PRDOC = T3.FDDOC&lt;br /&gt;
&amp;nbsp;GROUP BY T1.PRITM,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; T1.PRLITM,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; T1.PRMCU,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; T1.PRKCOO,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; T1.PRDOCO,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; T1.PRDCTO,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; T1.PRDOC,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; T1.PRDCT,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; T1.PRGLC,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; T1.PRTRDJ,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; T1.PRDGL,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; T1.PRLNID,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; T1.PRSFXO,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; T3.FDBNOP,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; T3.FDBSOP&lt;br /&gt;
&amp;nbsp;ORDER BY T1.PRMCU, T1.PRDOCO, T1.PRDCTO;&lt;br /&gt;
&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://jdekumar.blogspot.com/feeds/1262252748419819340/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://jdekumar.blogspot.com/2012/07/transaction-nature-suffix-f7611b-vs.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/1262252748419819340'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/1262252748419819340'/><link rel='alternate' type='text/html' href='http://jdekumar.blogspot.com/2012/07/transaction-nature-suffix-f7611b-vs.html' title='Transaction Nature &amp; Suffix F7611B Vs F76432 Integrity'/><author><name>Sampath Vuluvala</name><uri>http://www.blogger.com/profile/14637292411768534520</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4637354759159188895.post-4225557659703028595</id><published>2012-07-18T13:27:00.001-04:00</published><updated>2012-07-18T13:27:12.985-04:00</updated><title type='text'>F4111 Vs F30026 broken down by Cost Element</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;br /&gt;
SELECT T0.IBITM,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T0.IBLITM,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T0.IBAITM,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;IM.IMDSC1,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T0.IBMCU,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T0.IBSRP6,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T0.IBPRP5,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T0.IBSTKT,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.ILITM,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.ILMCU,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.ILMMCU,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.ILDOC,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.ILDCT,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.ILDGL,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.ILGLPT,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.ILDCTO,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.ILDOCO,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.ILKCOO,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T3.IECOST,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T3.IECSL / 10000 &quot;H1_Cost&quot;,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.ILUNCS / 10000 &quot;Unit_Cost&quot;,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.ILTRQT / 1000 &quot;Quantity&quot;,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.ILPAID / 100 &quot;Amount&quot;,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.ILUKID,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.ILAID,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.ILAN8,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.ILSHAN&lt;br /&gt;
&amp;nbsp; FROM PRODDTA.F4101 &amp;nbsp;IM,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;PRODDTA.F4102 &amp;nbsp;T0,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;PRODDTA.F4111 &amp;nbsp;T1,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;PRODDTA.F30026 T3&lt;br /&gt;
&amp;nbsp;WHERE T1.ILDCT = &#39;OV&#39;&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND T1.ILDCTO = &#39;ON&#39;&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND T1.ILMCU &amp;lt; &#39; &amp;nbsp; &amp;nbsp; 1000998&#39;&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND T1.ILGLPT &amp;lt;&amp;gt; &#39;IN61&#39;&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND T1.ILTRQT &amp;lt;&amp;gt; 0&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND T1.ILDGL &amp;gt;= 111092&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND T1.ILDGL &amp;lt;= 112092&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND ROWNUM &amp;lt;= 10 --Comment this line if you want all records&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND IM.IMITM = T0.IBITM&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND T0.IBITM = T1.ILITM&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND T0.IBMCU = T1.ILMCU&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND IEITM = T0.IBITM&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND IEMMCU = &#39; &amp;nbsp; &amp;nbsp; 1000999&#39;&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND IELEDG = &#39;H1&#39;&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND IELOCN = &#39; &#39;&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND IELOTN = &#39; &#39;&lt;br /&gt;
&amp;nbsp;ORDER BY T0.IBITM ASC;&lt;br /&gt;
&lt;br /&gt;
&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://jdekumar.blogspot.com/feeds/4225557659703028595/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://jdekumar.blogspot.com/2012/07/f4111-vs-f30026-broken-down-by-cost.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/4225557659703028595'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/4225557659703028595'/><link rel='alternate' type='text/html' href='http://jdekumar.blogspot.com/2012/07/f4111-vs-f30026-broken-down-by-cost.html' title='F4111 Vs F30026 broken down by Cost Element'/><author><name>Sampath Vuluvala</name><uri>http://www.blogger.com/profile/14637292411768534520</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4637354759159188895.post-7817346393564289110</id><published>2012-07-17T07:05:00.001-04:00</published><updated>2012-07-17T07:05:19.995-04:00</updated><title type='text'>Reversals in Current month Vs Receipts in Prior Month</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;br /&gt;
SELECT T1.PRITM,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.PRLITM,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.PRMCU,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.PRDOCO,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.PRDCTO,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.PRLNID,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.PRSFXO,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.PRDOC,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.PRDCT,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.PRGLC,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T2.PJBNOP,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T2.PJBSOP,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;(SELECT TO_DATE(CONCAT(&#39;20&#39;,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; CONCAT(SUBSTR(TO_CHAR(T1.PRTRDJ), 2, 2),&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;SUBSTR(TO_CHAR(T1.PRTRDJ), 4, 3))),&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&#39;YYYYDDD&#39;)&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; FROM DUAL) AS TRANSACTIONDATE,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;(SELECT TO_DATE(CONCAT(&#39;20&#39;,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; CONCAT(SUBSTR(TO_CHAR(T1.PRDGL), 2, 2),&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;SUBSTR(TO_CHAR(T1.PRDGL), 4, 3))),&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&#39;YYYYDDD&#39;)&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; FROM DUAL) AS GLDATE,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;SUM(T1.PRQTYS / 1000),&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;SUM(T1.PRAREC / 100)&lt;br /&gt;
&amp;nbsp; FROM PRODDTA.F43121 T1, PRODDTA.F76432 T2&lt;br /&gt;
&amp;nbsp;WHERE T1.PRMATC = 1&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND T1.PRDCT = &#39;OV&#39;&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND T1.PRDGL &amp;gt;= 112153&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND T1.PRDGL &amp;lt;= 112182&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND T1.PRDOCO = T2.PJDOCO&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND T1.PRDCTO = T2.PJDCTO&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND T1.PRLNID = T2.PJLNID&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND T1.PRDOCO = 138019&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND EXISTS (SELECT &#39;X&#39;&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; FROM PRODDTA.F43121 T3&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;WHERE T1.PRDOCO = T3.PRDOCO&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;AND T1.PRDCTO = T3.PRDCTO&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;AND T1.PRLNID = T3.PRLNID&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;AND T3.PRMATC = 4&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;AND T3.PRDGL &amp;gt;= 112183&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;AND T3.PRDGL &amp;lt;= 112213)&lt;br /&gt;
&amp;nbsp;GROUP BY T1.PRITM,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; T1.PRLITM,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; T1.PRMCU,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; T1.PRDOCO,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; T1.PRDCTO,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; T1.PRDOC,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; T1.PRDCT,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; T1.PRGLC,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; T1.PRTRDJ,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; T1.PRDGL,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; T1.PRLNID,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; T1.PRSFXO,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; T2.PJBNOP,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; T2.PJBSOP&lt;br /&gt;
&amp;nbsp;ORDER BY T1.PRMCU, T1.PRDOCO, T1.PRDCTO;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
SELECT T1.PRITM,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.PRLITM,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.PRMCU,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.PRDOCO,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.PRDCTO,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.PRLNID,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.PRSFXO,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.PRDOC,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.PRDCT,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.PRGLC,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;(SELECT TO_DATE(CONCAT(&#39;20&#39;,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; CONCAT(SUBSTR(TO_CHAR(T1.PRTRDJ), 2, 2),&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;SUBSTR(TO_CHAR(T1.PRTRDJ), 4, 3))),&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&#39;YYYYDDD&#39;)&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; FROM DUAL) AS TRANSACTIONDATE,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;(SELECT TO_DATE(CONCAT(&#39;20&#39;,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; CONCAT(SUBSTR(TO_CHAR(T1.PRDGL), 2, 2),&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;SUBSTR(TO_CHAR(T1.PRDGL), 4, 3))),&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&#39;YYYYDDD&#39;)&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; FROM DUAL) AS GLDATE,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;SUM(T1.PRQTYS / 1000),&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;SUM(T1.PRAREC / 100)&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; FROM PRODDTA.F43121 T1&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;WHERE T1.PRDOCO = 138019&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;AND T1.PRDCTO = &#39;OP&#39;&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;AND T1.PRMATC = 4&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;AND T1.PRDGL &amp;gt;= 112183&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;AND T1.PRDGL &amp;lt;= 112213&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; GROUP BY T1.PRITM,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; T1.PRLITM,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; T1.PRMCU,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; T1.PRDOCO,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; T1.PRDCTO,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; T1.PRDOC,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; T1.PRDCT,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; T1.PRGLC,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; T1.PRTRDJ,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; T1.PRDGL,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; T1.PRLNID,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; T1.PRSFXO;&lt;br /&gt;
&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://jdekumar.blogspot.com/feeds/7817346393564289110/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://jdekumar.blogspot.com/2012/07/reversals-in-current-month-vs-receipts.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/7817346393564289110'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/7817346393564289110'/><link rel='alternate' type='text/html' href='http://jdekumar.blogspot.com/2012/07/reversals-in-current-month-vs-receipts.html' title='Reversals in Current month Vs Receipts in Prior Month'/><author><name>Sampath Vuluvala</name><uri>http://www.blogger.com/profile/14637292411768534520</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4637354759159188895.post-5363366744752027455</id><published>2012-07-17T05:32:00.000-04:00</published><updated>2012-07-17T05:32:02.655-04:00</updated><title type='text'>Compare Cardex Transactions with 07 Vs H1 Costs</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;br /&gt;
SELECT T0.IBITM,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T0.IBLITM,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T0.IBAITM,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T0.IBMCU,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T0.IBSRP6,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T0.IBPRP5,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T0.IBSTKT,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.ILITM,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.ILMCU,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.ILMMCU,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.ILDOC,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.ILDCT,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.ILDGL,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.ILGLPT,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.ILDCTO,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.ILDOCO,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.ILKCOO,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.ILTRQT / 1000,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.ILPAID / 100,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.ILUKID,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.ILAID,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.ILAN8,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.ILSHAN,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;(SELECT SUM(IECSL / 10000)&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; FROM PRODDTA.F30026&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;WHERE IEITM = T0.IBITM&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;AND IEMMCU = &#39; &amp;nbsp; &amp;nbsp; 1000999&#39;&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;AND IELEDG = &#39;07&#39;&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;AND IELOCN = &#39; &#39;&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;AND IELOTN = &#39; &#39;&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;GROUP BY IEITM, IEMMCU, IELEDG, IELOCN, IELOTN) &quot;07_COST&quot;,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;(SELECT SUM(IECSL / 10000)&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; FROM PRODDTA.F30026&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;WHERE IEITM = T0.IBITM&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;AND IEMMCU = &#39; &amp;nbsp; &amp;nbsp; 1000999&#39;&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;AND IELEDG = &#39;H1&#39;&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;AND IELOCN = &#39; &#39;&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;AND IELOTN = &#39; &#39;&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;GROUP BY IEITM, IEMMCU, IELEDG, IELOCN, IELOTN) &quot;H1_COST&quot;&lt;br /&gt;
&amp;nbsp; FROM PRODDTA.F4102 T0, PRODDTA.F4111 T1&lt;br /&gt;
&amp;nbsp;WHERE ((T1.ILDCT = &#39;OV&#39; AND T1.ILDCTO = &#39;ON&#39; AND T1.ILMCU &amp;lt; &#39; &amp;nbsp; &amp;nbsp; 1000998&#39; AND&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;T1.ILGLPT &amp;lt;&amp;gt; &#39;IN61&#39; AND T1.ILTRQT &amp;lt;&amp;gt; 0) AND&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;(T1.ILDGL &amp;gt;= 111092 AND T1.ILDGL &amp;lt;= 112092))&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND ROWNUM &amp;lt;= 10&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND (T0.IBITM = T1.ILITM AND T0.IBMCU = T1.ILMCU)&lt;br /&gt;
&amp;nbsp;ORDER BY T0.IBITM ASC;&lt;br /&gt;
&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://jdekumar.blogspot.com/feeds/5363366744752027455/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://jdekumar.blogspot.com/2012/07/compare-cardex-transactions-with-07-vs.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/5363366744752027455'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/5363366744752027455'/><link rel='alternate' type='text/html' href='http://jdekumar.blogspot.com/2012/07/compare-cardex-transactions-with-07-vs.html' title='Compare Cardex Transactions with 07 Vs H1 Costs'/><author><name>Sampath Vuluvala</name><uri>http://www.blogger.com/profile/14637292411768534520</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4637354759159188895.post-4647687586810748465</id><published>2012-07-11T12:07:00.003-04:00</published><updated>2012-07-11T14:58:28.318-04:00</updated><title type='text'>Integrity Check between F4111 Vs F43121 with join on F76432</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;br /&gt;
SELECT ILITM,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;ILLITM,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;ILMCU,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;ILGLPT,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;ILKCOO,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;ILDOCO,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;ILDCTO,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;ILLNID,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;ILDOC,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;ILDCT,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;(SELECT PJBNOP || PJBSOP&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; FROM PRODDTA.F76432&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;WHERE ILKCOO = PJKCOO&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;AND ILDOCO = PJDOCO&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;AND ILDCTO = PJDCTO&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;AND ILLNID = PJLNID&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;AND PJSFXO = &#39;000&#39;) &quot;TransNature_Suffix&quot;,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;(SELECT TO_DATE(CONCAT(&#39;20&#39;,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; CONCAT(SUBSTR(TO_CHAR(ILTRDJ), 2, 2),&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;SUBSTR(TO_CHAR(ILTRDJ), 4, 3))),&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&#39;YYYYDDD&#39;)&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; FROM DUAL) AS TRANSACTIONDATE,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;(SELECT TO_DATE(CONCAT(&#39;20&#39;,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; CONCAT(SUBSTR(TO_CHAR(ILDGL), 2, 2),&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;SUBSTR(TO_CHAR(ILDGL), 4, 3))),&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&#39;YYYYDDD&#39;)&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; FROM DUAL) AS GLDATE,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;SUM(ILTRQT / 1000),&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;SUM(ILPAID / 100)&lt;br /&gt;
&amp;nbsp; FROM PRODDTA.F4111&lt;br /&gt;
&amp;nbsp;WHERE ILDCT = &#39;OV&#39;&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND ILDGL &amp;gt;= 112153&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND ILDGL &amp;lt;= 112182&lt;br /&gt;
-- &amp;nbsp; AND ROWNUM &amp;lt;= 1000&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND NOT EXISTS (SELECT &#39;X&#39;&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; FROM PRODDTA.F43121&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;WHERE PRDOCO = ILDOCO&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;AND PRDCTO = ILDCTO&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;AND PRLNID = ILLNID&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;AND PRDOC = ILDOC&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;AND PRKCOO = ILKCOO)&lt;br /&gt;
&amp;nbsp;GROUP BY ILITM,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; ILLITM,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; ILMCU,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; ILGLPT,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; ILKCOO,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; ILDOCO,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; ILDCTO,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; ILLNID,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; ILDOC,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; ILDCT,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; ILTRDJ,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; ILDGL&lt;br /&gt;
&amp;nbsp;ORDER BY ILMCU, ILDOCO, ILDCTO;&lt;br /&gt;
---------------------------------------------------------------------------------------------------------&lt;br /&gt;
SELECT ILDCTO, COUNT(DISTINCT(ILDOC))&lt;br /&gt;
&amp;nbsp; FROM PRODDTA.F4111&lt;br /&gt;
&amp;nbsp;WHERE ILDCT = &#39;OV&#39;&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND ILDGL &amp;gt;= 112032&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND ILDGL &amp;lt;= 112060&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND ILKCO = &#39;00311&#39; --AND ROWNUM &amp;lt;=1000&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; -- &amp;nbsp; AND ILDcto = &#39;OP&#39;&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND NOT EXISTS (SELECT *&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; FROM PRODDTA.F43121&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;WHERE ILDOCO = PRDOCO&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;AND ILDCTO = PRDCTO&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; --AND ILLNID = PRLNID&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;AND ILDOC = PRDOC)&lt;br /&gt;
&amp;nbsp;GROUP BY ILDCTO&lt;br /&gt;
&amp;nbsp;ORDER BY ILDCTO ASC;&lt;br /&gt;
&lt;br /&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://jdekumar.blogspot.com/feeds/4647687586810748465/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://jdekumar.blogspot.com/2012/07/integrity-check-between-f4111-vs-f43121.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/4647687586810748465'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/4647687586810748465'/><link rel='alternate' type='text/html' href='http://jdekumar.blogspot.com/2012/07/integrity-check-between-f4111-vs-f43121.html' title='Integrity Check between F4111 Vs F43121 with join on F76432'/><author><name>Sampath Vuluvala</name><uri>http://www.blogger.com/profile/14637292411768534520</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4637354759159188895.post-2503889938424852097</id><published>2012-07-07T11:28:00.003-04:00</published><updated>2012-07-07T11:28:25.915-04:00</updated><title type='text'>Find Job Queues of all UBEs running</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;br /&gt;
&lt;br /&gt;
SELECT T1.JCPID, T0.JCJOBQUE, COUNT(*)&lt;br /&gt;
&amp;nbsp; FROM SVM812.F986110 T0, SVM812.F986114 T1&lt;br /&gt;
&amp;nbsp;WHERE T0.JCJOBNBR = T1.JCJOBNBR&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND T0.JCEXEHOST = &#39;ryelxjdlabtp&#39;&lt;br /&gt;
--AND T0.JCFNDFUF2 LIKE &#39;R31802A%&#39;&lt;br /&gt;
&amp;nbsp;GROUP BY T1.JCPID, T0.JCJOBQUE&lt;br /&gt;
&amp;nbsp;ORDER BY T1.JCPID, T0.JCJOBQUE;&lt;br /&gt;
&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://jdekumar.blogspot.com/feeds/2503889938424852097/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://jdekumar.blogspot.com/2012/07/find-job-queues-of-all-ubes-running.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/2503889938424852097'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/2503889938424852097'/><link rel='alternate' type='text/html' href='http://jdekumar.blogspot.com/2012/07/find-job-queues-of-all-ubes-running.html' title='Find Job Queues of all UBEs running'/><author><name>Sampath Vuluvala</name><uri>http://www.blogger.com/profile/14637292411768534520</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4637354759159188895.post-612570567114226966</id><published>2012-07-04T15:17:00.004-04:00</published><updated>2012-07-04T15:17:58.898-04:00</updated><title type='text'>Integrity between Cardex Vs As off</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;br /&gt;
SELECT ILITM, ILLITM, ILMCU, ILLOCN, ILLOTN, ILGLPT, INNQ06, SUM(ILTRQT)&lt;br /&gt;
&amp;nbsp; FROM PRODDTA.F4111, PRODDTA.F41112&lt;br /&gt;
&amp;nbsp;WHERE ILITM = INITM&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND ILMCU = INMCU&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND ILLOCN = INLOCN&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND ILLOTN = INLOTN&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND ILGLPT = INGLPT&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND INDCT = &#39;BF&#39;&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND INCTRY = 20&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND INFY = 12&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND ILIPCD = &#39;Y&#39;&lt;br /&gt;
&amp;nbsp; &amp;nbsp;--AND ILITM = 405239&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND ILMCU = &#39; &amp;nbsp; &amp;nbsp; 3110082&#39;&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND ILDGL &amp;gt;= 112153&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND ILDGL &amp;lt;= 112182&lt;br /&gt;
&amp;nbsp; &amp;nbsp;AND ILUKID &amp;gt;= 9257279 --AND ROWNUM &amp;lt;=100000&lt;br /&gt;
&amp;nbsp;GROUP BY ILITM, ILLITM, ILMCU, ILLOCN, ILLOTN, ILGLPT, INNQ06&lt;br /&gt;
&amp;nbsp;HAVING SUM(iltrqt) &amp;lt;&amp;gt; innq06;&lt;br /&gt;
&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://jdekumar.blogspot.com/feeds/612570567114226966/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://jdekumar.blogspot.com/2012/07/integrity-between-cardex-vs-as-off.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/612570567114226966'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4637354759159188895/posts/default/612570567114226966'/><link rel='alternate' type='text/html' href='http://jdekumar.blogspot.com/2012/07/integrity-between-cardex-vs-as-off.html' title='Integrity between Cardex Vs As off'/><author><name>Sampath Vuluvala</name><uri>http://www.blogger.com/profile/14637292411768534520</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry></feed>