APPS.WSH_USA_INV_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

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

7151:
7152: -- Description: This procedure was originally a function but because of
7153: -- OPM Convergence project, it was converted to a procedure to return
7154: -- Qty1 and Qty2.
7155: -- This procedure checks if Qtys are detailed in mtl_material_transactions_temp
7156: -- for a specific move order line id
7157: --
7158: PROCEDURE get_detailed_quantity (
7159: p_mo_line_id IN NUMBER,

Line 7173: from mtl_material_transactions_temp

7169: -- HW OPMCONV added Qty2
7170: cursor c_detailed_qty(p_line_id IN NUMBER) IS
7171: select sum(abs(transaction_quantity)) detailed_quantity,
7172: sum(abs(SECONDARY_TRANSACTION_QUANTITY )) secondary_detailed_quantity
7173: from mtl_material_transactions_temp
7174: where move_order_line_id = p_line_id;
7175:
7176: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PACKAGE_NAME || '.' || 'get_detailed_quantity';
7177: l_debug_on BOOLEAN;