Sql Query to get Item wise lot quantity
Introduction/ Issue: This query will help us to get item wise lot quantity. Why we need to do / Cause of the issue: When we need to validate the lot quantity item wise, we…
Read Morescript to create safety stock in oracle apps r12
Introduction/ Issue: This code will help us to Create the safety stock in oracle inventory. Why we need to do / Cause of the issue: When business requires to create safety stock…
Read MoreScript to import standard purchase order
Introduction: This blog contains an plsql interface script to import standard purchase order. Script: DECLARE CURSOR PHEADER IS SELECT * FROM XX_PO_IMP_STG_TABLE; CURSOR PLINE (P_PO_NUMBER VARCHAR2) IS SELECT…
Read MoreQuery to get Journal Entry Reserve Ledger Report
Introduction: This blog contains an SQL query that can be used to run the Journal Entry Reserve Ledger Report. Cause of the issue: The business requires a report that contains…
Read More