APPS.CSP_FORECAST_PVT dependencies on CSP_USAGE_HISTORIES

Line 237: from csp_usage_histories

233: l_history_dates T_DATE_TABLE;
234:
235: cursor c_usage_history Is
236: select sum(quantity) usage_quantity
237: from csp_usage_histories
238: where parts_loop_id = nvl(p_parts_loop_id,parts_loop_id)
239: and organization_id = p_organization_id
240: and subinventory_code = nvl(p_subinventory_code,subinventory_code)
241: and inventory_item_id = p_inventory_item_id

Line 351: csp_usage_histories_pkg.insert_row(

347: l_forecast_qty := l_forecast_quantities(l_count);
348: Else
349: l_forecast_qty := 0;
350: End If;
351: csp_usage_histories_pkg.insert_row(
352: px_usage_id => l_usage_id,
353: p_created_by => fnd_global.user_id,
354: p_creation_date => sysdate,
355: p_last_updated_by => fnd_global.user_id,