APPS.WSH_USA_INV_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 6449: -- This procedure checks if Qtys are detailed in mtl_material_transactions_temp

6445:
6446: -- Description: This procedure was originally a function but because of
6447: -- OPM Convergence project, it was converted to a procedure to return
6448: -- Qty1 and Qty2.
6449: -- This procedure checks if Qtys are detailed in mtl_material_transactions_temp
6450: -- for a specific move order line id
6451: --
6452: PROCEDURE get_detailed_quantity (
6453: p_mo_line_id IN NUMBER,

Line 6467: from mtl_material_transactions_temp

6463: -- HW OPMCONV added Qty2
6464: cursor c_detailed_qty(p_line_id IN NUMBER) IS
6465: select sum(abs(transaction_quantity)) detailed_quantity,
6466: sum(abs(SECONDARY_TRANSACTION_QUANTITY )) secondary_detailed_quantity
6467: from mtl_material_transactions_temp
6468: where move_order_line_id = p_line_id;
6469:
6470: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PACKAGE_NAME || '.' || 'get_detailed_quantity';
6471: l_debug_on BOOLEAN;