Category Archives: scripts

Important Oracle Purchasing related queries/scripts

Posted on September 13, 2012 by Mr.KK

—Used to list all Internal Requisitions that do not have an  associated Internal Sales order   SELECT RQH.SEGMENT1 REQ_NUM,          RQL.LINE_NUM,          RQL.REQUISITION_HEADER_ID,          RQL.REQUISITION_LINE_ID,          RQL.ITEM_ID,          RQL.UNIT_MEAS_LOOKUP_CODE,          RQL.UNIT_PRICE,          RQL.QUANTITY,          RQL.QUANTITY_CANCELLED,          RQL.QUANTITY_DELIVERED, … Continue reading →

Posted in PO queries, scripts | Leave a comment

Useful oracle apps queries/ scripts/ codes/ tips

Posted on May 14, 2011 by Mr.KK

I am working on this blog post. For now i have placed only few scripts. Keep checking this post for further updates: How to get Login Passwords for application & Data Base instances How to add System administrator responsibility from … Continue reading →

Posted in codes, important queries in oracle apps, Oracle apps, scripts | Leave a comment