321:
322: v_counter := 0;
323:
324: select count(*) into v_counter
325: from mtl_reservations
326: --where demand_source_type_id = 2
327: where demand_source_type_id =
328: decode (l_source_document_type_id, 10, inv_reservation_global.g_source_type_internal_ord,
329: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874
608: if upper(v_activity_status_code) = 'NOTIFIED' then
609:
610: v_counter := 0;
611: select count(*) into v_counter
612: from mtl_reservations
613: -- where demand_source_type_id = 2
614: where demand_source_type_id =
615: decode (l_source_document_type_id, 10, inv_reservation_global.g_source_type_internal_ord,
616: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874